Ruby Database

Open-source Ruby projects categorized as Database

Top 23 Ruby Database Projects

  • Backup

    Easy full stack backup operations on UNIX-like systems.

    Project mention: Backup: Ruby Gem for Easy full stack backup operations on Unix-like systems | | 2022-07-30
  • Scenic

    Versioned database views for Rails

    Project mention: Database Views & Rails Active Record: defining new Model classes out of views | | 2023-01-23

    To model our Deliverable class, we will need a view. We will use the popular scenic gem, which provides some useful generators for creating views with their respective migrations, and utilities to handle views versioning.

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • counter_culture

    Turbo-charged counter caches for your Rails app.

    Project mention: counter_culture VS activerecord-slotted_counters - a user suggested alternative | | 2022-11-29
  • Lol DBA

    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.

  • Squasher

    Squasher - squash your old migrations in a single command

  • active_record_doctor

    Identify database issues before they hit production.

    Project mention: Many of us can face issues working with ActiveRecord due to its inconsistency with the database schema. That's why I have built database_consistency, which can help you avoid the most common issues and improve your application's performance. | | 2022-12-28

    Thank you for your contribution! How would you compare this gem to

  • SQL Server

    SQL Server Adapter For Rails

    Project mention: Ruby on Rails on windows server | | 2022-08-02
  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • DatabaseConsistency

    The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.

    Project mention: Uniqueness validation does not work since the beginning of Ruby on Rails. | | 2023-02-04

    DatabaseConsistency is a tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.

  • Polo

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

  • TinyTDS

    TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.

  • zero_downtime_migrations

    Zero downtime migrations with ActiveRecord 3+ and PostgreSQL

  • ronin

    Ronin is a free and Open Source Ruby toolkit for security research and development. Ronin also allows for the rapid development and distribution of code, exploits, payloads, etc, via 3rd party git repositories. (by ronin-rb)

    Project mention: Two months into learning Ruby, it is the most beautiful language I ever learned | | 2023-02-25

    Welcome! Ruby isn't exactly "dying", but the hype/popularity is definitely fading. This is primarily because Ruby is no longer "new", most of Ruby's popularity came from Rails, and now Rails is no longer the "new hotness". However, Ruby still has lots of awesome features and lots of awesome other libraries and frameworks, such as the new fancy irb gem that uses reline, nokogiri, chunky_png, the async gems, Dragon Ruby, SciRuby, Ronin, and the new Hanami web framework.

  • Hanami::Model

    Ruby persistence framework with entities and repositories

  • DatabaseValidations

    Database validations for ActiveRecord

    Project mention: Uniqueness validation does not work since the beginning of Ruby on Rails. | | 2023-02-04

    DatabaseValidations provides database-driven validations for ActiveRecord.

  • pg-osc

    Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

    Project mention: Changing Tires at 100mph: A Guide to Zero Downtime Migrations | | 2022-05-04

    Postgres has some less robust tooling, at least both of these carry the "experimental" tag:

    But, still, they do it for you.

  • QueryTrack

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

  • evil-seed

    A Gem for creating partial anonymized dumps of your database using your app model relations.

    Project mention: Master login to customer's account bad practice? | | 2023-02-10

    Since it can be challenging to replicate production DB issues exactly, I would recommend creating anonymized dumps of your data with something like

  • airrecord

    Ruby wrapper for Airtable, your personal database

    Project mention: Airtable integration | | 2023-03-17

    Never heard of Airtable, but is this something you're looking for?

  • postal-codes-json-xml-csv

    Collection of postal codes in different formats, ready for importing.

  • relaxo

    Relaxo is a transactional document database built on top of git.

  • deviser-club

    An open source blogging platform for devised people: Medium alternative

    Project mention: Rails with Svelte or React/NextJs? | | 2022-08-14

    As you can see here in my code, I have used Stimulus JS with TipTap Js, and it limits me to develop something like URL inserter...

  • active_record_distinct_on

    Support for `DISTINCT ON` statements when querying with ActiveRecord

    Project mention: How do I query for the most recently created records across multiple models ! | | 2022-06-20

    If you're using Postgres, then DISTINCT ON may also be a good option via the active_record_distinct_on gem.

  • sequel-snowflake

    Sequel adapter for Snowflake

    Project mention: ruby 3.2 unable to connect to database via odbc | | 2023-01-13

    Seems like the issue is the removal of tainted API – However, considering the gem hasn't been updated for over a decade, it might be best to search for an alternative as you said. I don't know which ORM you're using, but there is a Snowflake adapter for Sequel.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-03-17.

Ruby Database related posts


What are some of the best open-source Database projects in Ruby? This list will help you:

Project Stars
1 Backup 4,759
2 Scenic 3,134
3 counter_culture 1,719
4 Lol DBA 1,497
5 Squasher 1,407
6 active_record_doctor 1,306
7 SQL Server 951
8 DatabaseConsistency 789
9 Polo 729
10 TinyTDS 593
11 zero_downtime_migrations 555
12 ronin 535
13 Hanami::Model 441
14 DatabaseValidations 438
15 pg-osc 313
16 QueryTrack 286
17 evil-seed 271
18 airrecord 260
19 postal-codes-json-xml-csv 189
20 relaxo 172
21 deviser-club 95
22 active_record_distinct_on 24
23 sequel-snowflake 13
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives