| sqlayinfilet(1) | SqLay Suite | sqlayinfilet(1) |
sqlayinfilet - a tabular file parsing driver for sqlay.
libsqlayinfilet.so
[sqlaytool] [options] filet:datasource
sqlayinfilet is the tabular file parsing driver for sqlay. It allows to visualize data from tab-, comma-, ... separated files, using autodetection for the file characteristics (presence of field names, quotes, separator). It also allows to visualize the schema (currently including only one table) of the file.
The driver is loaded and the datasource, actually a local file name, interpreted by feeding it to the sqlaytool front-end executable through an (optional) filet: URL.
Alternatively, the filet proto name can be replaced by one of the following aliases: csv or txt or just omitted.
Parameters like table name / pattern are currently ignored as it is not (yet) possible to open a directory and, subsequently, the file always contains only one table which is currently also considered as the database.
The tabular file could normally also be piped directly into the front-end executable through standard input.
Here are options specific to this driver. Please, also refer to the sqlayin(1) man page for options common to all drivers.
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 should be able to detect field names on first line of file base on the fact that no field is empty, otherwise it generates field names in a fashion similar to a spreadsheet.
Therefore it first tries to autodetect the field separator (tab, comma, pipe) based on the presence of those characters in first line, but may also take the file extension in consideration.
It currently does not detect datatypes, does not tries to guess a primary key nor foreign keys, it does not (yet) tries to guess not null flags, won't of course be able to find any default values, won't try to guess presence of indexes, won't generate comments on tables nor columns, nor grants and revokes, but may give a count of lines by table.
The table is currently considered as a view to ensure it is recognized as readonly by the front-ends.
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.
A lot in terms of integrity: the driver performs lot of guesses and approximations.
Besides from this it looks relatively stable.
See also the NOTE above for security warning.
E. Lurquin <sqlay@hitud.net>
sqlayin(1), sqlay(1), sqlsc(1), sqlds(1)
| sqlayinfilet 0.8 | Dec 2008 | sqlayinfilet(1) |