JSON and JSONB are really powerful when working with Postgres, but it doesn’t mean they’re not without their quirks. Here we look at why text is typically the return value.

Disaster recovery and high availability are key in running and managing your database, whether on your own or as-a-service disaster can strike and you need to be prepared. Here’s a primer on what each is and how Citus Cloud implements both.

Postgres-XL is a Massively Parallel Database built on top of, and very closely compatible with PostgreSQL 9.5. It's flexible enough to handle simultaneous OLAP & OLTP workloads and is designed to be Horizontally Scalable.

A Go program which receives time series data via Graphite, Statsd, or even a Web pixel, stores it in PostgreSQL, and provides Graphite-like access to the data.

If you need a turnkey admin console for managing Postgres, PgDevOps may help. It’s a multi-user and multi-server Postgres web console for devops that features integration with pgAdmin4.

PipelineDB allows you to turn Postgres into a streaming database, but perhaps most exciting is it’s moving towards becoming an extension in future.

While the debate may be open for which OLTP database you want to use, Postgres has a pretty clear advantage over MySQL when it comes to analytics. It’s no surprise there’s a number of forks to make it even better as an analytical database with these features.

Guest writer Lucero Del Alba takes a look at how to get better performance out of JSONB data types in Postgres.