Contributor - Database connection

Description

This idea is to develop a database interface. This interface would provide access to database thanks to an database independent interface (like Perl/Ruby DBI or MDB2 in PHP/PEAR).

Ideas

The idea is to:

• Write a SEP For more information doing a list of the function with their profiles.

• create a database independent interface callable from the Scilab language.
• write connector against some databases (MYSQL, Postgresql, Sqlite, ...)
• write tests

Note that the different SQL syntaxes inherent to the RDBM won't be handle by this work. It is left to the user.

Links

A first beginning of a toolbox exists under scilab-4.1.2 and scilab-5. But these toolboxes really need to be completed and there is no need to start from them for the Googler Summer of Code 2009.

You will find here this MySQL toolbox for scilab-4.1.2.

The version of the toolbox for scilab-5 can be found here.

How it is done elsewhere:

• http://pear.php.net/package/MDB2_Driver_mssql/docs/latest/elementindex_MDB2.html

• http://www.python.org/dev/peps/pep-0249/

• http://rubyforge.org/projects/ruby-dbi/

• http://octave.sourceforge.net/database/index.html