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.

Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).

Zero downtime migrations with ActiveRecord 3+ and PostgreSQL

Migrate data along with schema migrations in Rails and keep them up to date.

Wipe out inconsistent DB and schema.rb when switching branches. To do that, install this gem and use the standard rake db:migrate command.

Seamless second database integration for Rails.

Integrate PostgreSQL's enumerated types with the Rails enum feature

Automatically add foreign key constraints to your rails db

Rails migration files generate into corresponding modular directories

Capture SQL generated by ActiveRecord migrations.

Let's you write slightly slimmer Rails migrations.

Structure and data migrations as one.

The Blog app will be a classic example of a blog website. You will create a fully functional website that will show the list of posts and empower readers to interact with them by adding comments and liking posts.

This project is built using Ruby on Rails as an API. It's a simple API connected to a PostgreSQL database designed for storing greeting messages. The API has a single endpoint which randomly selects one of these messages to send to the frontend.

Ruby application support for Apache Cassandra

Service for running database migrations

Ruby on Rails Help Out Guide

An adapter for the fx gem to support versioned trigger/function/procedure migrations for SqlServer/MsSQL

Flatiron Full Stack Web Development Curriculum & Labs - ActiveRecord, ORM and Rack

Simple schema migrations for PostgreSQL, which runs pure SQL.