Documentation

Ce document en français.

version 484

Introduction:

juda is an improved version of Trino.
This is one of the improvements I have already been able to make to certain software programs.

juda is the merger of the following PRs:

• New HsqlDB connector
• New Firebird connector
• New Sqlite connector
• Improvement of ResultSet metadata
• Add support for case sensitive identifiers

Its source code is consolidated in the PR juda (Java Unified Database Access).

Thanks to these modifications, the juda server is a Trino server that supports:

• Case-sensitive identifiers.
• ResultSets providing the following metadata:
  • Catalog name.
  • Schema name.
  • Table name.
  • Indication of whether the column is auto-incrementing.
  • Indication of whether the column is read-only.
• 3 additional connectors:
  • HyperSQL.
  • Firebird.
  • SQLite.

Freed from these limitations and combined with LibreOffice Base and jdbcDriverOOo, it allows queries to be executed on tables from different databases.
It is even possible to edit these tables within the data grids displayed in Base.

Being free software I encourage you:

• To duplicate its source code.
• To make changes, corrections, improvements.
• To open issue if needed.
• To participate in the costs of CASA certification.

In short, to participate in the development of this extension.
Because it is together that we can make Free Software smarter.

---

Requirement:

The juda server is written in Java.
Its use requires the installation of a Java JDK version 25 or later.
I recommend Adoptium as your Java installation source.

The Trino server (and therefore juda) can only run on Linux or Darwin.

If you are using Windows, it is still possible to install Linux on Windows with WSL.
And provided you install the Java JDK in your Linux environment, it will work, even though performance will not be optimal.

---

Installation:

• Download the file trino-server-484-SNAPSHOT

Then, extract this file into a directory of your choice.
Finally, copy the contents of the trino-server-484-SNAPSHOT folder from the repository to the corresponding folder in the chosen directory.

---

Use:

The catalogs supported by the server are defined by the .properties files located in the folder: trino-server-484-SNAPSHOT/etc/catalog.
Example .properties files are provided in the repository's root folder.

These files are configured with the default settings specific to each database.
However, if you wish to use the SQLite connector, you must modify the connection-url parameter to point to your file or at least an existing folder.
For the other connectors, the dockerDB repository allows you to set up a database very quickly, with no dependencies other than Docker.

To control the server, you need to navigate to the trino-server-484-SNAPSHOT/bin directory and enter the following commands:

• Start the server: ./launcher run
• Stop the server: ./launcher stop

If the juda server is running on the same machine:

• To connect to the server you must use the following URL:
  • For a connection outside of LibreOffice: jdbc:trino://localhost:8080
  • For a connection using LibreOffice Base: //localhost:8080, having selected Juda pure Java as the data source type.
• Server activity can be monitored using a browser at the address: localhost:8080.

Otherwise, replace localhost with the IP address of the juda server.

Attention: Although a username must be provided when connecting (it can be any value), no authentication is configured on the juda server.
It is your responsibility to configure authentication on the juda server to ensure the security of the server's connectors.

---

Historical:

What was done for version 484:

The juda 484 project required over six months of work and the addition of nearly 30,000 lines of code to Trino in order to make it usable in LibreOffice Base.
Most of this work is visible through the various PRs added to the Trino repository.