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. Learn more →
Top 23 Ruby Database Tool Projects
-
Project mention: What are your favourite approaches to keeping on top of Postgres health? | /r/rails | 2023-06-27
I use either PgHero or Rails PG Extras on every project
-
-
PopRuby
PopRuby: Clothing and Accessories for Ruby Developers. Fashion meets Ruby! Shop our fun Ruby-inspired apparel and accessories designed to celebrate the joy and diversity of the Ruby community.
-
-
gem "strong_migrations" - https://github.com/ankane/strong_migrations | Helps devs write non-blocking migrations, a must-have.
-
-
Database Cleaner
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
-
-
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.
-
-
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.
gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
-
-
-
-
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.
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.
-
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).
Project mention: Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails | /r/rails | 2023-04-05Or simply use https://github.com/fatkodima/online_migrations and don’t get bitten by migrations in production again.
-
-
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).
Project mention: auto_strip_attributes VS attribute_normalizer - a user suggested alternative | libhunt.com/r/auto_strip_attributes | 2023-06-06 -
-
-
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.
Ruby Database Tools related posts
- 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
- Migration Best Practice
- BI vs custom queries in app
-
A note from our sponsor - InfluxDB
www.influxdata.com | 18 Mar 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,516 |
2 | Blazer | 4,299 |
3 | Mongoid | 3,917 |
4 | strong_migrations | 3,797 |
5 | Scenic | 3,309 |
6 | Database Cleaner | 2,911 |
7 | Large Hadron Migrator | 1,810 |
8 | active_record_doctor | 1,599 |
9 | Lol DBA | 1,565 |
10 | Squasher | 1,454 |
11 | Seed dump | 1,393 |
12 | Foreigner | 1,335 |
13 | Seed Fu | 1,215 |
14 | Seedbank | 1,135 |
15 | BatchLoader | 1,013 |
16 | DatabaseConsistency | 973 |
17 | Polo | 765 |
18 | Upsert | 657 |
19 | online_migrations | 565 |
20 | DatabaseValidations | 498 |
21 | auto_strip_attributes | 355 |
22 | Shiba | 293 |
23 | QueryTrack | 290 |