THthenorthbay·Aug 8, 2023
Here's the source: https://github.com/thenorthbay/doculite
In Show HN: Doculite – Use SQLite as a Document Databasestefanbielmeier
doculite
TypeScript2023–2023
stefanbielmeier / doculite
doculite
Use SQLite as a Document Database
2Distinct people
2Mentions
0Explicit recommenders
361GitHub stars
What to know before exploring
What it is
Use SQLite as a Document Database
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:56:07 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by hour2 dated mentions
Observed mentions: 2023-08-07 22:12:15 UTC to 2023-08-08 00:06:24 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Aug 7, 22:00 | 2023-08-07 22:00:00 UTC | 2023-08-07 23:00:00 UTC | 1 | 0 | 1 |
| Aug 7, 23:00 | 2023-08-07 23:00:00 UTC | 2023-08-08 00:00:00 UTC | 0 | 0 | 0 |
| Aug 8, 00:00 | 2023-08-08 00:00:00 UTC | 2023-08-08 01:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
2 sourcesFound where you're using those: https://github.com/thenorthbay/doculite/blob/c05d98c209d0031...
It looks like your tables have a single value column and a id generated column that extracts $.id from that value:
CREATE TABLE IF NOT EXISTS ${collection} (
value TEXT,
id TEXT GENERATED ALWAYS AS (json_extract(value, "$.id")) VIRTUAL NOT NULL
)
GENERATED ALWAYS AS was added in a relatively recent SQLite version - 2020-01-22 (3.31.0) - do you have a feel for how likely it is for Node.js users to be stuck on an older version? I've had a lot of concern about Python users who are on a stale SQLite for my own projects.
In Show HN: Doculite – Use SQLite as a Document Database