SQLite 3.21 Picks Up F2FS Atomic Write Support

[phoronix]

Phoronix: SQLite 3.21 Picks Up F2FS Atomic Write Support

SQLite 3.21 is now out as the newest feature release for this widely-used embedded database library...

http://www.phoronix.com/scan.php?page=news_item&px=SQLite-3.21-Released

[uid313]

Is there anything like SQLite for NoSQL?
Where you can store things like JSON documents.

[bngle]

Is there anything like SQLite for NoSQL?
Where you can store things like JSON documents.

https://www.sqlite.org/json1.html

[nils_]

Is there anything like SQLite for NoSQL?
Where you can store things like JSON documents.

What exactly do you need? If it's just a key value store you may want to look at TokyoCabinet or even BerkeleyDB. Or do you want something like MongoDB, just embedded?

[uid313]

https://www.sqlite.org/json1.html

JSON support in SQL databases tend to suffer from two problems.

• Non-standard implementation. Not compatible with other RDBMS. Not compliant with the SQL/JSON standard.
• Writing does not update only the key in the document that was changed but overwrites the entire document.

What exactly do you need? If it's just a key value store you may want to look at TokyoCabinet or even BerkeleyDB. Or do you want something like MongoDB, just embedded?

With my limited experience I find key-value stores rather useless for anything else than holding simple configuration, and even not particularly useful for that either.

I was more thinking of a document store so that I can store JSON objects, something like MongoDB but embedded.

[nils_]

I was more thinking of a document store so that I can store JSON objects, something like MongoDB but embedded.

http://ejdb.org/ might be what you want, or https://unqlite.org/

[uid313]

I wonder why nobody implements a DBMS over a embedded database system.

http://ejdb.org/ might be what you want, or https://unqlite.org/

Thanks both of those look very interesting.
EJDB looks particularly interesting.

[cbxbiker61]

It's nice to see software pick up these sorts of enhancements. Time and filesystem enhancements march forward.

Even though this particular enhancement is at this stage rather niche. For me it's quite nice since all of my ARM boards are on F2FS and I use sqlite for my custom package manager DB files.

BTW: F2FS has been working on my Arm boards for years now, and has given me little to no problems. It's also interesting that F2FS's storage strategy seems to be a very nice fit for SMR drives. I'm waiting just a bit more, maybe a year or two before I get serious about maybe using host-managed SMR drives. I have large archived files that are seldom accessed and SMR can potentially bring down cost/TB significantly for that use.