With appropriate configuration, STIL can read and write
tables from a relational database such as
MySQL.
You can obtain a StarTable which is the result
of a given SQL query on a database table,
or store a StarTable as a new table in an existing
database.
Note that this does not allow you to work on the database 'live'.
The classes that control these operations mostly live in the
uk.ac.starlink.table.jdbc package.
If a username and/or password is required for use of the table,
and this is not specified in the query URL,
StarTableFactory will arrange to prompt for it.
By default this prompt is to standard output (expecting a response
on standard input), but some other mechanism, for instance a
graphical one, can be used by modifying the factory's
JDBCHandler.