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
News
-
Red Hat Enterprise Linux 7.5 Released
The latest release is focused on hybrid cloud.
-
Microsoft Releases a Linux-Based OS
The company is building a new IoT environment powered by Linux.
-
Solomon Hykes Leaves Docker
In a surprise move, Solomon Hykes, the creator of Docker has left the company.
-
Red Hat Celebrates 25th Anniversary with a New Code Portal
The company announces a GitHub page with links to source code for all its projects
-
Gnome 3.28 Released
The latest GNOME rolls out with better contact management and new features for handling virtual machines.
-
Install Firefox in a Snap on Linux
Mozilla has picked the Snap package system to deliver its application to Linux users.
-
OpenStack Queens Released
The new release comes with new features for mission critical workloads.
-
Kali Linux Comes to Windows
The Kali Linux developers even managed to run full blown XFCE desktop via WSL.
-
Ubuntu to Start Collecting Some Data with Ubuntu 18.04
It will be an ‘opt-out’ feature.
-
CNCF Illuminates Serverless Vision
The Cloud Native Computing Foundation announces a paper describing their model for a serverless ecosystem.