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.
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.
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.