|
Welcome
|
|
kio_sql is a KDE 3.1
IOSlave
using the Qt 3.1 SQL capabilities.
It can display tables, queries and execute any SQL command.
Results can be displayed in different output formats (text, html...).
By default it operates in an interactive mode to display additional
information and allows the user to enter SQL queries.
It is still in production stage, so don't expect too much.
License: GPL
|
|
Download
|
|
Sorry, there are no binary packages since kio_sql is work in progress.
The latest version can be found in the KDE repository (playground/ioslaves/kio_sql)
lates source distribution:
kio_sql-0.4.tar.gz
Older versions:
kio_sql-0.3.tar.gz
kio_sql-0.21.tar.gz
kio_sql-0.2.tar.gz
kio_sql-0.11.tar.gz
|
|
Installation
|
|
Installation: See the file INSTALL. For advanced users:
./configure --prefix=$KDEDIR
make
make install
Note: Make sure that the environment variable $QTDIR points to the
directory where Qt 3.1 is installed and $KDEDIR points to the KDE 3.1
directory.
After that you should see a new entry called "sql"
in Preferences->Information->Protocols.
Enter sql:/ in the Konqueror location bar to
see the start page.
|
|
Documentation
|
There is no documentation yet, any help would be greatly appreciated ;)
- Display start page:
sql:/
- Display all avaialable tables:
sql://[HOST]/[PLUGINNAME]/[DATABASENAME]
- Display the contents of a table:
sql://[USER:PASSWORD@][HOST]/[PLUGINNAME]/[DATABASENAME]/[TABLE]
- Display the contents of a query (query has to be URL-encoded):
sql://localhost/QMYSQL3/mydatabase?query=select+*+from+test
- Output in different formats via "output" parameter:
sql://localhost/QMYSQL3/mydatabase/mytable?output=text
output formats can be text, csv and html (the default)
Note that kio_sql will ask you for the username/password when you first connect to
a database and remember it during the session. But you can of course also pass
usernames/passwords via URL:
sql://[USER:PASSWORD@][HOST]/[PLUGINNAME]/[DATABASENAME]/[TABLE]
Please look at the Qt SQL driver documentation
for information how to build the required database plugins.
|
|
|
|
News
|
2005-05-05 - moved the sources to KDE repository
2003-08-30 - release of version 0.4
2002-22-10 - release of version 0.3
2002-04-04 - release of version 0.21
2002-04-01 - redesign of this website
|
|
ChangeLog
|
2002-08-30 Harald Fernengel
* support for file operations,
can now be used from within
a filedialog
2002-10-22 Harald Fernengel
* added support for inserting/
updating/deleting rows
2002-04-04 Harald Fernengel
* added meta-data support
2002-04-03 Harald Fernengel
* redesigned html start page
* added LIMIT support
2002-04-02 Harald Fernengel
* added CSV
* full Unicode (Utf8) support for html output
2002-03-08 Harald Fernengel
* pluggable output formats
* added authentication cache
|
|
TODO
|
- More output-formats: XML, (X)HTML with style-sheets
- better documentation
- ability to cast BLOB fields to different mime-types so you can listen to MP3s from a database
|
|
Screenshots
|
|
|
Contact
|
|
Comments, flames, etc. to: |harry| at |kdevelop| dot |org|
|
|