coldbox-modules / qb

Fluent Query Builder for CFML
https://qb.ortusbooks.com/
MIT License
40 stars 35 forks source link

Add MariaDB to AutoDiscover #267

Closed faxi05 closed 9 months ago

faxi05 commented 1 year ago

Although MariaDB is a drop-in replacement for MySQL, it has its own JDBC driver which is also available as a Lucee extension. Using that driver will result in DATABASE_PRODUCTNAME = 'MariaDB', which in turn causes qb to fall back to its BaseGrammar that is not working with MariaDB.

Hence the suggestion to let the AutoDiscover feature recognize datasources using the MariaDB driver and treat them like MySQL databases.