Database Tables
The object is simple: stick a small common prefix in front of each database table in the catalog, so that you can easily tell one catalog from another within the same database.I've done this by:1. Adding a variable - DB_TABLE_PREFIX - to the configure.php files2. Inserting this new variable into...
Platforms: Windows, *nix, PHP, BSD
License: Freeware | Download (69): Prefix for Database Tables Download |
Basset::DB::Table is used to define database tables, ways to load that data into memory and build queries based upon the table information. SYNOPSIS For example, my $table = Basset::DB::Table->new( name => user, primary_column => id, autogenerated => 1, definition => { id =>...
Platforms: *nix
License: Freeware | Size: 143.36 KB | Download (98): Basset::DB::Table Download |
PHP SQLDiff is a Web application that shows the difference between two SQL database tables. If you manage your database tables like I do, you also make copious copies of the tables. When I go to make any serious change to a table, I copy the table to another database and make my changes there....
Platforms: *nix
License: Freeware | Size: 573.44 KB | Download (97): PHP SQLDiff Download |
SQLDiff is a Web application that shows the difference between two SQL database tables. It makes use of PEAR::DB for its database access and this means that most common databases should work. This application has been tested with Mysql, Postgres and Sybase. As long as PEAR::DB has complete...
Platforms: Windows, Mac, *nix, PHP, BSD Solaris
License: Freeware | Download (57): SQLDiff Download |
Adds interfaces to database tables on pages, posts, dashboard and custom menu groups within admin, to manage data. Build custom databased application for managing data from simple data entries to more complex linking tables.I'm running a tutorial series to explain the fundermentals on using the...
Platforms: PHP
License: Freeware | Size: 2.33 MB | Download (45): DB Toolkit Download |
Auto-generates table descriptions for Views based on actual database tables. Requires schema.module for gathering information about the table. Basic usage:You can augment and alter the auto-generated information by implementing hook_views_data_alter(). This is also the place where you can add...
Platforms: PHP
License: Freeware | Size: 10 KB | Download (46): Views Schema Download |
Database Copier can access a MySQL server, list its tables, query the table record data, connect to another MySQL server and recreate the database tables with data copied from the first database.If there are destination tables with the same name, the class can drop them.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (45): Database Copier Download |
backup & restore database can generate a backup file that contain SQL statements to create all the database tables and insert its table record data.Previously generated SQL backup files can be read and executed to restore the database tables and records.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (44): backup & restore database Download |
A generic SQL driven data audit tool for detecting differences between any JDBC accessible database tables and other data sources. Platform independent. It's a unix like diff for databases. Produces key values with the differing column name and data
Platforms: Windows, Mac, Linux
License: Freeware | Size: 15.53 MB | Download (55): Compare Database Table Data Download |
Closure Table can create MySQL database tables that will store information about hierarchies of nodes stored in other database tables.Nodes can be organized hierarchically by weight and depth by different classes. They can be inserted, deleted, retrieved and sorted.
Platforms: PHP
License: Freeware | Size: 30.72 KB | Download (45): Closure Table Download |
Several classes provide access to MySQL database tables in order to create, read, update and delete database table rows as if they were objects.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (45): CRDB Download |
kisDB, a list of database tables can be retrieved.Key Features of kisDB:- Establish MySQL database server connections- Execute SQL queries from lists of parameters- Display debug output of the executed queries
Platforms: PHP
License: Freeware | Size: 10 KB | Download (40): kisDB Download |
Forms to insert, update and delete records in database tables, can be composed.cls_form generates the necessary HTML to present forms for each type of action and executes the corresponding database queries.
Platforms: PHP
License: Freeware | Size: 102.4 KB | Download (41): cls_form Download |
The purpose of this class is to help in the updating of data stored in database tables. Tablemaint has functions to add, modify, delete and search for data in the database table rows.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (42): Tablemaint Download |
The plugin optimize Your WordPress Database Tables regularly.Installation : 1. Upload the entire table-optimizer folder to the /wp-content/plugins/ directory. 2. Activate the plugin through the 'Plugins' menu in WordPress.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (52): Table Optimizer Download |
Formitable is a PHP class used to ease the creation of submit-ready HTML forms from MySQL database tables. Formitable project analyzes the fields of a given table and outputs the best input type for each (e.g. enum type becomes radio buttons or select, set type becomes checkboxes or...
Platforms: *nix
License: Freeware | Size: 18.43 KB | Download (95): Formitable Download |
EMS Data Generator for MySQL is an application for generating test data to several MySQL database tables at once.
The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists...
Platforms: Windows, 2K, XP, 2003, Windows Vista
License: Freeware | Download (58): EMS Data Generator for MySQL 2011 Download |
EMS Data Generator for PostgreSQL is an application for generating test data to several PostgreSQL database tables at once.
The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files,...
Platforms: Windows
License: Freeware | Download (57): EMS Data Generator for PostgreSQL 2011 Download |
EMS Data Generator for DB2 is a powerful utility for generating test data to several DB2 database tables at once.
The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists...
Platforms: Windows
License: Freeware | Download (49): EMS Data Generator for DB2 2011 Download |
EMS Data Generator for SQL Server is an application for generating test data to several Microsoft SQL database tables at once.
The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from...
Platforms: Windows
License: Freeware | Download (60): EMS Data Generator for SQL Server 2011 Download |