search

40ants / lisp-project-of-the-day

Here I'll post notes about Quicklisp projects. Also I publish them on Twitter account svetlyak40wt.
http://40ants.com/lisp-project-of-the-day/
BSD 2-Clause "Simplified" License
51 stars 6 forks source link

lmdb #41

Open utterances-bot opened 3 years ago

utterances-bot commented 3 years ago

lmdb

https://40ants.com/lisp-project-of-the-day/2020/10/0201-lmdb.html

melisgl commented 3 years ago

Fernando recently merged a large cleanup patch from me (and there is another one coming). I think you used an older version. More importantly, LMDB has a couple of things going for it:

It's not immediately obvious, but being blazing fast at reading allows one to map data to the db in a fairly direct manner, while multi-key transactions are absolutely necessary unless eventual consistency is somehow sufficient.

As to the benchmarks, Badger seems to be a faster at random writes and slower at reads. Although I'm not sure how much database vendors should be trusted to benchmark their own.

Also, LMDB is a good fit for an application when nosql is: when there are no ad-hoc queries and it is feasible to manage consistency (e.g. foreign keys constraints) by hand.

svetlyak40wt commented 3 years ago

Yess, probably it was older version.