Connect Claude Code, Codex & Cursor to your Postgres statistics: pganalyze MCP Server is now in Public Preview

Advanced Database Programming with Rails and Postgres

Learn about subqueries, materialized views, and custom data types in Postgres and Rails. We walk through realistic real-life examples, translating first into SQL, and then into Rails code. Every example comes with source code to follow along.

Ebook Cover Image

In this book you will learn:

  • Using Active Record and subqueries in Rails
  • Using views and materialized views
  • Creating custom Postgres data types (domain types and composite types)

Download this eBook


Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze

Atlassian
Autotrader
Moody's
Salsify
Fivetran
fuboTv