Search code examples
databasenode.jshsqldblibreoffice

Node.js connection library for LibreOffice Base database?

I'd like to use LibreOffice's database application (Base) for a small, single user Node.js app I'm writing. I believe Base uses an HSQLDB backend. What Node.js libraries are available to me to execute SQL statements against an .odb database file?

Solution

  • No such thing exists that connects and executes statements against an .odb database file, other than Base itself.

    If you setup LibreOffice to use an external HSQLDB Server, which is pretty simple, then other libraries can connect to this Server as well.

    But as far as I know, there is currently no connectivity module for node.js to connect via JDBC, which is supported by HSQLDB.

    You may have to use Base to connect to a MySQL server and connect to this server from node.js