Free Software Foundation!

Join now

Category/Works-with/sql

From Free Software Directory
 
Jump to: navigation,

Broaden your selection: Category/Works-with

Category/Works-with Search icon.png

sql (49)



Autotable
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
'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.

Common Lisp SQL
'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
'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
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.

DM Tools
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
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.

Diaspora
Diaspora is a decentralized social network (composed by many servers which interact with each other, the servers are called pods).

Druid
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.

FlatFileSQLDatabase
FlatFileSqlDatabase is an implementation in PHP of a small database using SQL to access and using text files to store the data.

… further results



Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.

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.


Personal tools
Namespaces

Variants
Actions
Navigation
Contribute