If you’ve got a system that has high throughput and churn of data, transaction IDs can start to write over themselves, writing over data. In most cases Postgres’ vacuum will keep up, but otherwise here’s how to handle it.

An extension of PostgreSQL (9.5devel only for now) that can offload several CPU intensive workloads to GPU devices to use their massive parallel execution capabilities.

On Hired, we'll bring the options to you. With over 2,000 pre-screened tech companies in 10 cities in the US UK, you'll be sure to find what you're looking for. Join Hired today.

Everyone is used to documenting their code, but something that’s seldom done is documenting databases. It’s assumed that columns are clearly named, but even in the most clear database being explicit about what something is and how it works is valuable.

If you’ve already got your data in Postgres, but want to consume it as a stream to allow more systems to consume and process that data, here’s a tool to help. ‘Bottled Water’ takes Postgres data and streams it directly to Kafka.

SQL is incredibly powerful, much more so than something like Google Analytics for the ways you can inspect data. If you want and need that flexibility here’s an awesome high level guide for rolling your own home grown analytics system.

Upsert is coming in Postgres 9.5, but many have been using other versions with CTEs for some time now as a work around. Unfortunately this can be unsafe for your data, so you should definitely swap to 9.5 when it’s available.

A look at how one company has extended Postgres and turned it into a streaming database. The big use case here is around large amounts of data where you’d need to do rollups.

A versioning approach for PostgreSQL using triggers and server-side functions in PL/pgSQL.

The Database Engineer role will be responsible for automation, instrumentation, and tooling to accelerate database development, change management, deployment, monitoring, and operational support.

Namely is an agile startup dedicated to building an end-to-end HR platform for businesses of all sizes. We’re looking for a skilled developer to contribute ideas, innovation, solutions and code to our product.