Top 17 Ruby Database Projects
Easy full stack backup operations on UNIX-like systems.Project mention: Backup Postgresql Docker | reddit.com/r/devops | 2021-04-16
I used to be a huge fan of https://github.com/backup/backup, but unfortunately it doesn't get updates. Still works though. I ran hundreds of gigs each night through that tool. There's a golang version re-write that is limited on the features - https://github.com/huacnlee/gobackup.
Versioned database views for RailsProject mention: Frameworks for SQL Development in Rails? | reddit.com/r/rails | 2021-10-05
I use the scenic gem to manage views which uses raw sql files: https://github.com/scenic-views/scenic
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
Turbo-charged counter caches for your Rails app.Project mention: Storing aggregate values? | reddit.com/r/rails | 2021-10-06
Have a look at counter_culture
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.
lol_dba for indexing
Identify database issues before they hit production.
SQL Server Adapter For Rails
Polo travels through your database and creates sample snapshots so you can work with real world data in development.Project mention: Creating seed data from an existing DB | reddit.com/r/rails | 2021-07-14
Run Linux Software Faster and Safer than Linux with Unikernels.
TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.
Zero downtime migrations with ActiveRecord 3+ and PostgreSQLProject mention: Rails: Postgres Partial Indexing | reddit.com/r/ruby | 2021-01-25
I've historically used https://github.com/LendingHome/zero_downtime_migrations which is based on strong_migrations but at the end of the day anything is better than nothing.
The tool to find inconsistency between models schema and database constraints.
Ruby persistence framework with entities and repositories
Database validations for ActiveRecord
Find time-consuming database queries for ActiveRecord-based Rails AppsProject mention: Tracking long queries into csv | dev.to | 2020-12-27
I found query_tracker gem which displays all the info I needed. It also allows slack integration. In my case, I wanted it to store query informations into CSV. Fortunately the gem allows custom handlers.
Relaxo is a transactional document database built on top of git.Project mention: Git as a NoSql Database | news.ycombinator.com | 2021-04-05
Postgres partitioning built on top of https://github.com/ankane/pgslice
ActiveRecord force destroy records with all related associations. (by kirillshevch)
An ActiveModel extension to model your semi-structured data using embedded associationsProject mention: Modeling semi-structured data in Rails | dev.to | 2021-10-27
Luckily, you won't need to implement this yourself, as this gem does it for you (and even more).
Ruby Database related posts
Basics of MongoDB
3 projects | dev.to | 18 Nov 2021
Explaining Ruby Fibers
4 projects | reddit.com/r/ruby | 21 Oct 2021
The Nosql Store That Everyone Ignored
4 projects | news.ycombinator.com | 5 Sep 2021
Creating seed data from an existing DB
2 projects | reddit.com/r/rails | 14 Jul 2021
Any decent packages that enforce database constraints to match application validation?
1 project | reddit.com/r/elixir | 1 Jun 2021
Awesome Tools and Technologies I Use as a Developer!
10 projects | dev.to | 24 Apr 2021
Git as a NoSql Database
9 projects | news.ycombinator.com | 5 Apr 2021
What are some of the best open-source Database projects in Ruby? This list will help you:
Are you hiring? Post a new remote job listing for free.