SQLite database driver

[unsane]

This topic is dedicated to SQLite database driver development and beta-testing.

[Vulpix]

I had a chance to test the early versions and they woked for the most part, but they were not usable. Even on a ramdisk they just took hours to import history and simply weren't feasible.

I'm pleased to say this is no longer the case and the plugin seems to be performing admirably.

I intend to do more testing starting today, possibly switching to it if I encounter no other issues.

I have also verified I can simply plop it into any sqlite client and open the db that way, which is excellent.

Great job thus far @Unsane!

[dartraiden]

plugin seems to be performing admirably

Database structure is terrible, but we can fix it. We are also going to depreciate mdbx in favor of sqlite if we can improve sqlite performance.

[Vulpix]

My current issue is that I lose all "duplicate" events when importing into sqlite (even if the checking is not enabled). That is, any events with identical timestamp are gone after import. So I cannot use it.. The speed seemed to be decent however.

I'm all for sqlite.