Database - Share Tech Links

tbls is a CI-Friendly tool for document a database, written in Go

tbls is a CI-Friendly tool for document a database, written in Go. Key features of tbls are: Document a database automatically in GFM format. Output database schema in many formats. Single binary = CI-Friendly. Support many databases. Work as linter for database

Bharat Dwarkani shared on May 29, 2020

github.com

#postgre-sql #documentation

2

PostgreSQL - A multi purpose underrated open source database capable of handling RDMS and NoSQL functionalties

PostgresSQL is a multipurpose database capable of being used as a RDMS, NoSQL, TimeSeries, Queing, Analytics purpose database. Postgres 13.1 released and PgConf 2020 on going

Bharat Dwarkani wrote on May 28, 2020

sharetechlinks.com

#postgre-sql #blog

8

Millisecond Marketing with Trillions of User Tags Using PostgreSQL

By taking advantage of just two small PostgreSQL functions, we are able to solve one of the biggest long-term problems plaguing the industry. The recommendation system is the backbone of any advertising platform. A proper recommendation system must be precise, real-time, and highly efficient.

Bharat Dwarkani shared on May 24, 2020

alibabacloud.com

#postgre-sql #tagging-system

2

Postgres - Don't Do This

Dont so this things in postgres

Bharat Dwarkani shared on May 24, 2020

wiki.postgresql.org

#postgre-sql

0

Picking a Database for Analytics: PostgreSQL vs. MySQL

In case you're using MySQL as your transactional database, our recommendation is to seriously consider using PostgreSQL as your analytical database.

Bharat Dwarkani shared on May 24, 2020

silota.com

#postgre-sql

6

Faster Operations with the JSONB Data Type in PostgreSQL

Since version 9.4, PostgreSQL offers a significant speedup when using the binary representation of JSON data, jsonb, which can give you that extra edge you need to increase your performance. The data types json and jsonb, as defined by the PostgreSQL documentation,are almost identical; the key difference is that json data is stored as an exact copy of the JSON input text, whereas jsonb stores data in a decomposed binary form; that is, not as an ASCII/UTF-8 string, but as binary code.

Bharat Dwarkani shared on May 24, 2020

compose.com

#postgre-sql

8

Postgres Cheatsheet

Cheatsheet for Postgres

Bharat Dwarkani shared on May 23, 2020

postgrescheatsheet.com

#postgre-sql #cheat-sheet

6

Virtual computed columns in PostgresSQL

A generated column is a special column that is always computed from other columns. Thus, it is for columns what a view is for tables.

Bharat Dwarkani shared on May 23, 2020

rob.conery.io

#postgre-sql

6

A pure PostgreSQL Document database API

One of the great things about PostgreSQL is its support for JSON document storage. It’s probably the most underrated feature of PostgreSQL, and for a simple reason: the API is a bit clunky.

Bharat Dwarkani shared on May 23, 2020

rob.conery.io

#postgre-sql #no-sql

0

Exploring Redis with Docker

This tutorial shows how you can use Docker to explore Redis. You can run the commands with Docker installed, or Docker for Windows in Linux mode. But you can also use Play with Docker to try this out.

Bharat Dwarkani shared on May 23, 2020

markheath.net

#redis #docker

0