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.

Support for Postgres Notify/Listen

PostgreSQL Adapter for Active Storage

Access postgres without blocking.

Perform background jobs and ask for the result in a simple way.

Birthday gem creates convienent methods for date and datetime fields in ActiveRecord, making it possible to look for birthdays without a hassle.

Based on heroku dataclips feature, SQL -> Dataset

Deploy smart, not hard.

Graph functionality for ActiveRecord

Imports Russian FIAS database into SQL (for Ruby on Rails on PostgreSQL projects)

fluent plugin to insert on PostgreSQL

Token auth for grape apps

GraphQL cursor-based stable pagination to work with Active Record relations

OneHQ GraphQL Library

Topological Inventory Persister

ManageIQ Appliance Console

Encrypt data in mass with Active Record Encryption

Oculus is a web-based logging SQL client. It keeps a history of your queries and the results they returned, so your research is always at hand, easy to share and easy to repeat or reproduce in the future.

OvirtMetrics is an ActiveRecord-based gem for reading the oVirt History database.

Take a peek into the Postgres queries made during your application's requests.