MariaDB connector (remote)
1
vote
0
answers
258
views
I'm new to databases and have some very basic how-to/where-to questions:
1. I have successfully setup a MariaDB + phpmyadmin on my raspberrypi zero (running the latest diet-pi), including a database with a couple of columns, which works like a charm.
2. Now, under Windows, I would like to import the data into Matlab, using
adodb_connect()
, created by the community (link ), to analyze some data that I stored in the database. From the docs of that file:
> Package adodb_toolbox allows communication with different types of databases through Microsoft's ADO (ActiveX Data Objects) OLEDB component. The package was designed to work on Microsoft SQL Server, Oracle, Microsoft Access, MySQL and other databases.
However I can't find good and straightforward guide on how to install ODBC on my raspberry pi (as far as I understand MariaDB should, for all intents and purposes, classify as a 'MYSQL database'), this usually means I'm not following the most common implementations anymore, which is why I'm asking for some general questions (after reading/googling):
- Would you (e.g. a poweruser or expert) have advice on a more straight forward option to import the data to Matlab (or even Java, or even Windows) from my SQL database rather than this OLEDB interface? (the goal here is to make the database as accessible as possible)
- Is there a good guide or resource I should follow to install this (database connector or whatever would be more advisable) on my raspberry pi?
thanks!
Asked by user2305193
(143 rep)
Sep 30, 2020, 06:12 PM