Tiny SQL for [metakit] databases. This is an reliminary release! Author: Dr. Detlef Groth, MPIMG Berlin Current homepage is at: http://goblet.molgen.mpg.de/tsql4mk/ From the readme: --- '''README''' ---- '''DESCRIPTION''' tsql4mk is an experimental library and a console application for executing sql-statements against Metakit databases. It implements a subset of SQL92. tsql4mk uses Jean-Claude Wipplers Oomk and Will Duqette's "snit" (Snit Is Not Incrtcl), version 0.97. The api is modelled after R. Hipps great SQLite http://www.sqlite.org. This manuals were partially copied and adjusted for tsql4mk from the language reference of SQLite http://www.sqlite.org. Thanks fro D. Richard Hipp for this great piece of software. ---- '''LIMITS''' The main limits of tsql4mk against SQLite are: * much lower speed, although not measured yet (layer on a layer ...) * only a small subset of the sql-language is implemented * limited join capabilites * no NULL is known The advantages are: * no compilation required if you use the ''tclkit'' [http://www.equi4.com] runtime * console, library and documentation are in one file -> easy installation and deployment ---- '''USAGE''' Examples: | ---------------- | Usage: tsql4mk.kit ?-doc? ?-example? ?-run? ?-help? | -doc Show a bit of documentation | -example Display the example script | -run Run the example script | -html Show the html documentation ---- '''LIBRARY''' To use tsql4mk, either unwrap tsql4mk.kit and source "tsql4mk.tcl", or if you use a new Tclkit with Metakit 2.4.9: simply source this starkit. ---- '''CONSOLE APPLICATION''' tsql4mk.kit can be also as standalone console application in several ways: | Usage: tsql4mk.kit or via pipes: | echo | tsql4mk.kit Pipes can be used to execute several sql-statements at ones from a file and pipe this into the tsql4mk.kit application. | cat | tsql4mk.kit This feature can be also used to convert a sqlite database into a metakit database: | echo .dump | sqlite test.sqlite | tsql4mk.kit The reverse way metakit -> sqlite is currently not yet implemented. ---- '''Documentation''' See http://goblet.molgen.mpg.de/tsql4mk/index.html ---- '''Installation/Download''' If you don't have already download tclkit suitable for your platform from ''www.equi4.com'' [http://www.equi4.com/pub/tk/downloads.html]. Put it in your path. Download tsql4mk.kit from ''here'' [http://goblet.molgen.mpg.de/tsql4mk/tsql4mk.kit]. Done!