Top 23 Ruby Database Tool Projects
A performance dashboard for PostgresProject mention: PostgreSQL for Java Developer | reddit.com/r/javahelp | 2021-04-01
I know others can answer this better but we use a combination of PgHero and logging of slow queries trough jOOQ.
Business intelligence made simpleProject mention: Keeping the Stakes Low while Breaking Production | dev.to | 2021-11-29
We then pasted that into Blazer and started looking at the SQL. As we moved around the massive SQL statement, we saw the culprit. A very narrow range for allowed article’s publication dates.
Run Linux Software Faster and Safer than Linux with Unikernels.
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
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.Project mention: How a big application is usually tested regarding to its database data persistence? Also, tip on starting tests on existing codebase. | reddit.com/r/rails | 2021-09-30
i'll introduce the gem https://github.com/DatabaseCleaner/database_cleaner.
Catch unsafe migrations in developmentProject mention: Tutorial/example for zero downtime deploys for rails apps hosted on digital ocean? | reddit.com/r/rails | 2021-10-07
Database migrations: you should use strong_migrations to catch unsafe migrations that will lock your database.
Online MySQL schema migrationsProject mention: GitHub downtime root cause analysis | reddit.com/r/programming | 2021-12-03
No you didn't. They're doing what is often referred as "online schema change" using https://github.com/github/gh-ost (but the concept is the same than percona's pt-online-schema-change, or https://github.com/soundcloud/lhm.
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
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.
Rails 4/5 task to dump your data to db/seeds.rbProject mention: Quick question about the local PostgreSQL database when you deploy your app to production. | reddit.com/r/rails | 2021-01-06
Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
Squasher - squash your old migrations in a single command
Advanced seed data handling for Rails, combining the best practices of several methods together.
Seedbank gives your seed data a little structure. Create seeds for each environment, share seeds between environments and specify dependencies to load your seeds in order. All nicely integrated with simple rake tasks.
:zap: Powerful tool for avoiding N+1 DB or HTTP queries
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
SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
The tool to find inconsistency between models schema and database constraints.
Database validations for ActiveRecord
Catch bad SQL queries before they cause problems in production
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.
Seamless second database integration for Rails.
Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
Finds missing non-null constraints
Ruby Database Tools related posts
GitHub downtime root cause analysis
4 projects | reddit.com/r/programming | 3 Dec 2021
Keeping the Stakes Low while Breaking Production
4 projects | dev.to | 29 Nov 2021
Tutorial/example for zero downtime deploys for rails apps hosted on digital ocean?
1 project | reddit.com/r/rails | 7 Oct 2021
Frameworks for SQL Development in Rails?
3 projects | reddit.com/r/rails | 5 Oct 2021
How a big application is usually tested regarding to its database data persistence? Also, tip on starting tests on existing codebase.
1 project | reddit.com/r/rails | 30 Sep 2021
Rails application boilerplate for fast MVP development
63 projects | dev.to | 6 Aug 2021
Creating seed data from an existing DB
2 projects | reddit.com/r/rails | 14 Jul 2021
What are some of the best open-source Database Tool projects in Ruby? This list will help you:
|6||Large Hadron Migrator||1,729|
|22||Ruby PG Extras||91|
Are you hiring? Post a new remote job listing for free.