Raspberry and database

Targets Raspberry Pi
1

HI,

What databases can be used on the RPI.
I use a lot of MSAccess database, they can be used on the RPI?

2

I doubt msaccess databases can be used on unix systems …

3

There’s quite a good list here.

4

Xojo can use SQLite, MySQL and PostgreSQL on the Pi. You can also use ODBC to connect to other databases, but you’ll need to find and install the appropriate ODBC driver. I’m not sure if there is an Access ODBC driver for Pi. It might be easier to just covert the Access DB files over to SQLite for better cross-platform compatibility.

5

You can use MBS SQL Plugin.

Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL, SQL Anywhere, ODBC, and SQLite.

6

[quote=225862:@Christian Schmitz]You can use MBS SQL Plugin.

Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL, SQL Anywhere, ODBC, and SQLite.[/quote]

Thanks for the reply
Plug-ins are not known to me. Can anyone write more about how to make a connection on the data server (MSSQL or MySQL) on the RPI, or any example.
As I understand it, the MySQL server can be accessed via the RPI without plug-in?

7

all database server access is through plugin.

Either the plugin from Xojo Inc. or the one from MBS.

8

Thank you all

The application works with MySQL, now I tested with MSSQL.