jsonb_to_recordset(jsonb data) This function is particularly useful when you have an Array of Objects and want to query against the Values of one or more Keys using standard comparison operators including wildcards.

How to query JSONB, beginner sheet cheat. Let’s say we have to query a user table with a metadata JSONB column on a PostgreSQL 9.5+ database.

PostgreSQL's explain analyze made readable

One of the first things new DBA hears is “Use the EXPLAIN". And upon first try he/she is greeted with incomprehensible

Welcome to this practical, non-exhaustive guide to some of the common issues you’ll encounter while using Postgres. We’ll go beyond the basic advice of adding indices to your queries using sequential scans. There are also a few extra tips for those using the AWS RDS service. Enjoy!

Like many, you might think of Redis as only a cache. That point of view is out of date. Essentially, Redis is a NoSQL in-memory data structure store that can persist on disk. It can function as a database, a cache, and a message broker. Redis has built-in replication, Lua scripting, LRU eviction, transactions, and different levels of on-disk persistence. It provides high availability via Redis Sentinel and automatic partitioning with Redis Cluster.

When using locks, we can confront a deadlock. It occurs when one transaction tries to acquire a resource that is already in use by another transaction, while the second transaction tries to acquire a resource that is in use by the first.

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

PostgreSQL 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

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.