Hi Markus, Hi Martin,
as both JDBC and ODBC are SQL based or at least tailored for the relational database model (for all I know) I think it would be tedious to implement something that complies with those standards. And in the end, probably not very useful per-se, as we have XQuery for querying XML and while I like SQL for relational data I could not imagine me using it to query complex XML structures.
For the sake of completeness: there is a standard, XQJ, that is neither widely used nor under active maintenance http://xqj.net/ and only Supports XQuery 1.0. I don’t think you would want to use that.
I think a more modern and more document-resource-oriented approach to a standard API might be the https://de.wikipedia.org/wiki/Open_Data_Protocol and I once or twice thought about implanting it with RestXQ but I guess this would be full-time job 😊
Maybe I am missing the point, so it would be interesting to know more about your motivation 😊
Best Michael
Von: BaseX-Talk basex-talk-bounces@mailman.uni-konstanz.de im Auftrag von Markus Elfring Markus.Elfring@web.de Datum: Freitag, 20. Mai 2022 um 12:28 An: Martin Honnen martin.honnen@gmx.de, basex-talk@mailman.uni-konstanz.de basex-talk@mailman.uni-konstanz.de Betreff: Re: [basex-talk] ODBC support for BaseX?
Is any support available for data management by interfaces like the following?
- Open Database Connectivity
- Java Database Connectivity
Are you just looking for https://docs.basex.org/wiki/SQL_Module?
No. (Not for related use cases at the moment.)
This module is useful for accessing relational databases from XQuery using SQL.
I became curious also for data exchange in the other direction according to such a programming interface. Can any BaseX databases be represented as ODBC (or JDBC) data sources?
Regards, Markus