Alternatives
Products that do what SQLite JavaScript - extend your database with JavaScript does
- 1NB
Manipulate your SQLite database like a giant Javascript object. Built with o1.
2024 · gist.github.com
- 2BA
I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…
2025 · menial.co.uk
- 3SO
Oct 2025 · sqliteonline.com
- 4SP
2021 · sqlime.org
- 5AS
2020 · github.com
- 6SD
- 7DU
Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. Reasons: 1) Using an SQL Database meant having less flexibility and iterating slower. 2) Alternative, proven Document Databases only offered client/server support. 3) No network. Having SQLite server-side next to the application is extremely fast. 4) Replicating Firestore's API makes it easy to use. 5) Listeners and real-time…
2023 · npmjs.com
- 8SP
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the…
2024 · github.com
- 9IW
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com
- 10
- 11
We have been using graph DBs more and more at work. I found them painful to work with locally and decided to try and build something better.
12d ago · github.com
- 12DC
2017 · simonwillison.net
- 13MN
Hello HN! I've found my SQL knowledge to be lacking, so I made a project that uses SQLite as a backend. As it is intended for self-hosting I aim to make it easy to set up and maintain. Getting it up & running takes no more than a few commands (bar setting up a proxy such as nginx, which is out of scope). I've set up a "demo" site at https://forum.agreper.com/ if you want to try out the UI.
2022 · github.com
- 14SQ
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
- 15BE
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
- 16MI
2021 · github.com
- 17MP
2023 · github.com
- 18EA
pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…
2024 · github.com
- 19
- 20SW
2014 · github.com
- 21
- 22NJ
Hello everyone! I'm exited to share a NodeJS package I was working on for the past two months. The package is designed to simplify querying SQL databases through an array-like API. Qustar supports PostgreSQL, SQLite, MySQL, and MariaDB, and offers TypeScript support for a robust development experience. It's in early stage of development. I would like to hear your thoughts about it.
2024 · github.com
- 23SG
I've been working on adding graph database capabilities to SQLite with support for the Cypher query language. As of this week, both CREATE and MATCH operations work with full relationship support. Here's what it looks like: import sqlite3 conn = sqlite3.connect(":memory:") conn.load_extension("./libgraph.so") conn.execute("CREATE VIRTUAL TABLE graph USING graph()") # Create a social network conn.execute("""SELECT cypher_execute(' CREATE (alice:Person {name: "Alice", age: 30}), (bob:Person {name: "Bob", age: 25}), (alice)-[:KNOWS {since: 2020}]->(bob) ')""") # Query the graph with…
Oct 2025 · github.com
- 24DS
Hello HN! I'm building mvsqlite, a distributed variant of SQLite with MVCC transactions, that runs on FoundationDB. It is a drop-in replacement that just needs an `LD_PRELOAD` for existing applications using SQLite. I made this because Blueboat (https://github.com/losfair/blueboat) needs a native SQL interface to persistent data. Apparently, just providing a transactional key-value store isn’t enough - it is more easy and efficient to build complex business logic on an SQL database, and it seems necessary to bring a self-hostable distributed SQL DB onto the platform.…
2022 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →