Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free. Learn more →
Top 23 Database Tool Open-Source Projects
A performance dashboard for PostgresProject mention: Is there something like sentry.io, for checking how long rails queries and functions take to execute? | reddit.com/r/rails | 2022-04-03
https://github.com/ankane/pghero (open source equivalent to pganalyze)
Business intelligence made simpleProject mention: Italian watchdog bans use of Google Analytics | news.ycombinator.com | 2022-06-23
I use Ahoy too, but I don't have very good visibility into the data. I should spend more time building queries and creating charts. I should probably set up blazer as well: https://github.com/ankane/blazer
Download talent.io’s Tech Salary Report. Median salaries, most in-demand technologies, state of the remote work... all you need to know your worth on the market by tech recruitment platform talent.io
Catch unsafe migrations in developmentProject mention: Adding first and last name to existing app running on Heroku | reddit.com/r/rails | 2022-09-12
Versioned database views for RailsProject mention: Utilizando views SQL no Ruby on Rails | dev.to | 2022-03-28
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
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.
Truly a developer’s best friend. Scout APM is great for developers who want to find and fix performance issues in their applications. With Scout, we'll take care of the bugs so you can focus on building great things 🚀.
Rails Database Viewer and SQL Query Runner
Rails 4/5 task to dump your data to db/seeds.rb
Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
Squasher - squash your old migrations in a single command
Identify database issues before they hit production.Project mention: Troubleshooting a RoR Application in Production | reddit.com/r/rails | 2022-05-24
Start with finding mixing indexes: https://github.com/gregnavis/active_record_doctor
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 queriesProject mention: N+1 problem will never be an issue with N1Loader gem | reddit.com/r/rails | 2022-01-22
Interesting, I've just been researching Dataloader implementations for Ruby and have between trying to decide between GraphQL::Dataloader, graphql-batch and BatchLoader. I'll give this a look as well. Can you also make API calls inside the loaders?
Powerful SQL migration toolkit for Rust. (by rust-db)Project mention: New to PostgreSQL - Best way to use it? | reddit.com/r/PostgreSQL | 2022-01-25
What I personally use here is Refinery, but it's within the Rust ecosystem. It lets you write your migrations in pure SQL - which is what I prefer - but still requires about 5 lines of boilerplate Rust code.
Polo travels through your database and creates sample snapshots so you can work with real world data in development.
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.Project mention: Enhanced ActiveRecord preloading | reddit.com/r/rails | 2022-05-19
Described issues may be found with DatabaseConsistency.
Database validations for ActiveRecordProject mention: Ecto's uniqueness constraint vs. Rails' uniqueness validation | news.ycombinator.com | 2022-05-21
Love this post, great exploration of the nuances of uniqueness validations.
I came here to mention that there is also the https://github.com/toptal/database_validations gem which allows you to handle uniqueness validations in Rails in a similar manner to Ecto.
Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).Project mention: Zero-downtime schema migrations for Ruby on Rails | reddit.com/r/ruby | 2022-05-25
For other people looking into zero-downtime migrations: you may also consider easier to use ruby-based tool for this https://github.com/fatkodima/online_migrations
Catch bad SQL queries before they cause problems in production
Find time-consuming database queries for ActiveRecord-based Rails Apps
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
Database Tools related posts
Adding first and last name to existing app running on Heroku
1 project | reddit.com/r/rails | 12 Sep 2022
We switched to cursor-based pagination
2 projects | news.ycombinator.com | 21 Aug 2022
Faster offset pagination for Rails apps
2 projects | news.ycombinator.com | 16 Aug 2022
Italian watchdog bans use of Google Analytics
4 projects | news.ycombinator.com | 23 Jun 2022
4 projects | reddit.com/r/rubyonrails | 6 Jun 2022
Using Scientist to Refactor Critical Ruby on Rails Code
3 projects | dev.to | 25 May 2022
Zero-downtime schema migrations for Ruby on Rails
1 project | reddit.com/r/ruby | 25 May 2022
A note from our sponsor - SonarQube
www.sonarqube.org | 5 Oct 2022
What are some of the best open-source Database Tool projects? This list will help you:
|6||Large Hadron Migrator||1,759|
Are you hiring? Post a new remote job listing for free.