[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [Help-glpk] MySQL Support for GLPK 4.23
From: |
Meketon, Marc |
Subject: |
RE: [Help-glpk] MySQL Support for GLPK 4.23 |
Date: |
Fri, 2 Nov 2007 17:04:35 +0300 |
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.
----------------------------------------------------------------------------