Alternatives
Products that do what BSON Extension for SQLite does
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.
- 1MI
2021 · github.com
- 2
- 3
- 4SQ
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
- 5CA
Introducing ChikkaDB - a server application providing a translation layer around SQLite that enables you to use SQLite as a MongoDB-compatible JSON database. It's a small personal project to explore the possibilities of SQLite's JSON and JSONB functions to their fullest. Sharing it here in case it interests any of you. Inviting everyone to try it out and share your feedback.
Nov 2025 · github.com
- 6DC
2017 · simonwillison.net
- 7
- 8DP
2018 · publish.datasettes.com
- 9
- 10JF
2019 · github.com
- 11QJ
2020 · github.com
- 12SG
2019 · github.com
- 13ST
2016 · github.com
- 14KI
2021 · gitlab.com
- 15TS
2020 · github.com
- 16SS
2020 · app.swaggerhub.com
- 17TS
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.…
2025 · github.com
- 18IW
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
- 19SW
2014 · github.com
- 20IM
Hello HN, I've just released a new migration tool for Go that mimics the functionality of Ruby on Rails migrations. It's designed to help Go developers manage database schema changes with ease. This allows you several benefits: - Write type-safe migrations - Auto down of migrations whenever it's possible - Easy backfill even with business logic because it's Go code - Painless integration with existing schema - sql.DB compatible and driver agnostic (it uses your driver) I have a pretty complete API to manage Postgres schema and I am working on the SQLite one (a little more complicated due to…
2024 · github.com
- 21RF
Hey HN, I built rawkit.dev, a collection of browser-based developer utilities. No ads, no signups, no tracking. Everything processes client-side — your data never touches a server. The tools: - JSONForge: JSON editor with tree/graph views, diff, transform, JQ-style queries, format conversion - SQLSandbox: SQLite via WASM — import CSVs, write SQL, join across files - Regexplorer: Regex builder with live matching, plain English mode,nmulti-language export - SiftLog: Log file viewer with auto-detection, severity filtering, regex search, timeline - Tabulate: CSV/TSV viewer with…
Feb 2026 · rawkit.dev
- 22LD
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
- 23SQ
Hello HN, We are happy to announce SQLify, a new product from the team behind Kantree (https://kantree.io). Some time ago, we had the request to access data from Kantree through BI tools. We realized one of the easiest way to achieve this was to provide an SQL interface, compatible with PostgreSQL, so that data analyst could query Kantree data like they're used to. No need to learn the details of our API. We realized this process could be useful for many other uses cases. SQLify was born ! It is a superset of SQL that allows you to query APIs. We provide integrations with popular…
2024 · sqlify.me
- 24SP
2020 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →