dteq is a query tool that passes results through a template. It is well-suited for auto-generating all kinds of things from a database like authentication tables, DNS zone files, or whatever you can come up with. It also does updating commands like INSERT and UPDATE and reports back the number of rows affected. This used to be named mysqlquery but it is now DB-independent, with cdb, MySQL, and PostgreSQL drivers available.
|Tags||Database Front-Ends Systems Administration|
|Operating Systems||POSIX Unix|
Release Notes: An experimental PostgreSQL driver was added. Small cleanups and fixes were made.
Release Notes: This versions adds a cdb driver and makes small changes to the interface to allow for drivers that don't need authentication. Also, various small bugfixes and cleanups have been applied.
Release Notes: Modular support for other DBs than MySQL, a new name to reflect this change, and code cleanups.
Release Notes: This release adds a small Makefile fix to compile on more Linuxes, a comment that was in Dutch and is now rewritten in English, a template parser that checks if it is generating unknown tokens, a fix for a bug that caused a row of "$"s to be considered as just one, and handling of "\" in the template to escape a "$". This version is released under the BSD license.
Release Notes: One stupid warning was fixed. A 'static2' Makefile target (undocumented) was added that links in libmysqlclient.a but not libc.a, which saves over 200 kbytes in the size of the binary.