RE: [Help-glpk] MySQL Support for GLPK 4.23

[Meketon, Marc]

Are you planning to support ODBC?  If so, that would be a wonderful addition.

-----Original Message-----
From: address@hidden [mailto:address@hidden On Behalf Of address@hidden
Sent: Thursday, November 01, 2007 4:06 PM
To: address@hidden
Subject: [Help-glpk] MySQL Support for GLPK 4.23

Hello!

I have added MySQL database support to the GNU MathProg language in GLPK 4.23.

Sources are available at 
ftp://87.230.79.59/glpk/glpk-4.23-sql-20071101.tar.gz

Library mysqlclient and header mysql/mysql.h are needed.
For Debian and derivates like Ubuntu:
sudo apt-get libmysqlclient15-dev

In the data section the following commands can be used to fill a set with data 
from a data base query:

dbopen( 'MySQL', 'server', 'database', 'user', 'password');
dbquery(set, 'sql-query');
dbclose;

For an example see 
glpk-4.23-sql-20071101/examples/mysql.mod

Only the Linux makefiles are updated. Windows files remain to be updated.

--enable-mysql has been added to configure.

Next step to do is to enable writing the calculation results to the data base.

I would appreciate Your comments.

Best regards

Xypron

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer


_______________________________________________
Help-glpk mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/help-glpk
---------------------------------------------------------------------------- 
This e-mail and any attachments may be confidential or legally privileged.  If 
you received this message in error or are not the intended recipient, you 
should destroy the e-mail message and any attachments or copies, and you are 
prohibited from retaining, distributing, disclosing or using any information 
contained herein.  Please inform us of the erroneous delivery by return e-mail. 

Thank you for your cooperation.
----------------------------------------------------------------------------