A look at how sequential rows in a table can end up with ‘out of order’ timestamps due to the way Postgres manages times within transactions.

While Postgres is a great piece of software sometimes how the pudding gets made isn’t as pretty. While community members have good intentions, sometimes they just don’t see eye to eye. Here’s a bit of inside baseball among the community.

We often get asked by our customers about how to find skilled Postgres resources for their team. With Postgres training and certification from EDB, you may have that extra something an employer is looking for, to set you apart. Check out the Foundations course to get started or look over our advanced classes. Keep your skills sharp and stay competitive.

Peter Geoghegan explains Postgres 9.5’s recently-committed UPSERT feature in this 20 minute presentation.

It’s not easy, but some people fight MySQL’s corner pretty well.

This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.

Upsert isn’t the only new thing in Postgres 9.5, and while we’re still several months away from 9.5’s release the wiki is starting to show a great picture of what’s new including a brand new index type.

The standard index in Postgres, a BTree index is often what you want. But, Postgres has a variety of other types, including BRIN with 9.5.

Postgres has a lot of awesome datatypes, but if you can’t easily use them in your web framework then they’re much less useful. This post walks through several awesome and less common ones including hstore and arrays in Django.

A look at how common ActiveRecord validations port to Postgres constraints in SQL.

Guidebook helps people build and publish mobile apps for all types of devices. Our CMS is a huge part of that and you will play a key part in building our new CMS by collaborating with our design and back-end development teams to implement mockups and integrate with our back-end stack.