Support DuckDB

[aszenz]

Feature Request

DuckDB is a popular in memory db for analytical queries.

Right now it doesn't have a native php extension but it can be connected via pdo-odbc, unfortunately odbc as a driver is not supported in dbal.

Is their any interest in supporting it, if so what would be the best solution

Summary

Ideally connect to duck db via dbal

[derrabus]

ODBC is not really fun to work with. I have a semi-finished ODBC driver at https://github.com/derrabus/dbal/tree/feature/odbc if you want to look into it.

Given that this database has C bindings, someone should build a PHP extension rather than taking the detour via ODBC.

I personally have learnt about the existence of this database today, so my interest in supporting it is rather limited. That being said, if you want to develop your own driver for this database and publish it as your own package, please feel free to do so. Once such a package exists, we can reevaluate if the driver should be added to the DBAL codebase.