Author Topic: SQLite database driver  (Read 448 times)

0 Members and 1 Guest are viewing this topic.

Offline unsaneTopic starter

  • Developer
  • *****
  • Posts: 155
  • Country: ru
  • Karma: 10
SQLite database driver
« on: 08 10 2018, 18:03:13 »
This topic is dedicated to SQLite database driver development and beta-testing.
Si no estas con nosotros, estas contra nosotros.
 

Offline Vulpix

  • Beta Tester
  • *****
  • Posts: 614
  • Country: 00
  • Karma: 15
Re: SQLite database driver
« Reply #1 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!
 

Offline dartraiden

  • Beta Tester
  • *****
  • Posts: 1006
  • Country: ru
  • Karma: 34
  • Version Info
Re: SQLite database driver
« Reply #2 on: 09 04 2019, 14:48:15 »
Quote (selected)
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.
_██_
(°ᴗƪ)
 

Offline Vulpix

  • Beta Tester
  • *****
  • Posts: 614
  • Country: 00
  • Karma: 15
Re: SQLite database driver
« Reply #3 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.