CLI tool that queries SQLite databases across remote hosts via SSH, aggregating results in real-time. Designed for multi-tenant apps where each tenant has their own SQLite database.
UUID and ULID primary key support for Rails with SQLite3. Provides automatic type registration, validation, foreign key detection, and clean schema generation. Supports UUIDv4 (random), UUIDv7 (time-ordered), and ULID (compact, time-sortable).
A feature-rich, mountable Rails engine that provides a beautiful web interface for browsing and querying SQLite databases. Includes SQL syntax highlighting, pagination, table browsing, and a responsive Bootstrap UI.
The SQL Ferret provides a navigational database style wrapper around SQLite. EXPERIMENTAL! The API and both DSLs are subject to change!
Simple sqlite backup for Rails
A Datetime/timezone SQLite extension.
A comprehensive Ruby implementation of a Knowledge-Based System featuring: • RETE Algorithm: Optimized forward-chaining inference engine with unlinking optimization for high-performance pattern matching • Declarative DSL: Readable, expressive syntax for rule definition with built-in condition helpers • Blackboard Architecture: Multi-agent coordination with message passing and knowledge source registration • Flexible Persistence: SQLite (durable), Redis (fast), and hybrid storage backends with audit trails • Concurrent Execution: Thread-safe auto-inference mode for real-time processing • AI Integration: Native support for LLM integration (Ollama, OpenAI) for hybrid symbolic/neural reasoning • Production Features: Session management, fact history, query API, statistics tracking Perfect for expert systems, trading algorithms, IoT monitoring, portfolio management, and AI-enhanced decision systems.
A SQLite extension which uses Graft to replicate to and from object storage.
A SQLite extension for querying data from Excel files
SQLite's UUID v4 extension, packaged as a gem.
Allows ductr to interact with SQLite DMBS.
A SQLite extension for generating text embeddings from remote sources (OpenAI, Cohere, localhost, etc.)
A SQLite extension for generating text embeddings.
Makes SQLite create case-insensitive string and text fields
Sequel Postgres and SQLite driver for inserting and working River jobs in Ruby.
A vector search SQLite extension.
Durable session persistence for Terret: the append-only session log stored one event per row in SQLite (WAL mode), behind the ctx[:session_store] seam, so sessions survive process restarts with byte-identical derived context.
A schema-aware MySQL-to-SQLite data importer built on Active Record.
Take the pain out of dealing with databases in Android by generating fully functional database, content provider, and ORM object code, from nothing more than a pre-built sqlite database or a .sql file.
Adds SQLite support to Gloo.
csvpack - work with tabular data packages using comma-separated values (CSV) datafiles in text with datapackage.json; download, read into and query comma-separated values (CSV) datafiles with your SQL database (e.g. SQLite, PostgreSQL, ...) of choice and much more
Allow users to be able to make todo lists without moving away from terminal, all the lists are persisted to database. You need to have sqlite installed on your computer before hand http://www.sqlite.org
Provides Ask::State adapter implementations for SQLite, Redis, PostgreSQL, and MySQL. Each backend implements the Ask::State::Adapter contract (get/set/delete, distributed locking, message queues, and ordered lists) so agents, sessions, and workflows pick the right persistence layer with one line of code.
Small library that can populate a SQLite database with the recursive list of all files and their respective metadata.
fbtxt2sqlite - read football.txt match schedules & more into sqlite database
Automatically use UUID v7 for all primary keys in Rails applications. Works with PostgreSQL, MySQL (mysql2 & trilogy), and SQLite, zero configuration required.
RailsDB is a web application written in Ruby using the Ruby on Rails web framework. RailsDB provides a generic interface to popular open source databases such as MySQL, PostgreSQL, and SQLite.
Override migration methods to support UUID/ULID columns without having to be explicit about it.
Helper queries providing insights into the Sqlite database for Rails apps.
Sqlite3 Adapter for DataMapper
libsql embeds the libsql fork of the SQLite database engine as a ruby extension. There is no need to install libsql separately.
GQLite is a Rust-language library, with a C interface, that implements a small, fast, self-contained, high-reliability, full-featured, Graph Query database engine. GQLite support multiple database backends, such as SQLite and redb. This enable to achieve high performance and for application to combine Graph queries with traditional SQL queries. GQLite source code is license under the [MIT License](LICENSE) and is free to everyone to use for any purpose. The official repositories contains bindings/APIs for C, C++, Python, Ruby and Crystal. The library is still in its early stage, but it is now fully functional. Development effort has now slowed down and new features are added on a by-need basis. It supports a subset of OpenCypher, with some ISO GQL extensions. Example of use -------------- ```ruby require 'gqlite' begin # Create a database on the file "test.db" connection = GQLite::Connection.new filename: "test.db" # Execute a simple query to create a node and return all the nodes value = connection.execute_oc_query("CREATE () MATCH (n) RETURN n") # Print the result if value.nil? puts "Empty results" else puts "Results are #{value.to_s}" end rescue GQLite::Error => ex # Report any error puts "An error has occured: #{ex.message}" end ``` The documentation for the GQL query language can found in [OpenCypher](https://auksys.org/documentation/5/libraries/gqlite/opencypher/) and for the [API](https://auksys.org/documentation/5/libraries/gqlite/api/).
Retries database transaction on deadlock and transaction serialization errors. Supports MySQL, PostgreSQL and SQLite (as long as you are using new drivers mysql2, pg, sqlite3).
An embedded, single-file, wide-column store: BigTable's data model, SQLite's deployment model.
Snapshots your databases around an action and stores the row-level diff as a YAML tape. Later runs of the same action are verified against the tape, so you notice when a change or update alters what gets written. VCR-style API, works with Sequel and MySQL, MariaDB, PostgreSQL or SQLite.
Keeps lepus-saga executions and step attempts in ActiveRecord tables (PostgreSQL, MySQL/MariaDB, SQLite), with a Rails generator for the migration
Keeps lepus-saga executions and step attempts in Sequel models (PostgreSQL, MySQL/MariaDB, SQLite), with migrations for the tables
All the missing glue to use the SQLite FTS
Mountable Rails engine that serves .md files from your repo as a docs site with a sidebar tree (_tree.yml ordering), SQLite FTS5 search, server-side syntax highlighting and Mermaid diagrams. Tailwind + Stimulus.
Explicit application composition, scoped execution, Data Mapper persistence, HTTP and native gRPC, with an optional SQLite adapter.
Crash-safe, resumable agent conversations for Rails. Ships the pi-durable runtime as a sidecar process inside the gem that keeps its state in your app's database, Postgres or SQLite, which Rails reads with Active Record. Broadcasts over Turbo, and lets you write tools in Ruby.
Reads the `nbk` files a Kindle Scribe writes and renders them as vector PDFs, complete with the ruled or squared background the notes were written on, and adds what was written on a PDF on the device to a copy of that PDF. Includes a reader for the signature container the device wraps its SQLite database in, a binary Amazon Ion parser, and a decoder for the second-order delta encoding the firmware stores pen strokes in. Ships the `nbk2pdf` command line tool.
Upload XLSX, XLS, ODS, CSV or JSON files and get SQL for PostgreSQL, MySQL, MariaDB, SQLite, SQL Server or Oracle back from the IntoSQL API, with webhook verification.
A Sequel adapter (URL scheme beagle-turso://) that runs Sequel -- and ROM / Hanami repositories on top of it -- on a beagle-turso database: a local SQLite-compatible replica that syncs to Turso Cloud. SQL generation, schema parsing and transactions come from Sequel's shared SQLite support.
Footfall is what a shop counts at its door: people coming in, not who they are. Rack middleware that counts page views, visitors, the sites they came from and file downloads into a SQLite file, and a report for the terminal. No cookies, no IP addresses, no full referrers: a visitor is a hash salted anew every day and the salt forgotten the next, so a day's visitors can be counted but not followed from day to day or traced back. Bots are left out.
cybertrain is a Rails-shaped web framework written for Spinel, which compiles an application into a native binary. This gem installs the `cybertrain` command (`cybertrain new`, `generate scaffold`, `db migrate`, `server`, `build`). The first command that needs Spinel builds the pinned release into ~/.cybertrain (a C compiler, make, git, curl and the SQLite headers are required); `cybertrain doctor` checks.
Ruby API + Next.js with one origin: routing, controllers, models (SQLite, PostgreSQL, MySQL), background jobs, mail, file storage, a TypeScript contract, generators and a development server. Authentication and realtime are the gemstack-auth and gemstack-realtime gems.
Gemite is a lightweight HTML-first programming language inspired by PHP. It allows developers to build dynamic web applications with minimal setup, built-in routing based on file structure, and integrated SQLite support.
Bundles the Litestream VFS shared library for loading into SQLite connections.