Managing SQL databases with Knoda

A BETTER VIEW

Author(s):

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)

Related content

comments powered by Disqus

Direct Download

Read full article as PDF:

Knoda_Managing_SQL_Databases.pdf (276.54 kB)

News

njobs Europe
What:
Where:
Country:
Njobs Netherlands Njobs Deutschland Njobs United Kingdom Njobs Italia Njobs France Njobs Espana Njobs Poland
Njobs Austria Njobs Denmark Njobs Belgium Njobs Czech Republic Njobs Mexico Njobs India Njobs Colombia