Top 23 Ruby Database Tool Projects
Business intelligence made simpleProject mention: The Ruby Unbundled Series: Track How Customers Use New Features | dev.to | 2021-03-24
Ahoy is used to track visits to your site and specific user events that you define. Blazer allows you to easily query and view the metrics data. In fact, blazer can be used to query any data in your database, and it has some nice built-in visualization capabilities for metrics as well.
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
Scout APM - Leading-edge performance monitoring starting at $39/month. 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 RailsProject mention: Logidze 1.0, postgres-specific alternative to eg paper_trail for recording ActiveRecord change history | reddit.com/r/ruby | 2021-01-27
TIL about fx gem for storing triggers in schema.rb. That makes me so happy because scenic gem for creating database views is one of my favorites. Postgres is very powerful and it's great to see tools for exposing that through Rails.
Online MySQL schema migrationsProject mention: Do you use migrations for data manipulations? What are the pro's and con's ? | reddit.com/r/rails | 2021-02-17
I may do it from the console or a task if I wanted to modify a large number of records, e.g. something in my Users table. I think you need a sense of how long the update will take - I'm not sure if there's any issue with migrations timing out or such like. If I modify my Users schema it takes 5 minutes or so as it has to make a copy of the table and swap it in and that works fine - 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.
Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
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
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.
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.
Catch bad SQL queries before they cause problems in production
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.
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.
Finds missing non-null constraints
Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API
What are some of the best open-source Database Tool projects in Ruby? This list will help you:
|4||Large Hadron Migrator||1,704|
|21||Ruby PG Extras||74|