Hi,
After completing my work on the R-client, I started working on a Prolog-client. Long ago I wrote an application in SWI-Prolog which operated on data from a MySQL-database. (In the meantime I changed from MySQL to MariaDb). My goal is to write a new version of that application but now based on data which is stored in Basex.
In the basexgui, I created an empty database "MariaBases"
The following code can be used to select data in MariaDb: sql:init("org.mariadb.jdbc.Driver"), let $con := sql:connect('jdbc:mariadb://localhost:3306/<DB-name>', '<user>', '<password>') return sql:execute($con, "select * from Mdw_Wens")
returns: <sql:row xmlns:sql="http://basex.org/modules/sql%22%3E <sql:column name="ID">1</sql:column> <sql:column name="Medewerker_ID">5</sql:column> <sql:column name="Wens_ID">1</sql:column> </sql:row>
Is it possible to change the query-statement in such a way that the results are added to MariaBases/<DB-schema>/<table-name>?