On Mon, Jul 10, 2017 at 02:44:31PM +0300, Alek Paunov wrote:
If you say:
create table col1(key blob primary key, value blob) without rowid;/
you physically get no more/no less simple key/value store (given 30 more
lines of trivial code for implementing your favorite key/value lib
operations).
But you are right - sqlite is different piece of cake: sqlite has
powerful query language. Sqlite based backend gives the future advantage
that big chunk of the rpm code could be elegantly and declarative
offloaded to the query engine (with efficiency benefits as bonus).
I did performance tests to compare SQLite with LMDB for my own case here
(using key/value-like things) and the performance difference is *huge*.
--
-- Jos Vos <jos(a)xos.nl>
-- X/OS Experts in Open Systems BV | Office: +31 20 6938364
-- Amsterdam, The Netherlands | Mobile: +31 6 26216181