{"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":"http:\/\/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=\"http:\/\/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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20KDE%204.2%20brings%20the%20MySQL%20server%20to%20the%20desktop&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F02%2F19%2Fkde-42-brings-the-mysql-server-to-the-desktop&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"a037d7eb14\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1336\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1336\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1336\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20KDE%204.2%20brings%20the%20MySQL%20server%20to%20the%20desktop&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F02%2F19%2Fkde-42-brings-the-mysql-server-to-the-desktop&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"a037d7eb14\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1336\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1336\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1336\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/19\/kde-42-brings-the-mysql-server-to-the-desktop?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[754,753,624,1775,752],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-ly","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1243,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/12\/25\/amarok-20-uses-mysql","url_meta":{"origin":1336,"position":0},"title":"Amarok 2.0 uses MySQL","date":"25\/12\/2008","format":false,"excerpt":"I've always been more of a GNOME guy, and when running Linux, I use Rhythmbox to play my music. However, Amarok 2.0 might just change that. They've chosen their database - it is none other than MySQL. The release notes state: Some features, such as the player window or support\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3131,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04","url_meta":{"origin":1336,"position":1},"title":"Ubuntu Online Summit: MySQL &#038; Variants in 16.04","date":"10\/11\/2015","format":false,"excerpt":"I personally have always enjoyed the Ubuntu Developer Summits (UDS), but nowadays they have been converted to the Ubuntu Online Summits (UOS). Attending them is not always convenient (timezone issues, might be travelling, etc.) so I watched the recorded video of a session I was interested in: MySQL & Variants\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2708,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/04\/30\/testing-fedora-19","url_meta":{"origin":1336,"position":2},"title":"Testing Fedora 19","date":"30\/4\/2013","format":false,"excerpt":"Today I downloaded Fedora 19 alpha to give it a spin. Some quick notes. You can get MySQL by asking for the package community-mysql-server. This is 5.5.31. If you ask for stock \"mysql\" (i.e. yum install mysql-server), you automatically get MariaDB 5.5.30 (mariadb-server). Fedora 19 runs systemd, so there is\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2004\/01\/22\/the-interesting-web","url_meta":{"origin":1336,"position":3},"title":"The Interesting Web","date":"22\/1\/2004","format":false,"excerpt":"If you're tired of seeing the GNOME vs. KDE wars, you haven't seen this yet! It's actually downright funny, and a certain portion of it is pretty ironic. Get serious with an interview with Robert Love, which I might add, explains what Project Utopia is meant to do, in layman's\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2914,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/04\/22\/ubuntu-14-04-some-mysql-ecosystem-notes","url_meta":{"origin":1336,"position":4},"title":"Ubuntu 14.04 &#8211; some MySQL ecosystem notes","date":"22\/4\/2014","format":false,"excerpt":"Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure - 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1054,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/21\/workbench-511-alpha-on-fedora-9","url_meta":{"origin":1336,"position":5},"title":"workbench-5.1.1-alpha on Fedora 9","date":"21\/9\/2008","format":false,"excerpt":"So, you want to compile Workbench for Linux, on Fedora 9. You need to install the following packages: autoconf automake libtool libzip-devel libxml2-devel libsigc++20-devel libglade2-devel gtkmm24-devel mesa-libGLU-devel mysql-libs mysql mysql-devel uuid-devel lua-devel glitz-devel glitz-glx-devel pixman-devel pcre-devel libgnome-devel gtk+-devel pango-devel cairo I feel I'm being too liberal with dependencies, but I'm\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1336"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1336"}],"version-history":[{"count":2,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1336\/revisions"}],"predecessor-version":[{"id":1338,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1336\/revisions\/1338"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1336"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}