PostgreSQL Tasks and Functions for Ruby on Rails

Test postgresql scripts and run queries against a temporary postgresql instance

This small Ruby gem helps you integrate PostgreSQL with your Ruby web app, through Liquibase. It also adds a simple connection pool and query processor, to make SQL manipulation simpler.

Store translations in your PG database as HSTORE, JSON or JSONB.

Trigram similarity, guaranteed equivalent to postgres's. Oh yeah.

Handy helpers to create PostgreSQL Triggers

Extensions to pg gem supporting typecasting.

Manage PostgreSQL custom types (composite types, enums, domains) in your Rails application with versioned migrations and schema handling. This cuts the need for keeping a structure.sql while still maintaining proper type definitions in your Rails application.

PostgreSQL notifications with persistence.

A pure ruby "thin" extension of pg that provides logging, transaction retrying, and database reconnecting functionality.

postgresql xml datatype support for activerecord -- heavily based on pg-hstore and activerecord-postgres-hstore

a plugin for tssearch support from postgresql

Provide an health check API

Phobos DB Checkpoint is a plugin to Phobos and is meant as a drop in replacement to Phobos::Handler

Helper for building docker images.

Schema migration tool for checking and adding comments on PII columns.

Access the Pinnacle Sport API.

An endpoint to define with your Plaid integration to receive updates about transactions and account information

Pliable makes integrating a Rails project with Schemaless data not so painful

Plone REST api library and command