A simple program to extract reports from simple databases
tdb is a program for manipulating standard comma-delimited
databases, such as those produced by Paradox, Access, dbase, etc... with the
it can add, extract and remove records from the command line, and more important
it can produce html pages from your data in a snap! Simply describe the format of the page
It is also well-suited for the automatic maintenance of databases,
such as our user database.
The common uses of tdb in a web site are:
- Automatic generation of pages
- in this case, the report facility of tdb is used to periodically rebuild a set of html pages from a database and a "form": a skeleton of the page containing an html description of the header and footer of the page and of how each record will be displayed. An example can be found in http://webcategory.magellano.it/webcategory.
- Execution of queries
- in this case, tdb is called from a cgi-bin program which parses a search form and composes a query. An example of this is http://cercaemail.magellano.it.
- Database maintenance
- a set of cgi-bin programs can parse a form, and generate a proper call to
tdb add, update or remove. An example can be found at http://cercaemail.magellano.it/usr_add.html.
tdb is currently available for SunOS/Solaris, Linux, Digital Unix, WIndows 95/98 and NT; please ask for porting on other machines.
IMPORTANT NOTICE: tdbodbc is now available: it is a tool with the reporting options of tdb, but which operates on ODBC data sources and with the standard SQL language: GREAT for batch files on your NT server.