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.
|