Triggers in PostgreSQL: Love them or hate them? [PGSQL Phriday #007]
Triggers are a powerful tool in PostgreSQL. However, they can be a double-edged sword, causing confusion and performance issues if not used carefully.
High availability made easy: A 100,000 ft view of auto failover in PostgreSQL
Critical data needs a resilient database that businesses can rely on. This write-up takes an abstract view of High Availability and Auto-Failover in PostgreSQL.
Big Data and PostgreSQL – Scaling out by partitioning tables
Big Data is a buzz word doing the rounds nowadays, and the tool people generally associate with Big Data is Hadoop. While it is true that the sheer volume of data Hadoop can efficiently and cost effectively manage is unparalleled, not all businesses actually need Hadoop.
HOWTO use JSONB, the binary formatted JSONs in PostgreSQL
A previous blog I wrote on JSON functionality in PostgreSQL went wildly popular and it got me thinking about writing a follow-up HOWTO about JSONB.
JSONB, like JSON, is a native data type in PostgreSQL and was introduced in version 9.4. The major difference between the types is signified in the name; the extra ‘B’ stands for binary format. Some more detailed comparison is given in the table below:
HOWTO handle key-value data in PostgreSQL – the HSTORE contrib
I previously blogged about NoSQL support in PostgreSQL and then later wrote a tutorial on using JSON data type. Today, I will be talking about another angle of NoSQL in PostgreSQL, handling key-value data using the HSTORE contrib module.