MonetDB support

[simonaubertbd]

Feature description

Hello,

MonetDB is undoubtedly my favorite database for dataviz. Why ? -it's free -it's open-source -it's fast, incredibly faster than Postgresql -it's easy to install on linux, mac and windows. -it cares about SQL norm -you can use odbc, jdbc, sql alchemy 2, etc... so connected QGIS to MonetDB would be easy. -the team behind it (MonetDB Solutions ) really listens to the users. and the cherry on top is that MonetDB has support for the OGC "Simple Features for SQL" specification

https://www.monetdb.org/documentation-Aug2024/dev-guide/sql-extensions/geospatial/

I think this would be a perfect match of two awesome projets, isn't it?

Best regards,

Simon

Additional context

No response

[vpicavet]

" -it's fast, incredibly faster than Postgresql" => "-it's fast, incredibly faster than Postgresql for some dedicated use cases"

Writing a MonetDB provider should be doable indeed, let's find some funding for that, feel free to drop a message here if you have a corresponding budget !

We could either implement a core provider, or add a provider as a Python plugin ( like for DuckDB ) and later on port it to core for example.

[simonaubertbd]

@vpicavet My bad, I really should have reread myself before publishing because it lacks this precision : There is already a plugin, what I would like is to add it to the core product. https://plugins.qgis.org/plugins/MonetDB-QGIS/#plugin-about Best regards,

Simon

[vpicavet]

Ok ! Funding welcome :-)

[simonaubertbd]

@vpicavet Very naive question but what would be the amount of such funding?

[vpicavet]

It would need some further evaluation, but adding a provider to core is not a trivial task. You can get in touch with Oslandia or other core contributors directly to get estimations, but do not expect anything below dozens of thousands of euros.