Not a database, just a map of json strings where you can update the json stored at some key. You could write the same interface on top of localStorage.

It's stored :memory:, there exists the same interface with:

    let x = {}
    x['foo'] = bar

Couchbase mobile has been doing this for over a decade and early versions of membase 15 years ago were using a sqlite backend as a noSQL JSON datastore

I did something similar with dotnet and linq. Idea was to create something like marten but for sqlite instead of postgres. Stopped working on it some time ago, the thing that was really slow was de/serialization, but with new source generators for json maybe it can be sped up.

The worst of both worlds, perfection.

Beautiful. Please turn it into a repository. You wrangled that AI masterfully for this. Well done! :)

dang -- why was this flagged? Seems like a perfectly reasonable post.

Doesn’t sqlite-utils does this and more, better?

At work, we're using sql server, and i stored all json as base64 string though.

> Built with o1.

Yes, yes, database with AI written code. NoSQL with a database that can't be trusted with your data? I. have. seen. this. before. To quote a classic:

> I suggest you pipe your data to devnull it will be very fast

In defense of the database that video was about, I worked as a software architect for the company which became the first commercial user of it, Eliot hilariously didn't want to accept money for support at first. Good old days. However, around 2015 when all three large open source SQL databases --- SQLite, PostgreSQL, MySQL -- added JSON support I felt there was no more need for these NoSQL systems, though.

[dead]

[dead]

[flagged]

[flagged]