~rubyweekly | Bookmarks (3)

Don't Know How to Pick Indexes for Postgres + Rails? Try Out pganalyze — The new pganalyze Index Advisor 3.0 finds missing indexes across your query workload. Configurable, with easy drill-down into the underlying model.

Free eBook: 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 so you can follow along.

Introducing pg_query for Postgres 16 — pg_query is a long standing library for turning SQL queries into parse trees, by way of Postgres's own SQL parser. This new version is based on the Postgres 16 parser, supports SQL/JSON, and now works on Windows too.