Store SQLite in Cloudflare Durable Objects

Re:Store SQLite in Cloudflare Durable Objects by hinkley on Tuesday January 25, 2022 @01:08PM (#30075466)

I really think I want a “JSON” format for SQLite that is a strict subset of the SQLite file syntax that can be generated fairly trivially by other applications and read by SQLite. There are apps that produce JSON that would be better served by something I can run search queries upon and jq is nice but it’s not SQLite.

Is there a protobuf implementation of the SQLite file format out there somewhere?

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by rileymat2 on Tuesday January 25, 2022 @01:23PM (#30075731)

I am having trouble with the mapping? I presume this touches on the orm impedance problem? Unless sqlite dictates the json format. But then it probably won’t be the json you like to deal with?

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by pphysch on Tuesday January 25, 2022 @01:41PM (#30076013)

PostgreSQL has excellent JSON support today, including advanced queries, indexing, constraints. There are many cheap/free managed offerings that could rival SQLite in operational simplicity.

If you want a SQL interface to JSON with room to grow, that's your best bet IMO.

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by ignoramous on Tuesday January 25, 2022 @02:02PM (#30076372)

> There are apps that produce JSON that would be better served by something I can run search queries upon...

https://duckdb.org/ ?

[ Parent | on HN ]