The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Ruby Database Tool Projects
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
Database Cleaner
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
Lol DBA
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.
-
Seed Fu
Advanced seed data handling for Rails, combining the best practices of several methods together.
-
Seedbank
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.
-
DatabaseConsistency
The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
-
Polo
Polo travels through your database and creates sample snapshots so you can work with real world data in development.
-
Upsert
Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
-
online_migrations
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).
-
auto_strip_attributes
AutoStripAttributes gem for Rails helps to remove unnecessary whitespaces from ActiveRecord or ActiveModel attributes. It's good for removing accidental spaces from user inputs (e.g. when user copy/pastes some value to a form and the value has extra spaces at the end).
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
I am using https://github.com/ankane/pghero/ and this is one of its features with GUI
In the Rails world, the gem strong_migrations can be used to detect these: https://github.com/ankane/strong_migrations
The docs include a handy articulation of fixes.
gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
Project mention: Greenmask: PostgreSQL Dump and Obfuscation Tool | news.ycombinator.com | 2024-02-17This is a Rails tool I use: https://github.com/IFTTT/polo — it works well.
Project mention: auto_strip_attributes VS attribute_normalizer - a user suggested alternative | libhunt.com/r/auto_strip_attributes | 2023-06-06
Ruby Database Tools related posts
- Show HN: PostgreSQL Index Advisor
- Careful with That Lock, Eugene
- Ocra: One-Click Ruby Application Builder
- Blazer: Business Intelligence Made Simple
- Is Tableau Dead?
- Greenmask: PostgreSQL Dump and Obfuscation Tool
- Must-have gems for mature Rails
-
A note from our sponsor - WorkOS
workos.com | 25 Apr 2024
Index
What are some of the best open-source Database Tool projects in Ruby? This list will help you:
Project | Stars | |
---|---|---|
1 | PgHero | 7,695 |
2 | Blazer | 4,367 |
3 | Mongoid | 3,917 |
4 | strong_migrations | 3,856 |
5 | Scenic | 3,338 |
6 | Database Cleaner | 2,913 |
7 | Large Hadron Migrator | 1,816 |
8 | active_record_doctor | 1,626 |
9 | Lol DBA | 1,571 |
10 | Squasher | 1,464 |
11 | Seed dump | 1,393 |
12 | Foreigner | 1,327 |
13 | Seed Fu | 1,215 |
14 | Seedbank | 1,137 |
15 | BatchLoader | 1,019 |
16 | DatabaseConsistency | 978 |
17 | Polo | 766 |
18 | Upsert | 657 |
19 | online_migrations | 579 |
20 | DatabaseValidations | 500 |
21 | auto_strip_attributes | 355 |
22 | Shiba | 293 |
23 | fast_page | 292 |
Sponsored