Resolve inconsistencies of connection uri / objects in read_database, read_database_uri and write_database

[mesner]

Resolve inconsistencies of connection uri / objects in read_database, read_database_uri and write_database

[alexander-beedie]

Thanks for a great library.

Thanks ;)

In my opinion, this overlaps but is not a duplicate of #7852

My strong suspicion is that, unless connectorx starts showing signs of life again in the near future, we are going to end up eventually deprecating and retiring read_database_uri, as adbc can equally-well provide connection objects; therefore, without connectorx there is no need for a URI variant of that function. (This is probably a long way off though).

I have long-standing (and long-delayed 😅) plans to address the various issues with write-database, and it will indeed take connection objects, as read_database does.

While I agree this is not exactly the same issue, it's close enough that I'd rather close this in favour of the existing one. A solution there will essentially address the issues here. Feel free to add a comment to that issue though, to make sure 👍