{"id":1336,"date":"2009-02-19T02:55:39","date_gmt":"2009-02-19T07:55:39","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1336"},"modified":"2009-02-19T04:11:24","modified_gmt":"2009-02-19T09:11:24","slug":"kde-42-brings-the-mysql-server-to-the-desktop","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop","title":{"rendered":"KDE 4.2 brings the MySQL server to the desktop"},"content":{"rendered":"<p>If you&#8217;re using Fedora 10, and are a KDE desktop user, you&#8217;ll notice that your latest KDE 4.2 update, requires having a local MySQL server installed. This is due to <a href=\"http:\/\/pim.kde.org\/akonadi\/\">Akonadi<\/a>, part of the KDE PIM packages, that now rely on MySQL as a default server, for storing PIM data. Just a few months ago, I mentioned the news that <a href=\"https:\/\/www.bytebot.net\/blog\/archives\/2008\/12\/25\/amarok-20-uses-mysql\">Amarok 2 will also use MySQL<\/a> as a default database.<\/p>\n<p>Akonadi uses MySQL mainly as a cache, not as a data store. This is something that <a href=\"http:\/\/www.mail-archive.com\/debian-qt-kde@lists.debian.org\/msg24617.html\">Debian users<\/a> will also see. Eventually, anyone with KDE 4.2 will see the requirement to have a MySQL server installed. If you already have a native installation of MySQL provided for by your distribution (maintained by RPM\/DPKG), it naturally won&#8217;t be installing another copy &#8211; it just uses the system-wide version.<\/p>\n<p>Not everyone is <a href=\"http:\/\/www.nabble.com\/KDE-4.2-requires-local-MySQL-Server-td22019412.html\">happy<\/a>. Especially those that use netbooks, with limited disk space. Reading <a href=\"http:\/\/ronaldbradford.com\/blog\/reducing-the-mysql-5130-disk-footprint-2009-02-11\/\">Reducing the MySQL 5.1.30 disk footprint<\/a> by Ronald Bradford might help in that respect &#8211; there are ways to reduce up to 25% of the space.<\/p>\n<p>However, from a MySQL perspective, and as a member of the Sun Database Group, I am happy to see the ubiquity of MySQL, on the Linux desktop.<\/p>\n<p>For the technical folk amongst you, its worth looking at the <a href=\"http:\/\/cvs.fedoraproject.org\/viewvc\/rpms\/akonadi\/F-10\/akonadi.spec?revision=1.16&#038;view=markup\">akonadi spec file<\/a>:<\/p>\n<pre>\r\nBuildRequires: mysql-devel\r\nBuildRequires: mysql-server\r\n..\r\n# when\/if akonadi grows support for other backends, consider splitting\r\n# these similar to how phonon is done currently.\r\nRequires: qt4-mysql\r\n# not *strictly* required, but we need a functional default configuration\r\nRequires(hint): mysql-server\r\n..\r\n%{summary}.\r\nRequires an available instance of mysql server at runtime.  \r\nAkonadi can spawn a per-user one automatically if the mysql-server \r\npackage is installed on the machine.\r\nSee also: %{_sysconfdir}\/akonadi\/mysql-global.conf\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re using Fedora 10, and are a KDE desktop user, you&#8217;ll notice that your latest KDE 4.2 update, requires having a local MySQL server installed. This is due to Akonadi, part of the KDE PIM packages, that now rely on MySQL as a default server, for storing PIM data. Just a few months ago, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[754,753,624,1775,752],"class_list":["post-1336","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-akonadi","tag-fedora-10","tag-kde","tag-mysql","tag-pim"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-ly","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"amp_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1336"}],"version-history":[{"count":2,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1336\/revisions"}],"predecessor-version":[{"id":1338,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1336\/revisions\/1338"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}