Hacker News new | ask | show | jobs
by zareith 402 days ago
Curious if there is something similar that works with sqlite.
2 comments

There is FerretDB v1, which provides MongoDB protocol for SQLite. See https://github.com/FerretDB/FerretDB/tree/main-v1
They seemed to have moved away from that.

From https://docs.ferretdb.io/migration/migrating-from-v1

> Unlike v1.x that provides options for PostgreSQL and SQLite as backend, FerretDB v2.x requires a PostgreSQL with DocumentDB extension as the backend

As of 3.38 (or 3.45 if you meant a binary JSON structure specifically) https://sqlite.org/json1.html
We can use json type, but the dx around directly using that is not comparable to mongodb. Which is why I was looking for a similar abstraction.