KSql
Information

Description

KSql, previously known as KMySql is a KDE database client. It was originaly mySQL specific, but uses now plugins to access databases like miniSQL and PostgreSQL.

The first goal of this project was to provide access to databases in a easy to use and GUI-driven way, in order to replace original ugly text-mode clients. This goal is now completely achieved: one can browse several SQL servers in a tree-view, send any SQL queries, and view the result in multiple tabular views.

The second goal was to provide extended database facilities, like forms, table creation and editing, servers administration, and so on.

The ultimate goal is to obtain a full-featured database application, having the application concept. This is planned for the next kmysql generation.

Features

With current stable version (1.2.x) you can:

do anything you would do with the default text-mode client,
view queries result in multiple tabular views, print them or export then in HTML,
edit your queries in a comfortable edit box with history,
create nice forms, with a wysiwig editor,
save usual queries and recall them with a double-click,
create tables and add/remove/edit columns,
edit the contents of your tables,
connect to and browse any number of servers of at the same time
use several types of SQL servers at the same time via plugins,
Administrate your mySQL server,
Access your forms with your browser using HTML forms and PHP.

For more info you may want to take a look at the documentation, also available online.

Screenshots

If you want to see how KMySql looks like, take a look at this:

Description Size KMySql version Screenshot

The main view 120k 1.2.0 pre2

The main view 148k 1.1.6

The form editor 66k 1.1.6

The table editor 64k 1.1.6

Plugins

Plugins are used to deal with SQL servers. Although some of them don't support KMySql-specific features yet, they all offers at least as many features as the default text-mode client.

SQL server Plugin name Comment

MySQL kmp_mysql The original plugin, which handles all KMySql features.

PostgreSQL kmp_psql Does not support kmysql-specific functions.

miniSQL kmp_msql Does not support kmysql-specific functions.

Sybase kmp_sybase Alpha

KMySql-PHP

Kmysql-php is a PHP library permitting ultra-easy acces to KMySql forms via a browser, as standard HTML forms. Just three lines of PHP code are enough to provide full access to a form.

Since KMySql 1.2.x forms work only with MySql servers, this library currently only works with MySql.It will be integrated in the next version of KMySql (which is KSql 2.0), and since KSql will handle properly all database types, the ksql-php library will also do so.

It can be dowloaded on the dowload page. For more details, see the online documentation.