PHP/Toolbox is designed to make the process of creating database-powered Websites easier. It utilizes the iterative, or step-by-step development paradigm. It therefore enables you to create fully-functional Web interfaces for an arbitrary set of DB tables within minutes. Any changes you make in these tables after the test driving will be handled automatically. You can then adjust this automatic interface in an iterative manner to suit your specific needs.
Qtime is a Qddb application designed to track consultant time on projects for individual clients. Independent consultants working over the internet will find Qtime particularly useful as it includes a stopwatch, allowance for multiple jobs per client, computation of amount due with time intervals, comment recording, and more. The Qddb database provides report generation, including barcharts and graphs.
DbDesigner is a useful tool for constructing databases in an intuitive and easy-to-use environment, where you have a visual representation of the tables and relations contained in your project. You can quickly see the fields in a table or how each table relates to the others. After you are finished, it can export the schema of the database into an .sql script, or directly connect to a database backend and build it there. It can also import already existing databases from .sql scripts or db backends. It can save your project into its native format (XML) so all information is kept, and it has a plugin architecture to be easily extensible to work with many database servers (it comes with 2 plugins for PostgreSQL and MySQL).
RefDB is a reference database and bibliography tool for SGML, XML, and LaTeX documents. Command-line tools allow interactive or scriptable access to the data which are stored in a SQL database. RefDB can also be accessed through a Web interface, a SRU interface, or via editor extensions (Emacs/vim). Libraries for Perl and PHP are available for programmers. RefDB provides sophisticated character encoding handling, using Unicode by default.
MySQL Backup is a Perl script that uses mysqlshow to grab the database names and "show tables" to grab the table names for a user's account, and then uses mysqldump to save the data in a subdirectory named in the script. It then tars and gzips the files, using the date and time for the file name. It can be run from cron on a daily basis. It removes old files and has an option to email the gzip file to an admin, and/or FTP the file to a remote server. It also has options to use "select data into outfile" or a regular "select" for users who can't use mysqldump. It supports LARGE sets of databases and tables.
TkSQL allows you to edit the tables of PostgreSQL and MySQL databases. You can use it from the shell prompt, specifying the name of a table, or an SQL satement, or just the name of a database. It has filter capabilities which are very easy to use. Two views are possible (tables and form) and both views can coexist. TkSQL can edit a join of two tables (limited to the first of such tables). Totals and subtotals can be done quickly, and displayed inline with the data or in a separate window. Queries can be created in no time and all working conditions can be saved at once (comprising subtotals, relative time constraints, layout, etc.). It also provides basic tools for creating tables.