search
Follow Topic rss_feed

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
visibility10
visibility10 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

Installing Redis on Windows using Docker Containers

Bharat Dwarkani shared on May 23, 2020
image
koukia.ca
bookmarks
share
visibility0
visibility0 share bookmarks

The Marten library provides .NET developers with the ability to use the proven PostgreSQL database engine and its fantastic JSON support as a fully fledged document database. The Marten team believes that a document database has far reaching benefits for developer productivity over relational databases with or without an ORM tool.

Bharat Dwarkani shared on May 23, 2020
image
github.com
bookmarks
share
visibility0
visibility0 share bookmarks

It’s been a while since PostgreSQL implemented support for JSON columns in its tables. Basic at the beginning, now it offers a lot of functionality that can come in handy when you have a PostgreSQL database, and make use of some of its cool stuff (like the ton of functions of PostGIS), but also need to store some non-structured data or with a user-defined schema.

Bharat Dwarkani shared on May 22, 2020
image
link.medium.com
bookmarks
share
visibility4
visibility4 share bookmarks

Directly query custom PostgreSQL functions in the GraphQL API

Bharat Dwarkani shared on May 22, 2020
image
github.com
bookmarks
share
visibility2
visibility2 share bookmarks

How you can set up your local development database using docker. Fast and simple.

Bharat Dwarkani shared on May 17, 2020
image
towardsdatascience.com
bookmarks
share
visibility10
visibility10 share bookmarks
add