Ruby SQL

Open-source Ruby projects categorized as SQL

Top 20 Ruby SQL Projects

  • ransack

    Object-based searching.

  • Blazer

    Business intelligence made simple

  • Project mention: Blazer: Business Intelligence Made Simple | news.ycombinator.com | 2024-02-27
  • 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.

    InfluxDB logo
  • Scenic

    Versioned database views for Rails

  • Project mention: How to avoid N+1 query using SQL views (materialized) in Rails application | dev.to | 2024-05-14

    *Scenic* gem

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

  • Project mention: Must-have gems for mature Rails | dev.to | 2024-02-02

    gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.

  • SQL Server

    SQL Server Adapter For Rails

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

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  • TinyTDS

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

  • BabySqueel

    :pig: An expressive query DSL for Active Record

  • boxcars

    Building applications with composability using Boxcars with LLM's. Inspired by LangChain.

  • Project mention: Building an app around a LLM, Rails + Python or just Python? | /r/rails | 2023-06-06

    currently in the same boat as you at my company, we've been looking at Boxcars and LangchainRB as our gems but they're pretty new to the scene so not sure about that. I love the idea of langchain for the extensibility of it though - we used the ruby-openai gem for a while but it didn't do what we needed. I'll come back in a week or two with with what we decide (python microservice with flask served api endpoints vs ruby all the way)

  • occams-record

    The missing high-efficiency query API for ActiveRecord

  • Project mention: ORMs are criticized for the wrong reasons | /r/ruby | 2023-06-22
  • PpSql

    Rails ActiveRecord SQL queries log beautifier

  • rom-sql

    SQL support for rom-rb

  • ActiveRecord Where Assoc

    Make ActiveRecord do conditions on your associations

  • timescaledb

    The timescaledb gem. Pack of helpers to work with TimescaleDB extension in Ruby. (by jonatas)

  • acts_as_nosql

    Allows to treat JSON fields of postgres and mysql as real fields

  • active_record_distinct_on

    Support for `DISTINCT ON` statements when querying with ActiveRecord

  • ActiveRecord Setops

    Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).

  • activerecord_follow_assoc

    Follow associations within your ActiveRecord queries

  • dynamic-records-meritfront

    Dynamic Records Meritfront was built to allow you to make full use of your database's capabilites, while utilizing ruby on rails & Active Record. It contains a better way to write sql queries for rails, and includes other tips and tricks to take advantage of. Perfect for all your dynamic applications, optimizations and weird edge cases!

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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

Ruby SQL related posts

  • How to avoid N+1 query using SQL views (materialized) in Rails application

    1 project | dev.to | 14 May 2024
  • Blazer: Business Intelligence Made Simple

    4 projects | news.ycombinator.com | 27 Feb 2024
  • Is Tableau Dead?

    3 projects | news.ycombinator.com | 26 Feb 2024
  • SQL for Data Scientists in 100 Queries

    5 projects | news.ycombinator.com | 6 Feb 2024
  • BI vs custom queries in app

    1 project | /r/rails | 30 Jun 2023
  • ORMs are criticized for the wrong reasons

    1 project | /r/ruby | 22 Jun 2023
  • Boxcars – Build LLM Application in Ruby on Rails

    1 project | news.ycombinator.com | 1 May 2023
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 26 May 2024
    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 →

Index

What are some of the best open-source SQL projects in Ruby? This list will help you:

Project Stars
1 ransack 5,593
2 Blazer 4,402
3 Scenic 3,356
4 ROM 2,067
5 Lol DBA 1,575
6 SQL Server 966
7 motor-admin-rails 716
8 TinyTDS 604
9 BabySqueel 499
10 boxcars 416
11 occams-record 355
12 PpSql 259
13 rom-sql 219
14 ActiveRecord Where Assoc 208
15 timescaledb 55
16 acts_as_nosql 35
17 active_record_distinct_on 33
18 ActiveRecord Setops 21
19 activerecord_follow_assoc 17
20 dynamic-records-meritfront 7

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com