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.
Read full article as PDF:
Knoda_Managing_SQL_Databases.pdf (276.54 kB)Tag Cloud
News
-
An Even Smaller Raspberry Pi
The Raspberry Pi Foundation has announced an even smaller version of the tiny computer that will fit into a DIMM slot.
-
Newly Discovered Android Vulnerability Causes Privilege Escalation
A new class of problems lets a malicious app pre-configure an invisible privilege update.
-
Facebook Rolls Out New PHP-like Programming Language
New Hack language adds static typing and other conveniences.
-
Fedora Announces Innovative Crytography Policy System
New crypto policy system will offer easier configuration and more uniform security.
-
Shuttleworth Calls for Declarative Firmware
Ubuntu founder denounces insecurity in proprietary, close-source software blobs.
-
New TLS Attack Takes the S out of HTTPS
Vulnerability affects many Linux web servers
-
Munich Adopts Kolab
The Bavarian capital shuns Microsoft, Google, and other alternatives to implement an open source groupware solution.
-
Canonical Announces Ubuntu Smartphones
Phone vendor partnerships bring Mark Shuttleworth's dream of Ubuntu on a phone a step closer to reality.
-
Piviti Seeks Funding
Donors will get to vote on new features for the free video editor.
-
Debian Tech Committee Votes for systemd
Debian project puts init out to pasture and says no to Ubuntu's Upstart.