The maturity of database-as-a-service providers has improved a lot. Whether Heroku Postgres or Amazon RDS, there are now fewer reasons to manage your own. Here’s a guide on how The Guardian migrated with no downtime from their own hosted instance to RDS.
Database performance tuning still remains a magical art for many developers, but this post walks through everything you need to know to get started assessing and improving queries.
Vitesse DB Enterprise Edition is PostgreSQL for OLAP/BI enhanced with builtin multi-threading, LLVM JIT and compressed column store. Find out how this PostgreSQL solution for Data Warehouse or Data Mart can work for you.
We’ve linked to a few ‘Postgres as a Document Store using JSONB’ posts. Here’s another that takes it one step further and converts some of those documents back to normalized data.
Logical decoding has laid some great groundwork for things you can do with Postgres. This deck from Postgres Open walks through what logical decoding is and some example uses of it.
If you’re using a framework you likely already have an ORM. If you’re using more a more direct approach in Python, however, this package aims to make working with Postgres directly simpler.
We're in demand ....and that means you could be too! Due to our continued growth we're looking for people with relevant PostgreSQL skills and experience. Check out our vacancies.
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.