If you reach a point that you need to scale beyond a single node, sharding becomes an appealing option. If you have a multi-tenant application, this post will help with how you should approach modelling your data.
Postgres is rich with index types, B-Tree for standard tables, GIN for full text search and JSONB, GiST for PostGIS. And if you’re curious on what actuallly happens under the covers there’s much more you can learn. This PgCon talk (videos and slides available) is a great guide to how the internals of index types work.
This month only, we're giving away free tshirts for all new deployments of Compose PostgreSQL. It takes just a couple minutes to signup and deploy a HA, 3-node Postgres cluster with daily backups and autoscaling. Give it a try.
In what may be the last of the responses to Uber’s post on moving from Postgres to MySQL, Simon Riggs of the Postgres core team takes a look at each of the major issues, provides a response, and best of all gives some insight for how Postgres roadmap may help address them.
ORMs can be nice to work with and you don’t always have to sacrifice the power of SQL when working with them. Here’s the first part of a series looking at taking advantage of more powerful SQL, like window functions, within Rails.