Managing SQL databases with Knoda
A BETTER VIEW
KDE’s Knoda provides an intuitive front end for an SQL database. This workshop introduces Knoda and shows how you can use Knoda to simplify common database management tasks.
Many Linux users wish for a simple GUI-based tool that would help them manage their database intuitively. KDE’s Knoda program is a good candidate for this role. In this first part of our Knoda workshop, we investigate the basic functions of Knoda. You’ll learn how you can use an existing database to create fairly complex queries with just a few mouse clicks. SQL without the Headaches Knoda is a KDE database front-end for the MySQL, PostgreSQL, SQLite2, and SQLite3 databases. Knoda can also use ODBC drivers to access other database servers. We will focus on SQLite for this workshop. If you would like to work through the examples, you will need the SQLite2 database, musik.db, which is stored in the download area of the Linux Magazine website [1]. The database is a typical playlist-type database as used by the KDE player Amarok for internal management purposes.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
Tag Cloud
News
-
Heartbleed Bleeds On
According to a report, many potential victims of the Heartbleed attack have patched their systems, but few have cleaned up the crime scene to protect themselves from the effects of a previous intrusion.
-
Drone Brain Goes Open Source
DARPA and NICTA release the code for the ultra-secure microkernel system used in aerial drones.
-
Password Management Services Vulnerable to Attack
Should you trust an online service to store your online passwords?
-
New Raspberry Pi Adds Two USB Ports
New B+ board lets you build cool things without the complication of a powered USB hub.
-
Microsoft Grabs No-IP.com Domains
Redmond rushes in to root out alleged malware haven.
-
Firefox Steps into 3D
New initiative will bring futuristic virtual reality effects to the web surfing experience.
-
New Trojan Targets Online Banking
Dyreza malware launches a man-in-the-middle attack that compromises SSL.
-
HP Rolls Out Massive Cloud Network
New cloud combines worldwide access with local attention to data security.
-
New Attack Targets Wireless Logins
A first cousin of the recent Heartbleed attack affects EAP-based wireless and peer-to-peer authentication.
-
Geeks Petition for Free Lenovo BIOS
FOSS community acts to protect freedom of choice for laptop devices.