search
Follow Topic rss_feed

Comparing the Relational Database Management System to the Object-Relational Database Management System

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

In this blog post, we will see how you can use Redis as an in-memory database, why you'd want to use Redis, and finally we'll discuss a few important features of the database.

Bharat Dwarkani shared on Apr 15, 2021
image
freecodecamp.org
bookmarks
share
visibility0
visibility0 share bookmarks

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.

Bharat Dwarkani shared on Dec 02, 2020
image
levelup.gitconnected.com
bookmarks
share
visibility11
visibility11 share bookmarks

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.

Bharat Dwarkani shared on Oct 07, 2020
image
medium.com
bookmarks
share
visibility16
visibility16 share bookmarks

PostgreSQL's explain analyze made readable

Bharat Dwarkani shared on Jul 06, 2020
image
explain.depesz.com
bookmarks
share
visibility10
visibility10 share bookmarks

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

Bharat Dwarkani shared on Jul 06, 2020
image
depesz.com
bookmarks
share
visibility0
visibility0 share bookmarks

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!

Bharat Dwarkani shared on Jun 27, 2020
image
medium.com
bookmarks
share
visibility9
visibility9 share bookmarks

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.

Bharat Dwarkani shared on Jun 24, 2020
image
infoworld.com
bookmarks
share
visibility6
visibility6 share bookmarks

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.

Bharat Dwarkani shared on Jun 04, 2020
image
m.habr.com
bookmarks
share
visibility0
visibility0 share bookmarks

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
add