What is more, the connector is LGPL licensed, which means that it can be used in the core project too. It has a C API which can be used to connect to MySQL and MariaDB databases too. MariaDB is a fork of MySQL which has the same database structure and indexes as MySQL. So what is the solution then?īecause of the above mentioned problem we, at Collabora decided to use the connector of MariaDB instead. Because of that it could not be put into the core project. Why was it only an extension at the first place? The native connection was implemented by using the C++ connector of MySQL, which is licensed under GPL. However, the last option was only available as an extension, and it is the part of the core project only since November 2018. Currently there are three ways supported to connect to a MySQL database: with ODBC, JDBC and using a native connector. Using the native connector instead of a standard like JDBC sometimes has a positive impact on performance.Ĭonsidering that MySQL is one of the most used database management systems worldwide it is clear that the support of connecting to a MySQL database is an unavoidable part of Base. One interesting feature is that Base lets you connect to an external database not only with ODBC and JDBC but with native connectors too. Base – the database editing program of LibreOffice – offers several features when it comes to external database connection.
0 Comments
Leave a Reply. |