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