Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can use any of the mentioned DB's. The main difference in use will be connectors. ODBC seems to be the most problematic. JDBC is common and available for most DB's. I find Native connectors the easiest to use and provide the quickest interfacing with Base. You can find Native connectors for MySQL, PostgreSQL and MariaDB (same as MySQL).

I personally use MySQL only because I started with it for a totally different reason. You can use the MySQL Workbench with it for a graphical interface and modeling. However I have installed and have available all the mentioned DB's currently on various systems including SQLite (not of personal liking). Have installed & used PostgreSql in previous job & had multi million record tables.

You can use any of the mentioned DB's. The main difference in use will be connectors. ODBC seems to be the most problematic. JDBC is common and available for most DB's. I find Native connectors the easiest to use and provide the quickest interfacing with Base. You can find Native connectors for MySQL, PostgreSQL and MariaDB (same as MySQL).

I personally use MySQL only because I started with it for a totally different reason. You can use the MySQL Workbench with it for a graphical interface and modeling. However I have installed and have available all the mentioned DB's currently on various systems including SQLite (not of personal liking). Have installed & used PostgreSql in previous job & had multi million record tables.

Edit: For more info on external DB's see Base Handbook Chapter 2 found here.

For the MySQL/MariaDB native connector - here.

I believe PostgreSQL is already installed in Base.

You can use any of the mentioned DB's. The main difference in use will be connectors. ODBC seems to be the most problematic. JDBC is common and available for most DB's. I find Native connectors the easiest to use and provide the quickest interfacing with Base. You can find Native connectors for MySQL, PostgreSQL and MariaDB (same as MySQL).

I personally use MySQL only because I started with it for a totally different reason. You can use the MySQL Workbench with it for a graphical interface and modeling. However I have installed and have available all the mentioned DB's currently on various systems including SQLite (not of personal liking). Have installed & used PostgreSql in previous job & had multi million record tables.

Edit: For more info on external DB's see Base Handbook Chapter 2 found here.

For the MySQL/MariaDB native connector - here.

I believe PostgreSQL native connector is already installed in Base.