24 projects tagged "Database"
mysqldiff is a Perl script which compares the data structures (i.e. table definitions) of two MySQL databases and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch). Database structures can be compared whether they are files containing table definitions or existing databases, local or remote.
The DBIWrapper is a Perl Module that provides for easier access to databases using DBI. It supports MySQL, PostgreSQL, and ODBC DBD modules. High level methods for reading, writing, commiting, and rolling back transactions to the database are provided. XML or DBI data structures can be used.
SchemaView Plus is a GUI for creating, retrieving, drawing, and printing database schema. It uses Perl, Tk, DBI, and XML packages. Schema can be retrieved using DBIx::SystemCatalog, and it uses XML for storing and retrieving data in text files. You can write any filters to modify these XML files to add new functionality based on your projects (e.g. dropping off some relationships).
dbMan is a complex SQL monitor for common database systems (PgSQL, Oracle, MySQL etc.). It's based on Perl and DBI interfaces. Features include a command history buffer, tab completion, editing Oracle objects, simultaneous connections, SQL help, importing and exporting of tables, Oracle explain plan, and more. dbMan is made as a simple kernel and many extension modules, and you can make your modules with a simple HOWTO.
The SQLB Perl module provide a simple API to interface SQL Load Balancer within Perl scripts. It allows you to interface your scripts with Oracle, MySQL, or PostgreSQL easily and efficiently. You can change your database type easily, the only changes required in your scripts being to queries with database-specific options.
Perl XSQL is a simple creator of XML data from DBI datasources. It allows you to easily extract data from a database, and manipulate it later using XML::Parser or in association with a XSL template file to a XSLT parser like Sablotron or GNOME libxml. This allows you to create dynamic Web applications by simply setting your SQL queries into a XML file and generating the HTML output using a XSL template. It acts exactly like the Oracle XSQL servlet.
WebTools is "system" of multiple modules and libraries. Along with template engine capabilities, it features session management, global variables support, cookies support, and various database interfaces. It also features a pure Perl mail client, categories management, form checking, and libraries such as a CGI-based downloading library, HTML parsers, and a library that makes PHP functions available to Perl for ease of development.
rackview is a tool for visualizing the layout of rack- mounted equipment. It can load data either from database tables or a flat file. It can be used to assist in planning and tracking hardware changes to racks in a data center, and to provide a host-oriented interface into other database tools. The core of rackview is implemented as a Perl module, which can be integrated into a variety of different tools. Sample command line and CGI scripts are included, which should be sufficient for basic needs.