Alternative Alternative to MATLAB Database Databases

Question

Requirement: An open source alternative for the MATLAB database database box.

Background: I have MATLAB provided in the workplace, but unfortunately it does not have a license for the Mathwork Database.

Work accomplished: Although I am new, I searched quite a bit on the Internet, and what I found working for me is the demo version of DBtool box DBTool (http://energy.51.net/dbtool/index.htm). However, the demo version of the DB toolkit works great only with small databases. But whenever I use it in large databases, I get a "time error".

Thank you for your help nihil

Answer 1

I found my answer to How to connect to Microsoft SQL Server 2008 (MSSQL) from Matlab?

However, not every approach works for me. Let me explain a little more:

The JDBC driver usually works best. But you need to know which JDBC driver to use with your project. For MS SQL, sqljdbc4.jar works fine. If you are connecting to MySQL or postgreSQL, make sure you specify it for the correct driver. (mysql-connector.jar for mysql and postgresql.jdbc4.jar or postgreSQL)

I also tried the COM method with success only through ODBC. Finding the right line is really a pain. You also need to install the correct ODBC driver associated with your project. Setting up an ODBC connection is actually easy. Once you have installed DSN, you simply use the connection string, for example

connectStr = 'DSN=newDSN'; invoke(conn,'Open',connectStr); 

Finally, if you decide to go with a database toolkit (maybe not in your case), don't expect too much using it. This toolbox is just a wrapper for the above methods. You can definitely complete your project without using it at all.

Answer 2

Some alternatives to what has already been suggested:

• ZozaniDB is a database toolkit that provides connections to Sqlite and Mysql databases (Other database connections may also be possible if you have a JDBC connector). ZozaniDB is more than a database connection; It provides on-the-fly schema generation and allows you to retrieve / insert data without using SQL. (Disclaimer: I'm a ZozaniDB developer).

• If you are looking for a way to connect to SQLITE, Mksqlite does the job.

• There is also a Mysql mex file that you must first compile: http://www.mathworks.com/matlabcentral/fileexchange/8663-mysql-database-connector

Answer 3

If you work with MySQL, you can try these materials from the central file exchange Exchange Matlab. None of them require a Database Toolbox. If you are not using MySQL, perhaps you can change them to suit your needs.

queryMySQL

MySQL database access