More connections available (jdbc, odbc, oledb, sql alchemy, adbc...)

RootDBApp / rootdb

Main repository containing all releases.

https://www.rootdb.fr

GNU Affero General Public License v3.0

12 stars 0 forks source link

More connections available (jdbc, odbc, oledb, sql alchemy, adbc...) #1

Open simonaubertbd opened 4 months ago

simonaubertbd commented 4 months ago

Hello,

I'm surprised connections to data are limited to three databases. I think you would impact waaaaay more users if you leverage standards connectors (jdbc, odbc, oledb, sql alchemy, adbc...) and only after make some dedicated connectors to major databases.

Best regards,

Simon

gyan000 commented 4 months ago

HI @simonaubertbd,

Yes, database support is limited for now, and indeed, more connectors could be great. Focus was on MySQL/MariaDB because it was the main objective for a first release. We’ll see how to implement more connectors safely in the future.

Thanks for your suggestions, Regards.

simonaubertbd commented 1 month ago

@gyan000 Thanks. I was thinking, since you're going full open-source, and in case you can't do generic connectors (which would be the best solution) maybe you should prioritize MonetDB and Clickhouse, pretty fast databases and easy to use.

Best regards,

Simon