search
Follow Topic
profile img

Bharat Dwarkani

Nov 07, 2019
bookmarks

linklogz.io

The public cloud is making a huge impact on the way enterprises host, manage, and scale their database operations. They’ve been freed from the scalability constraints of their on-premise systems. They can provision new infrastructure at the click of a button, without a lengthy hardware procurement process. They no longer need large, upfront capital investments to launch new IT projects. And they’re taking advantage of new, cloud-oriented technologies when storing and analyzing their data.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Nov 03, 2019
bookmarks

linklink.medium.com

One nice thing about PGSQL is it comes with some utility binaries like createuser and createdb. So we will be making use of that.

share
favorite_border0 visibility1
favorite_border0 visibility1 share
bookmarks
profile img

Bharat Dwarkani

Nov 02, 2019
bookmarks

linkrob.conery.io

FINE TUNING FULL TEXT SEARCH WITH POSTGRESQL 12

share
favorite_border0 visibility1
favorite_border0 visibility1 share
bookmarks
profile img

Bharat Dwarkani

Nov 02, 2019
bookmarks

linkcitrusleaf.in

Among the plethora of notable users of PostgreSQL are Reddit, Skype, Instagram, Tripadvisor, Met Office, Sony Online, BASF, Grofers and many more. These users are using PostgreSQL at an unprecedented scale.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Nov 02, 2019
bookmarks

linkcitrusleaf.in

Postgres is our favorite database system. No wonder, Postgres is world’s most advanced open source database! We’ll talk about some of the most powerful but rather lesser used features and aspects of Postgres in this post.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Nov 02, 2019
bookmarks

linklink.medium.com

Everyone was jumping on the bandwagon of NoSQL and we kept on the SQL side.

share
favorite_border0 visibility1
favorite_border0 visibility1 share
bookmarks
profile img

Mishel Vettukattil

Oct 19, 2019
bookmarks

linkgeekinsta.com

MySQL joins are used to fetch data from multiple tables. We can call it as a method for fetching records from one or more tables based on some common values in the table.

share
favorite_border0 visibility4
favorite_border0 visibility4 share
bookmarks
profile img

Bharat Dwarkani

Oct 11, 2019
bookmarks

linkibm.com

One of the highlights of PostgreSQL is its versatility, especially when you need a flexible data model. In this post, we’ll explore hstore, PostgreSQL’s simple key-value store, and take a look at how it works using a catalog of books.

share
favorite_border0 visibility1
favorite_border0 visibility1 share
bookmarks
profile img

Bharat Dwarkani

Oct 11, 2019
bookmarks

linkdev.to

Thinking about scaling beyond your Postgres cluster and adding another data store like Redis or Elasticsearch? Before adopting a more complex infrastructure, take a minute and think again. It’s quite possible to get more out of an existing Postgres database

share
favorite_border0 visibility3
favorite_border0 visibility3 share
bookmarks
profile img

Bharat Dwarkani

Sep 02, 2019
bookmarks

linkmssqltips.com

Transparent Data Encryption (TDE) performs real-time I/O encryption and decryption of the data and log files, thereby, protecting data at rest. You can use TDE with Availability Groups to provide security and high availability to your databases.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
add