Auto-order table columns for optimize disk space usage

Manage PostgreSQL table partitions

ActiveRecord extension for querying hstore and jsonb.

Adds methods to ActiveRecord::Migration to create and manage PostgreSQL objects in Rails

PostgreSQL PL/pgSQL stored procedure code coverage

Prosperity easily lets you add a dashboard of arbitrary time series data to your rails app.

https://github.com/0dayinc/pwn/README.md

Log inbound and outbound API requests in your Rails application

Generate ActiveRecord models from a pre-existing Postgres db

This gem provides a way to connect to AWS Redshift using the ruby-pg.

A service that uses a relational database inserts messages/events into an outbox table as part of the local transaction.

sequel-annotate annotates Sequel models with schema information. By default, it includes information on columns, indexes, and foreign key constraints for the current table. On PostgreSQL, this includes more advanced information, including check constraints, triggers, comments, and foreign keys constraints for other tables that reference the current table.

Small DSL to create ActiveRecord (>= 3.1) attribute predicates without writing SQL.

Provides easy DSL integration between ActiveAdmin & state_machine

Save unnecessary round trips to the database

An ActiveRecord plugin providing a higher-level abstraction for SQL 'LIKE' queries

From http://edgeguides.rubyonrails.org/active_record_migrations.html#types-of-schema-dumps: There is however a trade-off: db/schema.rb cannot express database specific items such as triggers, stored procedures or check constraints. While in a migration you can execute custom SQL statements, the schema dumper cannot reconstitute those statements from the database. If you are using features like this, then you should set the schema format to :sql. No longer is this the case. You can now use the default schema format (:ruby) and still preserve your check constraints.

Active Record support for PostgreSQL JSON type

This gem forwards to activerecord's default postgresql adapter

Amazon Redshift adapter for ActiveRecord 7+