GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  GTKSQL (1)

NAME

GtkSQL - SQL database interface

CONTENTS

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.

Search for    or go to Top of page |  Section 1 |  Main Index


Darryl Luff GTKSQL (1) 0.4.5

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.