Sometimes it’s not just when a system goes down that you care about data loss or change, sometimes it can be due to operator error. When that happens there’s a chance you already have the underlying pieces to correct it and if not may want to consider this read.

This primer covers how your data is actually stored under the covers. It’s not required to know how the internals of data storage actually work to use Postgres, but it may still be helpful and interesting to you.

EDB, the leader in services for Postgres, is the FIRST and ONLY organization to provide official PostgreSQL 9.5 training courses and Certification exams only weeks after the 9.5 release to the community. Be one of the first to train and certify on PostgreSQL 9.5!

One of the first write-ups about upsert that clearly lays out how it can be used with a very practical example.

For most frameworks it’s common for you to set a default value when you add a new column, the problem is this can cause a full table re-write and hold a lock–read: not good. There’s a few methods to work around this.

Join the Heroku Data team and learn about supporting and operating database systems at scale.

While objection.js has had some support for JSON for a little while now, it now has full docs and guides to get you up and running. It joins Massive.JS as a great option for JSON in Node, while still supporting all the greatness that is Postgres.

There are a lot of ways to roll a full text search system (such as with Elasticsearch) but if your data is already in Postgres you may have a good enough solution already sitting right there to use.

PipelineDB is a Postgres 9.4-based streaming analytics database.

Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today!