search
Follow Topic rss_feed

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
image
github.com
bookmarks
share
visibility2
visibility2 share bookmarks

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
image
sharetechlinks.com
bookmarks
share
visibility8
visibility8 share bookmarks

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
image
alibabacloud.com
bookmarks
share
visibility2
visibility2 share bookmarks

Dont so this things in postgres

Bharat Dwarkani shared on May 24, 2020
image
wiki.postgresql.org
bookmarks
share
visibility0
visibility0 share bookmarks

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
image
silota.com
bookmarks
share
visibility6
visibility6 share bookmarks

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
image
compose.com
bookmarks
share
visibility8
visibility8 share bookmarks

Cheatsheet for Postgres

Bharat Dwarkani shared on May 23, 2020
image
postgrescheatsheet.com
bookmarks
share
visibility6
visibility6 share bookmarks

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
image
rob.conery.io
bookmarks
share
visibility6
visibility6 share bookmarks

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
image
rob.conery.io
bookmarks
share
visibility0
visibility0 share bookmarks

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
image
markheath.net
bookmarks
share
visibility0
visibility0 share bookmarks
add