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
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 |