Kredis (Keyed Redis) encapsulates higher-level types and data structures around a single key, so you can interact with them as coherent objects rather than isolated procedural commands. These higher-level structures can be configu
The Chartable Ruby gem
The Chartable gem is a lightweight and database-level library to transform any Active Record query into analytics hash ready for use with any chart library.
Supported database engines: MySQL and
Multiple databases for Rails
One of the easiest ways to scale your database is to move large, infrequently-joined tables to a separate database. ActiveRecord supports multiple databases, but Rails
The automatic indexer for Postgres
Read about how it works
First, install HypoPG on your database server. This doesn’t require a restart.
Most pagination schemes use a fixed page size. Page 1 returns as many elements as page 2. But that's frequently not the most sensible way to page through a large recordset when you care about serving t
Relaxo is a transactional database built on top of git. It's aim is to provide a robust interface for document storage and sorted indexes. If you prefer a higher level interface, you can try relaxo-model.
language learning tools, written in Ruby + SQLite
These are meant to be run in the terminal (“command line”). Once you download this git repository, go into its directory in your terminal, and get ready to t
database_flusher is a tiny and fast database cleaner inspired by database_cleaner and database_rewinder.
No monkey patching - uses ActiveSupport::Notifications and Mongo::Monit
pg-eyeballs is a ruby gem that gives you detailed information about how the SQL queries created by the active record code you write are executed by the database. It gives you an easy, ruby friend
shift is an application that makes it easy to run online schema migrations for MySQL databases
Who should use it?
shift was designed to solve the following problem - running schema migrations manua
Postgres partitioning as easy as pie. Works great for both new and existing tables, with zero downtime and minimal app changes. Archive older data on a rolling basis to keep your database size under control.
QuineDB is a quine that is also a key/value store.
If your database can't print its own source code, can you really trust it?
QuineDB consists of the quinedb script in this repos
Seamless second database integration for Rails. SecondBase provides support for Rails to manage dual databases by extending ActiveRecord tasks that create, migrate, and test your databases.
Using SecondBase To Provide Some
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
Seed Dump is a Rails 4 and 5 plugin that adds a rake task named db:seed:dump.
It allows you to create seed data files from the existing data in your database.
You can also use Seed Dump from the Rails consol
lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
Foreigner introduces a few methods to your migrations for adding and removing foreign key constraints. It also dumps foreign keys to schema.rb.
The following adapters are supported:
If you're viewing this at https://github.com/DatabaseCleaner/database_cleaner, you're reading the documentation for the master branch. View documentation for the latest release (1.8.5).
The SchemaPlus family of gems provide various extensions and enhancements to ActiveRecord >= 4.2. There are two varieties:
Gems that provide new default automatic behavior These gems run with t
Scenic adds methods to ActiveRecord::Migration to create and manage database views in Rails.
Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schem
Please share this gem with your friends to get more feedback. I would really appreciate for the gem review if you have a blog. If you have ideas - please create an issue or contact me by email: igorkasyanchuk[@
Large Hadron Migrator
Rails style database migrations are a useful way to evolve your data schema in an agile manner. Most Rails projects start like this, and at first, making changes is fast and easy.
That is until y