Alternatives
Products that do what TonboLite – Scale SQLite with S3, Minimize ETL does
Hi! I am Tzu and the team from Tonbo here. TonboLite: https://github.com/tonbo-io/tonbolite is a SQLite extension based on Tonbo: https://github.com/tonbo-io/tonbo. It enables SQLite to create tables suitable for analytical processing on target platforms like WebAssembly in browser and efficiently write data. The data in the tables is organized as tiered Apache Parquet format files, stored on demand either on local disks (using OPFS as native I/O) or object storage services (such as S3). You can use it by creating virtual tables in regular SQLite.…
- 1SQ
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021
- 2
- 3
- 4
- 5SW
2014 · github.com
- 6BE
sqlite is, well, everywhere. It's a little shy on high-fidelity types, though, esp no dates and penny-precise numbers. And carrying rich shapes in JSON doesn't really help because JSON lacks those too. BSON supports these types but more importantly is a data carrier external to the database; you can fluidly move BSON in and out of sqlite without creating your own binary representations; just use the BSON SDK for your environment. Upwards of 20 languages are supported. The BSON extension is designed to exploit sqlite built-in JSON functions as desired.
2024 · github.com
- 7IM
Hey everyone! It’s a single executable that you can run on your server using Docker, Systemd, or any other tool you prefer. It provides a simple user-friendly interface to manage all your SQLite databases. Inspired by PhpLiteAdmin, it features a snappy UI and offers power-user functionalities, ability to chat with your database using natural language via OpenAI api, and other features. It’s free to use, with an option for a one-time payment to unlock all features. You can find the demo at https://demo.litequeen.com/ It's early and there's much to add. Some features I think…
2024 · litequeen.com
- 8TT
I've built a type-safe semantic layer in code, for ClickHouse. If you're building analytics off ClickHouse in TypeScript, I would love your feedback. With hypequery there is no platform to adopt, no YAML sprawl. It runs where your app runs. Key features: - Define metrics once, reuse them everywhere: Declare dimensions and measures in one place and then pull from the same source of truth. - Compiles to ClickHouse SQL: No service, no proxy, no extra runtime to deploy. It's a library that generates SQL and runs where your app runs. - Multi-tenancy & Authentication ready: Cross-tenant queries…
Jun 2026 · github.com
- 9SS
2021 · github.com
- 10GM
I built GoSMig for my own projects and open-sourced it in case it helps others. It’s a tiny generic library (no external deps except golang.org/x/term) for writing SQL migrations in Go with compile-time checks. It supports transactional and non-transactional migrations, rollback, status, version, and a small CLI handler so you can ship your own migration binary. Why another migrator? - Minimal API, no DSL or file layout to learn - Type-safe via Go generics - Works with database/sql and sqlx out of the box - Should work with any db library (or wrapper) that implements some…
Oct 2025 · github.com
- 11
- 12ST
2016 · github.com
- 13LS
Hi HN, I built llm.sql, an LLM inference framework that reimagines the LLM execution pipeline as a series of structured SQL queries atop SQLite. The motivation: Edge LLMs are getting better, but hardware remains a bottleneck, especially RAM (size and bandwidth). When available memory is less than the model size and KV cache, the OS incurs page faults and swaps pages using LRU-like strategies, resulting in throughput degradation that's hard to notice and even harder to debug. In fact, the memory access pattern during LLM inference is deterministic - we know exactly which weights are needed…
Apr 2026
- 14GA
Built on top of templUI - https://templui.io - (OSS), which I also created. goilerplate handles auth, subscriptions, docs, etc. SQLite by default, Postgres optional. Polar integration for payments. Feedback welcome!
Nov 2025 · goilerplate.com
- 15LD
Over the last 12 months, in parallel to using Google BigQuery, I have built my own processing pipeline using SQLite and DuckDB. What amazes me is that it works surprisingly well and costs much less than using BigQuery. Roughly speaking, here's what I do: A SQLite database receives IoT sensor data via a very simple PHP function. I currently use the FlightPHP framework for this. The data is written to a table within the SQLite database (WAL mode activated) and states are updated by the machines using triggers. Example of a trigger CREATE TRIGGER message_added AFTER INSERT ON messages BEGIN…
2023
- 16DL
We made extensions dynamically loadable (via dlopen) into a wasm-compiled postgres, on top of pglite. The demo app showcases a restaurant search by name, and by nearest neighbor. demo: https://pglite.lantern.dev/ blog: https://lantern.dev/blog/pglite-lantern special thanks to pglite: https://github.com/electric-sql/pglite/
2024 · lantern.dev
- 17TS
2020 · github.com
- 18ZT
Zvec is a lightweight, SQLite-like embedded vector database purpose-built for edge and on-device workloads. It delivers four core advantages: out-of-the-box usability, configurable resource budgets, extreme performance, and versatile vector capabilities. Open-sourced under the Apache 2.0 license, Zvec aims to provide developers with a one-stop path from prototyping to production deployment on the edge. Try Zvec—we’re excited to see your adoption, feedback, and contributions. For a more detailed introduction, you can refer to https://zvec.org/en/blog/introduction/
Jan 2026 · github.com
- 19SP
2016 · github.com
- 20TC
This is niche, I'll admit. I needed to look through the latest census data, but it was exported as multiple multi-gigabyte bespoke latin1-encoded CSV files. Pandas, Polars, and SQLite's CSV import tool weren't much help, so I shelved the project until recently, when I started taking a SQLite course online. I picked it up again, normalized the data, and now there's a database that can be queried through a SQL view that matches the headings in the original CSVs. I'm proud of the script I created to export the data, as well as automatically compress the artifact, make the diagrams and…
2024 · github.com
- 21SS
Hello, I have recently released this GitHub repo which is a container running the tdog CLI (downloads your Stripe account to a SQLite file) and the Datasette server (reads the SQLite file, presents a web UI). This lets you browse your tables and query them with SQL. There is a live demo at: https://datasette-stripe.fly.dev/stripe Github: https://github.com/tabledog/datasette-stripe Cheers.
2022 · github.com
- 22TF
Hi All! We've spent a few months on getting an MVP together, and would love to get some feedback on whether this tool meets you needs. Here is a link to a demo video: https://www.youtube.com/watch?v=FBLi3vdKB-4&feature=emb_rel_pause Here's a link to our website: https://www.structure.rest And here's a blog article, I published today in the space: https://www.structure.rest/blog/using-a-data-analytics-stack-to-gain-business-insights
2020
- 23SE
Introducing sqlxport: export SQL query results to Parquet/CSV in seconds — and optionally upload to S3 or MinIO. Works with PostgreSQL & Redshift CLI-first, cloud-friendly Great for data pipelines and engineers
2025 · github.com
- 24WR
How It Works - Offline Indexing: Docs are processed and embedded using the GTE-small model at build time. Browser-Based Magic: - SQLite database (stored in the browser) for vector search. - Local embedding model for query processing. - Local LLaMA model for response generation using WebLLM. - Everything Happens Locally: No data leaves the user’s device. Key Benefits - No API Costs: Everything runs in the browser—zero backend expenses. - Unlimited Chats: No rate limits or usage restrictions. - Privacy-First: Your data stays on your device, always. You can find the code here:…
2024 · docs.akiradocs.ai
Ranked by how close each launch is in meaning, then by votes. Refine with a description →