Projects/PIM/Akonadi/Database

< Projects‎ | PIM‎ | Akonadi
Revision as of 15:08, 16 April 2011 by Vkrause (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

Akonadi Server Database Internals

This page contains information about how the Akonadi server uses its internal SQL database. This is purely for Akonadi server developers, you are NOT supposed to use the database yourself, by-passing Akonadi!

Database Schema

  • Visualization
  • Code is in server/src/storage
    • akonadidb.xml contains the schema in an XML format
    • dbinitializer* contains the code to create tables out of that
    • updatedb.xml contains schema update instructions
    • dbupdater.* executes those

Backends

MySQL

Status: working, default backend for desktop systems

TODO

Sqlite

Status: working with limitations, default backend for mobile systems

TODO

PostgreSQL

Status: unknown

TODO

Virtuoso

Status: not working

Proof-of-concept work was done during Akademy 2010, up to the point where the database could be created successfully. Known issues:

  • Some column names used by Akonadi are Virtuoso keywords
  • Some of the first INSERT query fails with a signed vs. unsigned int mismatch/overflow.

Completion of Virtuoso support is considered non-trivial and probably requires a lot of work on the Akonadi side, the SQL dialect is too different from what we support so far.

MySQL/Embedded

Status: not working

Development stopped, MySQL/Embedded does not support transactions.


Tools

Generic

akonadiconsole has support for browsing the database and run arbitrary SQL queries. See Development/Tutorials/Akonadi/Application.

MySQL

There are convenience scripts for running mysqld in the configuration used by Akonadi as well as (and probably more useful) running the MySQL command line client connected to the Akonadi database. See server/src/storage/akonadi-mysql-[client|server].sh.


KDE® and the K Desktop Environment® logo are registered trademarks of KDE e.V.Legal