Top 16 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 Rails
Run Linux Software Faster and Safer than Linux with Unikernels.
Turbo-charged counter caches for your Rails app.Project mention: Ten Ruby gems for Rails you should definitely know about | dev.to | 2021-06-25
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.Project mention: 15 Resources I Learned Something From This Weekend | dev.to | 2020-09-27
gregnavis / active_record_doctor
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
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.
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)
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.