Ruby SQL

Open-source Ruby projects categorized as SQL
Edit details
Topics: Ruby ActiveRecord Rails Database Database Tools
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

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

  • 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

Index

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

Project Stars
1 ransack 5,587
2 Blazer 4,379
3 Scenic 3,341
4 ROM 2,065
5 Lol DBA 1,571
6 SQL Server 966
7 motor-admin-rails 706
8 TinyTDS 604
9 BabySqueel 497
10 boxcars 415
11 occams-record 355
12 PpSql 248
13 rom-sql 219
14 ActiveRecord Where Assoc 208
15 timescaledb 53
16 acts_as_nosql 35
17 active_record_distinct_on 32
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