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 VS database - a user suggested alternative | libhunt.com/r/backup | 2023-06-21
  • Scenic

    Versioned database views for Rails

  • Project mention: How to avoid N+1 query using SQL views (materialized) in Rails application | dev.to | 2024-05-14

    *Scenic* gem

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • counter_culture

    Turbo-charged counter caches for your Rails app.

  • active_record_doctor

    Identify database issues before they hit production.

  • 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.

  • Project mention: Must-have gems for mature Rails | dev.to | 2024-02-02

    gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.

  • Squasher

    Squasher - squash your old migrations in a single command

  • DatabaseConsistency

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

  • SaaSHub

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

    SaaSHub logo
  • SQL Server

    SQL Server Adapter For Rails

  • Polo

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

  • Project mention: Greenmask: PostgreSQL Dump and Obfuscation Tool | news.ycombinator.com | 2024-02-17

    This is a Rails tool I use: https://github.com/IFTTT/polo — it works well.

  • 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: Ronin: Free and Open Source Ruby Toolkit for Security Research and Development | news.ycombinator.com | 2024-03-19
  • TinyTDS

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

  • DatabaseValidations

    Database validations for ActiveRecord

  • pg-osc

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

  • Project mention: How not to change PostgreSQL column type | news.ycombinator.com | 2024-05-07

    My thoughts exactly. It's surprising that external online schema change tools for Postgres have only become a thing fairly recently! The only two I'm aware of are:

    * pgroll: Written in Golang, first commits June 2023. https://github.com/xataio/pgroll

    * pg-osc: Written in Ruby, first commits Dec 2021. https://github.com/shayonj/pg-osc

    Meanwhile over in the MySQL and MariaDB ecosystem, external OSC tools have been around for quite some time, starting with oak-online-alter-table over 15 years ago. The most popular options today are pt-online-schema-change or gh-ost, but other battle-tested solutions include fb-osc, LHM, and the latest entry Spirit.

  • Hanami::Model

    Ruby persistence framework with entities and repositories

  • evil-seed

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

  • Project mention: Create partial anonymized dumps of your database using your app model relations | news.ycombinator.com | 2024-05-19
  • QueryTrack

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

  • airrecord

    Ruby wrapper for Airtable, your personal database

  • dbf

    DBF is a small, fast Ruby library for reading dBase, xBase, Clipper, and FoxPro database files.

  • Project mention: From dbf to PostgreSQL with Python | dev.to | 2024-03-04

    We can get a sample .dbf file from Infused with the following in our terminal

  • 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.

  • Ruby PG Extras

    Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

  • deviser-club

    An open source blogging platform for devised people: Medium alternative

  • Project mention: PySeKT Stack: Your WebDev Arena in Elon vs. Zuckerberg's Colosseum | /r/webdev | 2023-07-06

    I was getting fluent in Django and Python; I learned VueJs and got to know that it's not my cup of tea. Switched on ReactJs, and felt like I was still missing something. I also learnt Ruby and Rails and developed an open source project called deviser-club, which earned 97 stars, and 'yes', I love flexing this project. Deviser Club went live, and I gained some new Rails friends, but something was missing. Then Svelte and SvelteKit, more like an underdog, surprised everyone in the ring. It was love at first script.

  • active_record_distinct_on

    Support for `DISTINCT ON` statements when querying with ActiveRecord

  • SaaSHub

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

    SaaSHub logo
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).

Ruby Database related posts

  • How not to change PostgreSQL column type

    2 projects | news.ycombinator.com | 7 May 2024
  • Show HN: PostgreSQL Index Advisor

    6 projects | news.ycombinator.com | 13 Apr 2024
  • Figma's Databases team lived to tell the scale

    5 projects | news.ycombinator.com | 14 Mar 2024
  • Greenmask: PostgreSQL Dump and Obfuscation Tool

    5 projects | news.ycombinator.com | 17 Feb 2024
  • Extralite 2.0 has been released!

    3 projects | /r/ruby | 9 Jul 2023
  • PySeKT Stack: Your WebDev Arena in Elon vs. Zuckerberg's Colosseum

    1 project | /r/webdev | 6 Jul 2023
  • How to Start Using psql in Terminal (for Beginners)

    2 projects | dev.to | 17 Jun 2023
  • A note from our sponsor - SaaSHub
    www.saashub.com | 27 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

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

Project Stars
1 Backup 4,821
2 Scenic 3,356
3 counter_culture 1,886
4 active_record_doctor 1,638
5 Lol DBA 1,575
6 Squasher 1,467
7 DatabaseConsistency 987
8 SQL Server 966
9 Polo 767
10 ronin 637
11 TinyTDS 604
12 DatabaseValidations 503
13 pg-osc 487
14 Hanami::Model 445
15 evil-seed 320
16 QueryTrack 294
17 airrecord 291
18 dbf 258
19 postal-codes-json-xml-csv 250
20 relaxo 177
21 Ruby PG Extras 124
22 deviser-club 97
23 active_record_distinct_on 33

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com