Databases

Provides data about world cities in Ruby. Data from the Maxmind database.

ActiveWarehouse ETL is a pure Ruby Extract-Transform-Load application for loading data into a database.

Data anonymization tool for RDBMS and MongoDB databases

Let ActiveRecord serialize and cast your UUIDs to and from binary columns in your database.

Switching database connection between readonly one and writable one.

Different relational databases treat text search very differently. DbTextSearch provides a unified interface on top of ActiveRecord for SQLite, MySQL, and PostgreSQL to do case-insensitive string-in-set querying and CI index creation, and basic full-text search for a list of terms, and FTS index creation.

This plugin provides native MySQL instrumentation for monitoring and metrics collection, including: service health, database connectivity, `InnoDB` locks, replication status, metrics collection, and sending metrics to a MySQL database.

Power Enum allows you to treat instances of your ActiveRecord models as though they were an enumeration of values. It allows you to cleanly solve many of the problems that the traditional Rails alternatives handle poorly if at all. It is particularly suitable for scenarios where your Rails application is not the only user of the database, such as when it's used for analytics or reporting.

Referencing code in app/ from a database migration risks breaking the migration when your app code changes; this gem prevents that mistake

Fluentd Filter plugin to add information about geographical location of IP addresses with Maxmind GeoIP databases.

Kills postgres connections during db:reset so you don't have to restart your server. Fixes "database in use" errors.

Tracking exceptions for Rails application store them in database by exception_notification gem.

Solano CI runs your test suite simply and quickly in our managed cloud environment. You can run tests by hand, or enable our hosted CI to watch your git repos automatically. Solano CI automatically and safely parallelizes your tests to save you time, and takes care of setting up fresh isolated DB instances for each test thread. Tests have access to a wide variety of databases (postgres, mongo, redis, mysql, memcache), solr, sphinx, selenium/webdriver browsers, webkit and culerity. Solano CI supports all common Ruby test frameworks, including rspec, cucumber, test::unit, and spinach. Solano CI also supports Javascript testing using jasmine, evergreen, and many other frameworks.

Simple background job processor inspired by delayed_job, but aiming for database agnosticism.

Rfm is a standalone database adapter for Filemaker server. Ginjo-rfm features multiple xml parser support, ActiveModel integration, field mapping, compound queries, logging, scoping, and a configuration framework.

Database enforced timestamps, immutable columns, counter/sum caches, and touch propogation

Rake task for backing up mongo database on heroku and push it to S3 or FTP. Library can be used as rake task or be easily integrated into daily cron job.

Ruby bindings for the FoundationDB database. Complete documentation of the FoundationDB Ruby API can be found at: https://apple.github.io/foundationdb/api-ruby.html.

Strategies for cleaning databases using Redis. Can be used to ensure a clean state for testing.

ActiveRecord provides validations on app level but it won't guarantee the consistent. In some cases, like `validates_uniqueness_of` it executes additional SQL query to the database and that is not very efficient. The main goal of the gem is to provide compatibility between database constraints and ActiveRecord validations with better performance and consistency.

There may be times when you don't want documents to actually get deleted from the database, but "flagged" as deleted.

To have all your data in one place: the database

Connection proxy for ActiveRecord for single master / multiple slave database deployments

Regressor generates regression specs based on ActiveRecord models. Currently relations, validations, attributes, and database indexes are supported.

BigSitemap is a Sitemapgenerator suitable for applications with greater than 50,000 URLs. It splits large Sitemaps into multiple files, gzips the files to minimize bandwidth usage, batches database queries to minimize memory usage, supports increment updates, can be set up with just a few lines of code and is compatible with just about any framework.

Multidb is an ActiveRecord extension for switching between multiple database connections, such as primary/replica setups.

SchemaAssociations extends ActiveRecord to automatically create associations by inspecting the database schema. This is more more DRY than the standard behavior, for which in addition to specifying the foreign key in the migration, you must also specify complementary associations in two model files (e.g. a :belongs_to and a :has_many).

JRuby gem for performing multidimensional queries of relational database data using Mondrian OLAP Java library

Easily run queries on shard and replica databases.

IBM Cloud Databases Ruby SDK

Polo travels through your database and creates sample snapshots so you can work with real world data in development.

This module is Ruby binding for DuckDB database engine. You must have the DuckDB engine installed to build/use this module.

Rmre creates ActiveRecord models for legacy database with all constraints found.

GitModel persists Ruby objects using Git as a data storage engine. It's an ActiveModel implementation so it works stand-alone or in Rails 3 as a drop-in replacement for ActiveRecord or DataMapper. Because the database is a Git repository it can be synced across multiple machines, manipulated with standard Git client tools, can be branched and merged, and of course keeps the history of all changes.

ar_mailer is a two-phase delivery agent for ActionMailer. Even delivering email to the local machine may take too long when you have to send hundreds of messages. ar_mailer allows you to store messages into the database for later delivery by a separate process, ar_sendmail.

This plugin provides native Redis instrumentation for monitoring and metrics collection, including: service health, database connectivity, replication status, `INFO` metrics, key counts, list lengths, and more.

PluginFactory is a mixin module that turns an including class into a factory for its derivatives, capable of searching for and loading them by name. This is useful when you have an abstract base class which defines an interface and basic functionality for a part of a larger system, and a collection of subclasses which implement the interface for different underlying functionality. An example of where this might be useful is in a program which talks to a database. To avoid coupling it to a specific database, you use a Driver class which encapsulates your program's interaction with the database behind a useful interface. Now you can create a concrete implementation of the Driver class for each kind of database you wish to talk to. If you make the base Driver class a PluginFactory, too, you can add new drivers simply by dropping them in a directory and using the Driver's `create` method to instantiate them:

Finding time-consuming database queries for ActiveRecord-based Rails Apps

GitLab fork. YamlDb is a database-independent format for dumping and restoring data. It complements the the database-independent schema format found in db/schema.rb. The data is saved into db/data.yml. This can be used as a replacement for mysqldump or pg_dump, but only for the databases typically used by Rails apps. Users, permissions, schemas, triggers, and other advanced database features are not supported - by design. Any database that has an ActiveRecord adapter should work

RDBI is a rearchitecture of the Ruby/DBI project by its maintainer and others. It intends to fully supplant Ruby/DBI in the future for similar database access needs.

Administrative database front-end for multiple web-frameworks and ORMs

Adds support in ActiveRecord for foreign_keys, complex indexes and other database-related stuff. Easily create foreign_keys, complex indexes and views.

Use this SDK to access the Looker API. The Looker API provides functions to perform administrative tasks such as provisioning users, configuring database connections, and so on. It also enables you to leverage the Looker data analytics engine to fetch data or render visualizations defined in your Looker data models. For more information, see https://looker.com.

Define native database types and change default migration behavior in ActiveRecord/Rails.

Wrap model properties into a single database column and declare properties from within the model.

Tenacity provides a database client independent way of specifying simple relationships between models backed by different databases.

Lookup IPv4 and IPv6 addresses in Maxmind GeoIP2 database files

Seed Fu is an attempt to once and for all solve the problem of inserting and maintaining seed data in a database. It uses a variety of techniques gathered from various places around the web and combines them to create what is hopefully the most robust seed data system around.

SQLDroid is a JDBC driver for Android's sqlite database (android.database.sqlite.SQLiteDatabase).

Makes use of SQLite3 in-memory database possible for your Rails tests by preloading the schema.