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 Database Tool Open-Source 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.
-
Great write up! At PeerDB, we’ve been using refinery https://github.com/rust-db/refinery to handle database migrations of our catalog Postgres database from Rust. It is easy, typesafe and gets the job done. Thought this would be useful for users building apps with Rust!
-
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.
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
- Database Migrations
-
A note from our sponsor - InfluxDB
www.influxdata.com | 28 Mar 2024
Index
What are some of the best open-source Database Tool projects? This list will help you:
Project | Stars | |
---|---|---|
1 | PgHero | 7,539 |
2 | Blazer | 4,325 |
3 | Mongoid | 3,918 |
4 | strong_migrations | 3,808 |
5 | Scenic | 3,320 |
6 | Database Cleaner | 2,912 |
7 | Large Hadron Migrator | 1,811 |
8 | active_record_doctor | 1,606 |
9 | Lol DBA | 1,565 |
10 | Squasher | 1,455 |
11 | Rails DB | 1,448 |
12 | Seed dump | 1,393 |
13 | Foreigner | 1,335 |
14 | Seed Fu | 1,215 |
15 | refinery | 1,183 |
16 | Seedbank | 1,135 |
17 | BatchLoader | 1,014 |
18 | DatabaseConsistency | 975 |
19 | Polo | 766 |
20 | Upsert | 657 |
21 | online_migrations | 569 |
22 | DatabaseValidations | 500 |
23 | auto_strip_attributes | 355 |