KSql, previously known as KMySql is a KDE database client. KSql 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.
Here are some key features of "KSql":
· 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.
· KDE 1.1.1 or newer
· Qt 1.42 or newer
· At least one plugin
· At least one working SQL server corresponding to each plugin
· To compile: gcc newer than 2.7.x (or egcs).