SaaSHub helps you find the best software and product alternatives Learn more →
Top 17 Ruby SQL Projects
-
-
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
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
-
Project mention: Database Views & Rails Active Record: defining new Model classes out of views | dev.to | 2023-01-23
To model our Deliverable class, we will need a view. We will use the popular scenic gem, which provides some useful generators for creating views with their respective migrations, and utilities to handle views versioning.
-
Object Mapper: rom-rb/rom: Data mapping and persistence toolkit for Ruby
-
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.
-
-
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
motor-admin-rails
Low-code Admin panel and Business intelligence Rails engine. No DSL - configurable from the UI. Rails Admin, Active Admin, Blazer modern alternative.
-
-
Project mention: Use PG cursors (and more!) in Rails with occams-record 1.4.0 | reddit.com/r/ruby | 2022-09-20
-
-
-
I’ve been using the activerecord_where_assoc gem for this. I think it’s API is more natural than this proposal.
-
timescaledb
The timescaledb gem. Pack of helpers to work with TimescaleDB extension in Ruby. (by jonatas)
Project mention: Day 23: CI using timescaledb a PostgreSQL based time series database | dev.to | 2022-12-23As always I started by cloning the timescaledb git repository.
-
Project mention: How do I query for the most recently created records across multiple models ! | reddit.com/r/rails | 2022-06-20
If you're using Postgres, then DISTINCT ON may also be a good option via the active_record_distinct_on gem.
-
ActiveRecord Setops
Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
The latest post mention was on 2023-01-23.
Ruby SQL related posts
- Database Views & Rails Active Record: defining new Model classes out of views
- Materialised views for serious performance gains
- It's not Ruby that's slow, it's your database
- A Ruby-Powered Business Intelligence Tool
- How to Contribute to Open Source Project - Your First GitHub PR
- Out of the Box CRUD Management Framework
- Utilizando views SQL no Ruby on Rails
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea59ce88d0>
www.saashub.com | 8 Feb 2023
Index
What are some of the best open-source SQL projects in Ruby? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | ransack | 5,344 |
| 2 | Blazer | 3,469 |
| 3 | Scenic | 3,109 |
| 4 | ROM | 2,028 |
| 5 | Lol DBA | 1,484 |
| 6 | SQL Server | 947 |
| 7 | TinyTDS | 591 |
| 8 | motor-admin-rails | 515 |
| 9 | BabySqueel | 479 |
| 10 | occams-record | 315 |
| 11 | PpSql | 235 |
| 12 | rom-sql | 206 |
| 13 | ActiveRecord Where Assoc | 180 |
| 14 | timescaledb | 40 |
| 15 | active_record_distinct_on | 23 |
| 16 | ActiveRecord Setops | 21 |
| 17 | activerecord_follow_assoc | 14 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com