Using Julia, what's the accepted way to deal with data stored in external databases?

Asked Jun 09 '15 at 21:29

Active Jun 09 '15 at 21:29

Viewed 237 times

Julia has an internal representation of storing data a la dataframes, but for some applications, one may have data in say a redis sql, or mongodb instance. It seems the drivers for these databases are presently lacking for julia, and I do not have the expertise or time to develop it; what are my options?

Would it make sense to write a tool in c to converse with Mongo, and utilise the julia api, or is there a somewhat more sensible approach to getting data in and out?

asked Jun 09 '15 at 21:29

joshua.thomas.bird

1

You can use ODBC see http://stackoverflow.com/questions/19434117/connect-to-mysql-database-and-fetch-data-in-julia – ThatOneDude Jun 09 '15 at 21:39
Promising for oracle database connection – joshua.thomas.bird Jun 09 '15 at 21:48
1

Theres a ODBC drivers for mysql and mongodb. Redis seems to have JDBC drivers but I don't know of a JDBC julia implementation. – ThatOneDude Jun 09 '15 at 21:51
okay, thanks; will continue experimenting – joshua.thomas.bird Jun 09 '15 at 22:13
as said above ODBC works. I have only tried it with sqlite3 and SQL Server but everything worked as expected. – Chase CB Jun 11 '15 at 05:14

Using Julia, what's the accepted way to deal with data stored in external databases?

0 Answers0