postgresql


Dexter

The automatic indexer for Postgres.

PGHero

A performance dashboard for Postgres.

Timescale

An open-source time-series database fully compatible with Postgres for fast ingest and complex queries.

Postgres Query Plan Visualization

Tool for visualising query plans in PostgreSQL.

How I Reduced my DB Server Load by 80%

Good advice for Rails and PostgreSQL setups.

Web Developer Security Checklist

A growing list of security concerns for web applications.

Testing Huge PostgreSQL Backups for 37 Cents a Day

Testing Huge PostgreSQL Backups for 37 Cents a Day

Recover Data from Production Backups with ActiveRecord

When production data goes wrong.

Creating a multi-tenant site with rails

Good setup.

dbcli/pgcli

Postgres JSON Column Type in Rails 4