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 simple
ahoy, ahoy_email and blazer for business intelligence
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.
Versioned database views for Rails
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.Project mention: Como configurar ambiente de testes em Ruby on Rails com RSpec | dev.to | 2021-04-21
Catch unsafe migrations in developmentProject mention: Database... or Goose? | reddit.com/r/ruby | 2021-06-28
Nice one! Personally, I've been using https://github.com/ankane/strong_migrations to cover this case.
Online MySQL schema migrationsProject mention: Database... or Goose? | reddit.com/r/ruby | 2021-06-28
Is there anything similar for MySQL? There is https://github.com/soundcloud/lhm but it's pretty much outdated nowadays
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
Run Linux Software Faster and Safer than Linux with Unikernels.
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.
Sinatra app to monitor Redis servers.
Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
What are some of the best open-source Database Tool projects in Ruby? This list will help you:
|6||Large Hadron Migrator||1,719|
|23||Ruby PG Extras||91|
Are you hiring? Post a new remote job listing for free.