Ruby SQL

Open-source Ruby projects categorized as SQL

Top 17 Ruby SQL Projects

  • ransack

    Object-based searching.

  • Blazer

    Business intelligence made simple

    Project mention: Italian watchdog bans use of Google Analytics | news.ycombinator.com | 2022-06-23

    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.

  • Scenic

    Versioned database views for Rails

    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.

  • ROM

    Data mapping and persistence toolkit for Ruby

    Project mention: Understanding Clean Architecture with small Ruby libraries | dev.to | 2022-11-01

    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.

  • SQL Server

    SQL Server Adapter For Rails

    Project mention: Ruby on Rails on windows server | reddit.com/r/rails | 2022-08-02
  • TinyTDS

    TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.

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

  • BabySqueel

    :pig: An expressive query DSL for Active Record

  • occams-record

    The missing high-efficiency query API for ActiveRecord

    Project mention: Use PG cursors (and more!) in Rails with occams-record 1.4.0 | reddit.com/r/ruby | 2022-09-20
  • PpSql

    Rails ActiveRecord SQL queries log beautifier

  • rom-sql

    SQL support for rom-rb

  • ActiveRecord Where Assoc

    Make ActiveRecord do conditions on your associations

    Project mention: EXISTS clause for active record | reddit.com/r/rails | 2022-10-29

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

    As always I started by cloning the timescaledb git repository.

  • active_record_distinct_on

    Support for `DISTINCT ON` statements when querying with ActiveRecord

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

  • activerecord_follow_assoc

    Follow associations within your ActiveRecord queries

  • 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

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