SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Ruby Database 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.
-
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.
-
DatabaseConsistency
The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Polo
Polo travels through your database and creates sample snapshots so you can work with real world data in development.
-
ronin
Ronin is a Free and Open Source Ruby Toolkit for Security Research and Development. Ronin also allows for the rapid development and distribution of code, exploits, payloads, etc, via 3rd party git repositories. (by ronin-rb)
-
evil-seed
A Gem for creating partial anonymized dumps of your database using your app model relations.
-
Ruby PG Extras
Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Backup VS database - a user suggested alternative | libhunt.com/r/backup | 2023-06-21
Project mention: How to avoid N+1 query using SQL views (materialized) in Rails application | dev.to | 2024-05-14*Scenic* gem
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: Ronin: Free and Open Source Ruby Toolkit for Security Research and Development | news.ycombinator.com | 2024-03-19
My thoughts exactly. It's surprising that external online schema change tools for Postgres have only become a thing fairly recently! The only two I'm aware of are:
* pgroll: Written in Golang, first commits June 2023. https://github.com/xataio/pgroll
* pg-osc: Written in Ruby, first commits Dec 2021. https://github.com/shayonj/pg-osc
Meanwhile over in the MySQL and MariaDB ecosystem, external OSC tools have been around for quite some time, starting with oak-online-alter-table over 15 years ago. The most popular options today are pt-online-schema-change or gh-ost, but other battle-tested solutions include fb-osc, LHM, and the latest entry Spirit.
We can get a sample .dbf file from Infused with the following in our terminal
Project mention: PySeKT Stack: Your WebDev Arena in Elon vs. Zuckerberg's Colosseum | /r/webdev | 2023-07-06I was getting fluent in Django and Python; I learned VueJs and got to know that it's not my cup of tea. Switched on ReactJs, and felt like I was still missing something. I also learnt Ruby and Rails and developed an open source project called deviser-club, which earned 97 stars, and 'yes', I love flexing this project. Deviser Club went live, and I gained some new Rails friends, but something was missing. Then Svelte and SvelteKit, more like an underdog, surprised everyone in the ring. It was love at first script.
Ruby Database related posts
-
How not to change PostgreSQL column type
-
Show HN: PostgreSQL Index Advisor
-
Figma's Databases team lived to tell the scale
-
Greenmask: PostgreSQL Dump and Obfuscation Tool
-
Extralite 2.0 has been released!
-
PySeKT Stack: Your WebDev Arena in Elon vs. Zuckerberg's Colosseum
-
How to Start Using psql in Terminal (for Beginners)
-
A note from our sponsor - SaaSHub
www.saashub.com | 15 May 2024
Index
What are some of the best open-source Database projects in Ruby? This list will help you:
Project | Stars | |
---|---|---|
1 | Backup | 4,818 |
2 | Scenic | 3,347 |
3 | counter_culture | 1,883 |
4 | active_record_doctor | 1,635 |
5 | Lol DBA | 1,571 |
6 | Squasher | 1,468 |
7 | DatabaseConsistency | 985 |
8 | SQL Server | 966 |
9 | Polo | 765 |
10 | ronin | 634 |
11 | TinyTDS | 604 |
12 | DatabaseValidations | 503 |
13 | pg-osc | 486 |
14 | Hanami::Model | 445 |
15 | evil-seed | 320 |
16 | QueryTrack | 292 |
17 | airrecord | 290 |
18 | dbf | 258 |
19 | postal-codes-json-xml-csv | 250 |
20 | relaxo | 177 |
21 | Ruby PG Extras | 124 |
22 | deviser-club | 96 |
23 | active_record_distinct_on | 33 |
Sponsored