Miranda NG Official Community Forum

Forum for English speaking Miranda NG users => Development => Topic started by: unsane on 08 10 2018, 18:03:13

Title: SQLite database driver
Post by: unsane on 08 10 2018, 18:03:13

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

Title: Re: SQLite database driver
Post by: Vulpix on 20 10 2018, 06:18:49

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!

Title: Re: SQLite database driver
Post by: dartraiden on 09 04 2019, 14:48:15

Quote

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.

Title: Re: SQLite database driver
Post by: Vulpix on 09 04 2019, 17:29:31

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.