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:

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

Combined with LibreOffice Base and jdbcDriverOOo, it allows you to execute queries 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 JRE or JDK version 25 or later.
I recommend Adoptium as your Java installation source.

The juda server is an application containerized with Docker.
It is therefore necessary for Docker to be already installed.

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:

If necessary, in the docker-compose.yml configuration file, the Docker image name for the coordinator (trino:484-SNAPSHOT-amd64) must be adapted to your architecture.

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.

Historical:

What has been 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 to make it easier to use.
Most of this work is visible through the various PRs added to the Trino repository.