GtkSQL

Section: http://gtksql.sourceforge.net/ (1)
Updated: 0.3.3
Index Return to Main Contents
 

NAME

GtkSQL - SQL database interface  

SYNTAX

gtksql [-h] [-s "script" ] [-f scriptfile]  

DESCRIPTION

GtkSQL is an interactive SQL interface to various databases. Currently, MySQL and PostgreSQL are supported.

A script interface is provided using the LUA script language. The program configuration and workspace files are saved as LUA scripts.

NOTE: It is possible to compile GtkSQL without LUA support. If you do this, saved workspaces and scripts will not be supported.

 

OPTIONS

-h>
Show command-line help.
-s <script>
Runs <script> directly.
-f <scriptfile>
Loads and runs a script from <scriptfile>.

 

FILES

/usr/bin/gtksql

 

ENVIRONMENT VARIABLES

HOME
Specifies the home directory
 

EXAMPLES

Connect to the "billing" database on the MySQL server myserver.com.

gtksql -s 'connect("mysql://myserver.com/billing")'

Connect to the same server as the user fred, with password password:

gtksql -s 'connect("mysql://fred:password@myserver.com/billing")'

And the same with a PostgreSQL server:

gtksql -s 'connect("postgresql://fred:password@myserver.com/billing")'  

SCRIPTS

Scripts are straight text files. It uses the LUA engine, which is documented at http://www.lua.org. All of the standard LUA functions are available. In addition to these, GtkSQL adds the following functions:

-h
Show command-line help.
addquery(<querytext>)
Adds a query containing the given text.
connect(<url>)
Connects to the given url.
deleteQueries()
Removes all existing queries.
exit()
Exits the program.
help()
Displays simple help on the LUA script functions.
loadQuery(<queryfile>)
Opens a new query and loads the file into it.
moveWindow(x, y)
Move the window to the position given. The x and y locations refer to the distance of the top left of the GtkSQL window, from the top left of the screen.
sizeWindow(width, height)
Resize the window. Note that there is a minimum size built into the application. The minimum size depends on the screen size of the various buttons etc.

 

AUTHORS

Darryl Luff <djluff@users.sourceforge.net>  

SEE ALSO

None.


 

Index

NAME
SYNTAX
DESCRIPTION
OPTIONS
FILES
ENVIRONMENT VARIABLES
EXAMPLES
SCRIPTS
AUTHORS
SEE ALSO

linux.jgfs.net manual pages