Category/Database

sql (47)

Database load balancing class for PHP applications who need to deal with various MySQL servers. The class will properly detect write queries and will try the next available server(s) until running out of connections. Multi server connection handling in progress in order to allow running transactions in many servers at the same time.

Autotabla is a CGI interface to a collection of SQL tables. Once an XML description of the database schema (table names, fields, etc.) is provided, all table maintenance can be done from a Web page. The program reads the database schema from a configuration file, and you can manage the tables included in the schema: you can add, delete or modify rows and you can do simple but effective queries. It is meant to help developers who are making SQL based applications, freeing them from writing basic scripts for accessing the tables the application will use, and letting them test those applications with live data that can be inserted, modified or deleted from outside it. It reads the database schema from an XML configuration file (which must be provided, and presents an index page of tables and operations to do with them. From then on, the user can do all typical table maintenance.

'cbMySQL' is a PHP class for creating, modifying MySQL databases and tables. For backup issues, you can export CSV data directly with only one class method. The MySQL object is easier to handle than PHP's built in functions, and you need not install anything like PEAR.

'CLSQL' is an SQL database interface for Common Lisp. It provides object-oriented and functional access methods to the underlying database, which can be one of MySQL, ODBC, PostgreSQL, or SQLite. It uses the Unified Foreign Function Interface (UFFI) and thus supports the CMU Common Lisp, Steel Bank Common Lisp, Allegro Common Lisp, OpenMCL, and Lispworks implementations.

'csv2mysql' is a Web-based tool that converts CSV files to MySQL tables. It asks for the location of the CSV file, type of the CSV file, and access info (server address, table name, username, and password) for the MySQL database, and lets users map the fields of a CSV file to the fields of a MySQL table.

DBI::Frame is an extension of the standard DBI perl module, designed around MySQL, used to create and maintain frameworks for databases. It has query logging and a standardized interface for SQL statements like 'update' and 'insert' that doesn't require understanding SQL. Ideally, the user or developer shouldn't have to know SQL to be able to administer a database; this does require a special setup which isn't necessarily easy to create.

DMTools is an ongoing project to develop a data mining toolbox written in Python. Two core features of the toolbox are caching of database queries and parallelism within a collection of independent queries. Our toolbox provides a number of routines for basic data mining tasks on top of which the user can add more functions - mainly domain and data collection dependent - for complex and time consuming data mining tasks.

DataStatix is a free software for GNU/Linux and Windows useful to manage data of every kind (although it has been written to manage biomedical data), to create descriptive statistics and graphs and to export items easily to R environment or to other statistic softwares. In order to handle properly big amount of data and many concurrent users, DataStatix works with MySql database and it has been developed and tested with MySql community edition 5.5.
Some features of the software are:
users management (create, delete, modify password) within the software;
different users levels of data access (administrator, default, read only);
user defined templates (models) of data, to create new databases easily;
importation and esportation of data in CSV format (used also by Calc and Excel);
updating of existing data from a CSV file created with DataStatix;
descriptive statistics from every data (some more kind of statistics to come);
graphs from every data.

Druid lets users create databases graphically. Users can add/modify/delete database objects (fields, tables, etc.) using a simple GUI and can document each table and field with HTML information. Druid then generates an SQL script with all table definitions that can be piped to the DBMS; a data dictionary file containing all the tables and field in the database, and Java classes that contain both the tables' constants and users' code. The program works with Java, C, and C++. There is a plug-in architecture, so users can write their own modules. The latest features let you examine the entire jdbc DB structure, rebuild the jdbc DB on the fly using the druid's current database, import the jdbc DB structure into druid for reverse engineering, and add/modify/delete tables' records using a simple grid control.

The copyright and license notices on this page only apply to the
text on this page. Any software or copyright-licenses or other
similar notices described in this text has its own copyright notice
and license, which can usually be found in the distribution or license
text itself.