HOME/Database Tools

Cacheton - An utility to cache pages that frequently query a db which is not updated so frequently. Script can reduce server load up to 50%. Your database will thank you. Easy installation, just create a cache dir and include the script. Configurable cache life, use page compression if you will....click here for more

Using Galistudio`s db_driver, you can easily interface your MySQL database to connect or run queries, and you can also alter your database structure. By providing routines for more than the basics, you use less SQL, thus enabling your code to interface more DBMS`...click here for more

db_upload_file() stores a file in a database table. Make sure that the column data type is big enough for the files you will be storing. db_download_file() retrieves a file from the database and places it in the same path as the script calling it, and returns the relative URL. If the file does not e...click here for more

A class for very basic MySQL database connectivity. Written to reduce redundant code in my own projects aswell as aid in debugging and error reporting during the developement phase. Currently connects to a database, execute external files containing SQL commands, insert and update from an array of k...click here for more

I find this little script very useful for web applications that need to automatically generate tables. I wrote it because I felt it was wrong to have a script execute create table SQL statements for tables that already existed....click here for more

MySQLHandler is a MySQL wrapper supporting the most common functions like: Select, Update, Insert, Delete, Replace. MySQLHandler is designed to aid you when writing queries in your code and you don`t need to write those connection statements. Results are returned as multidimensional arrays, so you d...click here for more

Simplifies integrating databases with web pages. Provides a powerful, user friendly, platform independent API for MySQL, PostgreSQL and ODBC database management systems. Output is XHTML compliant and handicapped accessible....click here for more

A script to import data to a MySQL database from CSV files. Open a CSV file and preview it. Then, connect to your MySQL database, select which fields should receive which column (or set value) and then import. You can add, update or even add and update with this script. This new version allows you t...click here for more