search
Follow Topic rss_feed

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

Some times SQL DB_log.ldf takes up more server space in GBs to shrink and reduce the size of the log file to less than 15 MB from GB execute the below-mentioned script

Bharat Dwarkani shared on Aug 27, 2019
image
medium.com
bookmarks
share
visibility18
visibility18 share bookmarks

Azure Cosmos DB is a fully-managed database service with turnkey global distribution and transparent multi-master replication. You can run globally distributed, low-latency operational and analytics workloads and AI on transactional data within your database.

Bharat Dwarkani shared on Aug 20, 2019
image
docs.microsoft.com
bookmarks
share
visibility8
visibility8 share bookmarks

A brief post about what Firebase is all about, and it’s new NoSQL Database — Cloud Firestore. With a variety of server-side technologies that are on the market today, developers have a tough job of deciding what kind of backend is most suitable for their app.

Bharat Dwarkani shared on Aug 20, 2019
image
hackernoon.com
bookmarks
share
visibility3
visibility3 share bookmarks

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data.

Bharat Dwarkani shared on Aug 18, 2019
image
digitalocean.com
bookmarks
share
visibility2
visibility2 share bookmarks

SQL is a standard language for storing, manipulating and retrieving data in databases.

Bharat Dwarkani shared on Aug 17, 2019
image
w3schools.com
bookmarks
share
visibility11
visibility11 share bookmarks
add