NAME

sqlayinslite - a SQLite database driver for sqlay.

SYNOPSIS

libsqlayinslite.so

[sqlaytool] [options] slite:datasource

DESCRIPTION

sqlayinslite is the SQLite driver for sqlay. It supports DML read-write and DDL. It interpretes a datasource feeded in the form of a slite: URL allowing to connect to a SQLite file.

It has been initially developped with SQLite 2.7.6 and is now tested mainly with SQLite 2.7.8.

INVOCATION

The driver is loaded by giving as argument to the sqlaytool front-end executable an (optional) slite: URL.

Alternatively, the slite proto name can be replaced by the following alias: sqlite.

A path to the sqlite file or, just a file name if in current directory, must then be given on the url.

Substitutions like ~ are not done on the path.

Parameters like table name / pattern must be separated from the path / file name by a double slash (//).

OPTIONS

Here are options specific to this driver. Please, also refer to the sqlayin(1) man page for options common to all drivers.

• Datasource:
  • The user, password, host, port options of the URL are ignored and interpreted as part of the file name.

FEATURES

Here are features not or partially supported by this driver. Please, also refer to the sqlayin(1) man page for features supported or not by all drivers.

The driver detects tables names, view names, field names, INTEGER and any other datatype flagged as CT (text) with length set to 0, default values without most obvious highlighting, unique and non-unique indexes (without warranty), a count of data by table or view.

It does not detect null or not null flags, primary keys, nor probably some indexes.

Also it could not detect comments, datatype lengths nor precisions, foreign keys, grants, inexisting in SQLite up to 2.7.x.

NOTES

As other input drivers for sqlay, the only connection available for now is a shared connection.

Pls understand that this is an alpha release and none of the executables is securized against buffer overflows, and so on. It is also not thread safe.

BUGS

See the NOTE above for important security warnings.

AUTHOR

E. Lurquin <sqlay@hitud.net>

SEE ALSO

sqlayin(1), sqlay(1), sqlsc(1), sqlds(1) and the html documentation of sqlite.