User: Password:
|
|
Subscribe / Log in / New account

KMail2 doesn't store information in databases

KMail2 doesn't store information in databases

Posted Nov 26, 2011 11:44 UTC (Sat) by wazoox (subscriber, #69624)
In reply to: KMail2 doesn't store information in databases by jospoortvliet
Parent article: Trinity Desktop Environment: Keeping KDE 3 alive

Question: using MySQL as a desktop application backend strikes me as unnecessarily heavy; what did bring people NOT to use some variation of Berkeley DB, or one of many DBM implementations (dbm, Tokyo Cabinet, HamsterDB, etc)?


(Log in to post comments)

KMail2 doesn't store information in databases

Posted Nov 27, 2011 10:12 UTC (Sun) by wstephenson (subscriber, #14795) [Link]

Akonadi uses the QtSql api, which supports database plugins. MySQL is the default; sqlite and Postgres are options. We found that the heavily multiprocess and -threaded approach used on desktop builds ran into threading problems with sqlite. For the embedded/mobile builds where some components are run in-process for a smaller footprint, sqlite is used. Postgres support just needs more work and optimisation as has been done for MySQL, to reduce its footprint to the bare minimum needed. I'm not sure why BDB wasn't chosen.

KMail2 doesn't store information in databases

Posted Nov 28, 2011 9:10 UTC (Mon) by anselm (subscriber, #2796) [Link]

Presumably because BDB doesn't support SQL directly. You could try implementing an SQL engine on top of BDB but you would just be reinventing SQLite, which is essentially an SQL engine on top of BDB.

KMail2 doesn't store information in databases

Posted Nov 28, 2011 13:39 UTC (Mon) by nix (subscriber, #2304) [Link]

What? There's no BDB involved in SQLite. It uses fairly conventional database data structures to store data, not a key/value hash.


Copyright © 2017, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds