Database - Page 2 - Share Tech Links

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

10

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

Installing Redis on Windows using Docker Containers

Bharat Dwarkani shared on May 23, 2020

koukia.ca

#redis #docker

0

Postgresql as a Document Database and Event Store for .Net Applications

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

github.com

#postgre-sql #document-database

0

Fancy uses of JSON on PostgreSQL

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