PostgreSQL partitioning assistant for Rails

ActiveRecord::Migration utility for creating partitions in PostgreSQL.

ActiveRecord extensions for PostgreSQL. Provides useful tools for schema, foreign_key, index, comment and extensios manipulations in migrations.

Shows the top queries running on your server using pg_stat_statements

pg_query_optimizer is a gem that improving the performance of complex queries specifically desingned for postgress database. This query significantly improves query execution times for large datasets.

Some experimentations with LISTEN/NOTIFY for background jobs

Web interface for pgq gem. Inspect pgq and londiste queues

Rails goodies.

Easily use randomized keys instead of sequential values for your record surrogate ids.

Postgres replication protocol

REST API for remote PostgreSQL database migrations.

Simple schema migrations for PostgreSQL, which runs pure SQL.

serializes rails models from postgres (9.5+)

pg_shrink makes it simple to shrink and sanitize a PosrgreSQL database

Construct composable, structured, PostgreSQL queries in plain Ruby.

A collection of Postgres data definition SQL builders

pg_space_cadet is a simple hack for postgreSQL and ActiveRecord which provides a uuids table of distributable identities of space cadets -- ActiveRecord::Base instances which use the SpaceCadetWrapper. Each space cadet has a default ActiveRecord id unique in the set of all local space cadets; a space cadet's id is derived from its uuid - UUID's are by design universally distributable.

Helper class for setting up and easily tearing down PostgreSQL database objects within a testing environment

Stream data from postgres or Redshift

A gem that makes working with tags stored in a Postgresql column easy. Support for array of string, integer and jsonb values.