SQL is powerful and especially so in Postgres. If you rely on your ORM a bit too much here are some great examples of when you should take a deeper look at how simply some things can be done with raw SQL in Postgres.

Postico is the successor to PG Commander, one of the few solid OS X GUI clients for working with and managing Postgres.

Whether you’re an established professional or new to Postgres, our training will give you the expertise you need in Postgres 9.4. Accelerate your learning with live training taught by Postgres Community Leader Bruce Momjian. 20% off for Postgres Weekly subscribers with promo code COMB-PGW-01

A basic 3 tier application can get you pretty far when using Postgres, but sometimes you grow beyond that and have to change your architecture. Look at how this demo app and architecture could get you to a scale of 1 million users.

Building a distributed database is a task many take on, often because you’ve reached to need to tackle a new scale. There’s plenty to be learned from others who’ve tackled this, and this article provides some guidance.

Here’s a thought piece that talks about in-memory, which is undoubtedly faster but lacks certain guarantees around… well not losing your data.

For all the progress we’ve made on new and modern languages, getting set up with a local development can still be far too much of a pain. This guide gets you up and running on Rails with Postgres and Redis on Windows.

If you don’t want to think about SQL, ORMs are the way to go. Here’s yet another one, this time in JavaScript and targeted at both Postgres and MySQL.