search
Follow Topic rss_feed

FINE TUNING FULL TEXT SEARCH WITH POSTGRESQL 12

Bharat Dwarkani shared on Nov 02, 2019
image
rob.conery.io
bookmarks
share
visibility1
visibility1 share bookmarks

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.

Bharat Dwarkani shared on Nov 02, 2019
image
citrusleaf.in
bookmarks
share
visibility2
visibility2 share bookmarks

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.

Bharat Dwarkani shared on Nov 02, 2019
image
citrusleaf.in
bookmarks
share
visibility5
visibility5 share bookmarks

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

Bharat Dwarkani shared on Nov 02, 2019
image
link.medium.com
bookmarks
share
visibility1
visibility1 share bookmarks

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.

Mishel Vettukattil shared on Oct 19, 2019
image
geekinsta.com
bookmarks
share
visibility4
visibility4 share bookmarks

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.

Bharat Dwarkani shared on Oct 11, 2019
image
ibm.com
bookmarks
share
visibility1
visibility1 share bookmarks

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

Bharat Dwarkani shared on Oct 11, 2019
image
dev.to
bookmarks
share
visibility12
visibility12 share bookmarks

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.

Bharat Dwarkani shared on Sep 02, 2019
image
mssqltips.com
bookmarks
share
visibility2
visibility2 share bookmarks

An important option to be considered during restricting unauthorized access to data is to encrypt data so that even if somebody was able to reach to data it is not discernable by a simple query. Since critical information like credit card numbers are stored in column or two, it does not make sense to encrypt the complete database or database files.

Bharat Dwarkani shared on Sep 02, 2019
image
mssqltips.com
bookmarks
share
visibility2
visibility2 share bookmarks

Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache and message broker. It supports various data structures such as Strings, Hashes, Lists, Sets etc.

Bharat Dwarkani shared on Sep 02, 2019
image
link.medium.com
bookmarks
share
visibility4
visibility4 share bookmarks
add