search

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
visibility0
visibility0 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
visibility8
visibility8 share bookmarks

Database script for creating readonly user in PostgreSQL

Bharat Dwarkani wrote on May 10, 2020
image
sharetechlinks.com
bookmarks
share
visibility9
visibility9 share bookmarks

PostgreSQL 12 comes with a great new feature, Generated Columns. A Generated Column is a special column in a table that contains data automatically generated from other data within the row. The content of the generated column is automatically populated and updated whenever the source data, such as any other columns in the row, are changed them

Bharat Dwarkani shared on May 10, 2020
image
severalnines.com
bookmarks
share
visibility3
visibility3 share bookmarks

In Depth series of posts on managing PostgreSQL in different cloud vendors AWS, Digital Ocean, GCP, Azure

Bharat Dwarkani wrote on May 09, 2020
image
sharetechlinks.com
bookmarks
share
visibility2
visibility2 share bookmarks

Benchmark comparison of AWS Aurora, AWS RDS, Google Cloud Platform (Cloud SQL), Microsoft Azure PostgreSQL

Bharat Dwarkani wrote on May 09, 2020
image
sharetechlinks.com
bookmarks
share
visibility9
visibility9 share bookmarks

Considering the current major use-case of a database as to retrieve data, it becomes very important that its performance is very high and It can only be achieved if data is fetched in the most efficient possible way from storage. There have been many successful inventions and implementations done to achieve the same. One of the well known approaches adopted by most databases is to have an index on the table.

Bharat Dwarkani shared on May 09, 2020
image
severalnines.com
bookmarks
share
visibility4
visibility4 share bookmarks

When working with OLTP (OnLine Transaction Processing) databases, query performance is paramount as it directly impacts the user experience. Slow queries mean that the application feels unresponsive and slow and this results in bad conversion rates, unhappy users, and all sets of problems.

Bharat Dwarkani shared on May 09, 2020
image
severalnines.com
bookmarks
share
visibility0
visibility0 share bookmarks

As you may know, Microsoft SQL Server is very popular RDBMS with highly restrictive licencing and high cost of ownership if the database is of significant size, or is used by a significant number of clients. It provides a very user-friendly interface and easy to learn. This has resulted in a large installed user base. PostgreSQL is the world's most advanced open source database. The PostgreSQL community is very strong and continuously improving existing features and implementing new features. A

Bharat Dwarkani shared on May 09, 2020
image
severalnines.com
bookmarks
share
visibility4
visibility4 share bookmarks
add