Alternatives
Products that do what Lightweight data analytics using SQLite, Bash and DuckDB does
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…
- 1MI
2021 · github.com
- 2
- 3DC
2017 · simonwillison.net
- 4DR
We’ve built SQLRooms, an open-source framework for creating single-node data analytics apps powered by DuckDB. It lets you build fully client-side, data-centric apps using React and DuckDB running in the browser (via WebAssembly) or in Electron. No server or backend is required — apps can work offline, preserve data privacy, and run queries on large datasets with sub-second performance. Features: - Query large datasets in browser with DuckDB (WASM) - Modular design for building composable data UIs (query editors, dashboards, notebooks, etc.) - Data privacy-preserving AI assistant that can…
2025 · sqlrooms.org
- 5SQ
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
- 6
- 7SS
I'm a couple years late to the party but DuckDB is blowing my mind. I couldn't find an good embedded DuckDB stream processing solution so I hacked my own, calling it SQLFlow: https://github.com/turbolytics/sql-flow SQLFlow enables writing stream transformations in pure sql, executed using DuckDB. The goal was to create a lightweight, performant stream processing engine using pure SQL transformations, DuckDB didn't disappoint! I'd love your feedback, feature requests, impressions, or just comments. I'd love to turn this into a stable, usable project that people are…
2023 · github.com
- 8PW
Turn any SQL code block on your website into a runnable query editor with just a tag. Powered by DuckDB WASM running entirely in the browser – no backend needed. Perfect for documentation sites, tutorials, and blog posts. Features: • Full SQL analytics engine (DuckDB) running client-side • Syntax highlighting with live editing • One-click query execution (or Ctrl+Enter) • Works with any static site – just add the CDN script • Only 23KB minified, loads DuckDB on-demand • Dark/light theme support Try it: https://widget.pondpilot.io GitHub:…
2025 · github.com
- 9
- 10IM
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
- 11PR
Hi HN! We built PondPilot – a fully client-side data exploration tool powered by DuckDB. It’s open-source and built for speed, privacy, and simplicity. Try it: https://app.pondpilot.io GitHub: https://github.com/pondpilot/pondpilot You can: - Run fast SQL queries directly in your browser - Explore CSV, Parquet, JSON, or .duckdb files without uploading - Keep your data 100% local (it never leaves your device) - Install as a PWA and work offline - Use it read-only, with real-time updates when files change It’s designed as a lightweight alternative to notebooks or…
2025 · app.pondpilot.io
- 12SW
2014 · github.com
- 13QD
I'm building a privacy focused analytics tool, using WebAssembly and DuckDB. You can upload your files (CSV, JSON and Parquet), and interact with them as where they a SQL Server. Your data never leaves your computer, however I do track page views and visitors using Plausible. The next steps are to add forecasting and segmentation, as well as some data visualisation capabilities. I would love to hear your opinion. All code for the repo is available here: https://github.com/dilovancelik/client_side_analytics
2024 · dilovancelik.github.io
- 14CA
I've been building a bunch of random side projects, as I'm sure we all are. Most analytics tools were either too heavy or required juggling multiple free tiers across different subdomains. After looking what's out there I couldn't find a lightweight analytics platform that worked on the free tier of fly.io. It's a single Go binary using DuckDB for events and SQLite for metadata, so there are no external dependencies to manage. Drop a script tag on your site and it auto-captures pageviews and clicks. The part I'm most excited about: it uses an LLM to automatically name raw click events into…
Feb 2026 · github.com
- 15SP
2024 · sql.quacking.cloud
- 16AO
It’s just the back end so it logs to MongoDB database so you can add any UI you want to it, feel free to contribute! (Suggestion’?)
2022 · github.com
- 17SS
2020 · app.swaggerhub.com
- 18EA
Yet another "talk to your data and build a dashboard" app, where data does not leave your browser. You ask a question, agents produce multiple SQL queries to in-browser sqlite, never seeing results, and write dashboard configuration code. The data you analyze will be indexed with a local semantic index (embeddings generation + sqlite vector search fully local). Next, sandboxed QuickJS runs this code to produce rich dashboards directly in your browser, no backend attached. This is a fully frontend app (except OpenRouter or other remote LLM). All data sent to LLM's is heavily sanitized and…
Jun 2026 · eatmydata.ai
- 19TS
2020 · github.com
- 20IW
Hi! I wanted to understand more about databases' internals so I wrote one from scratch. It has a T-SQL inspired syntax with support for functions and procedures. It can be used stand-alone as a SQL engine or with a server allowing for persistence and replication to other connected clients. Performance are nothing near sqlite of course but that's beside the point. It’s a small database engine that can run in a web app as a way to store session data, do small calculations on a web worker, store the document/data the user is editing or facilitate “multiplayer” feature by broadcasting the…
2022 · github.com
- 21
- 22WT
We just launched a small project I'm really proud of — a turbo Database MCP server! https://centralmind.ai - Connect your database to Cursor or Windsurf in just a few clicks. - Chat with PostgreSQL, MSSQL, ClickHouse, Elasticsearch, and more. - Query huge Parquet files instantly with DuckDB in-memory mode. - No downloads, no setup headaches. Short video: https://youtu.be/BboQtxen9tA Built on top of our open-source MCP Database Gateway: https://github.com/centralmind/gateway Note: You’ll need to provide connection strings to your databases. For…
2025 · centralmind.ai
- 23DQ
What started as a Claude Code experiment turned into a browser-native SQL workbench I now use daily. Runs DuckDB WASM entirely in your browser. No backend, no installation, no signup. - Query local files (CSV, Parquet, Excel) – data never leaves your machine - Handles 100M+ rows, 50GB+ files in a browser tab - Full UI: Monaco editor, schema explorer, spreadsheet-style results grid - Share SQL via URL – anyone can run your query instantly - BigQuery connector built-in (Snowflake coming) v0.2 – actively developing. Feedback welcome. GitHub (MIT):…
Dec 2025 · sql.dbxlite.com
- 24SP
2016 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →