MySQL Connector: mYm

http://sourceforge.net/projects/mym

First submitted by Yannick Maret on 5 Oct 2007

Updated by Eran Mukamel on 29 Jan 2012

mYm is a Matlab interface to MySQL server. It is based on the original 'MySQL and Matlab' by Robe...

3.0

3.0 | 1 rating

Rate this link

1116 clicks (last 30 days)

Tags for This LinkHelp

Everyone’s Tags

Descriptions and Ratings (3)

Date	Contributor	Description	Rating
29 Jan 2012	Eran Mukamel	This tool generally works, but I have encountered a number of bugs. For example, when I try to send multiple SELECT statements to the same server I get an "out of sync" error after the first statement. This requires re-opening the mysql connection, which is very slow.	3
15 Mar 2010	CRP	I have been able to compile this on mac 10.6.2 with the following command line: /Applications/MATLAB_R2009b.app/bin/mex -v -maci64 -I../mysql-connector-c-6.0.2-osx10.5-x86-64bit/include/ -I/Applications/MATLAB_R2009b.app/extern/include/ -L/Applications/MATLAB_R2009b.app/bin/maci64/ -L../mysql-connector-c-6.0.2-osx10.5-x86-64bit/lib/ -lz -lmysqlclient_r -lSystemStubs -lpthread mym.cpp Unfortuntely, upon running mym from matlab I get: >> mym ??? Invalid MEX-file '/Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64': dlopen(/Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64, 1): Library not loaded: libmysql.16.dylib Referenced from: /Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64 Reason: image not found. I think this is due to the whole @loader mechanism in OS X. I think this could be solved by linking the libraries statically. How do I do that with mex? Thanks CRP
19 Jun 2009	Yannick Maret	mYm is a Matlab interface to MySQL server. It is based on the original 'MySQL and Matlab' by Robert Almgren and adds the support for Binary Large Object (BLOB). That is, it can insert matlab objects (e.g. array, structure, cell) into BLOB fields, as well retrieve from them. To save space, the matlab objects is first compressed (using zlib) before storing it into a BLOB field. Like Almgren's original, mYm supports multiple connections to MySQL server.

29 Jan 2012

Eran Mukamel

This tool generally works, but I have encountered a number of bugs. For example, when I try to send multiple SELECT statements to the same server I get an "out of sync" error after the first statement. This requires re-opening the mysql connection, which is very slow.

15 Mar 2010

CRP

I have been able to compile this on mac 10.6.2 with the following command line:

/Applications/MATLAB_R2009b.app/bin/mex -v -maci64 -I../mysql-connector-c-6.0.2-osx10.5-x86-64bit/include/ -I/Applications/MATLAB_R2009b.app/extern/include/ -L/Applications/MATLAB_R2009b.app/bin/maci64/ -L../mysql-connector-c-6.0.2-osx10.5-x86-64bit/lib/ -lz -lmysqlclient_r -lSystemStubs -lpthread mym.cpp

Unfortuntely, upon running mym from matlab I get:

>> mym
??? Invalid MEX-file '/Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64': dlopen(/Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64, 1):
Library not loaded: libmysql.16.dylib
Referenced from: /Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64
Reason: image not found.

I think this is due to the whole @loader mechanism in OS X. I think this could be solved by linking the libraries statically. How do I do that with mex?

Thanks
CRP

19 Jun 2009

Yannick Maret

mYm is a Matlab interface to MySQL server. It is based on the original 'MySQL and Matlab' by Robert Almgren and adds the support for Binary Large Object (BLOB). That is, it can insert matlab objects (e.g. array, structure, cell) into BLOB fields, as well retrieve from them. To save space, the matlab objects is first compressed (using zlib) before storing it into a BLOB field. Like Almgren's original, mYm supports multiple connections to MySQL server.

Please login to add a description or rating.

Tag Activity

Tag	Applied By	Date/Time
database	Carlos	13 Sep 2011 at 11:52am
database	Jianming	19 Apr 2010 at 11:38am
database	Martin	15 Sep 2009 at 5:51am
database	Yannick Maret	19 Jun 2009 at 10:22am