Trino Firebird connector

[Pierre Vacher]

Hi all,

I am interested in Trino and hope to soon be able to offer in LibreOffice Base the ability to perform SQL queries on tables from different databases.

I've already written a connector for HsqlDB that allows writing to tables (though some limitations remain).

I would have liked to do the same with Firebird, but it seems from my tests that the lack of schema support poses a problem.

Thank you for any suggestions I might have.

[Mark Rotteveel]

On 24/11/2025 10:28, Pierre Vacher wrote:
> I am interested in Trino <https://github.com/trinodb/trino> and hope to

> soon be able to offer in LibreOffice Base the ability to perform SQL
> queries on tables from different databases.
>

> I've already written a connector for HsqlDB <https://github.com/trinodb/
> trino/pull/27324> that allows writing to tables (though some limitations

> remain).
>
> I would have liked to do the same with Firebird, but it seems from my
> tests that the lack of schema support poses a problem.

Schema support is coming in Firebird 6, and Jaybird 7.0.0-SNAPSHOT
(master) already has support implemented (obviously, only when talking
to Firebird 6).

Knowing nothing about Trino, why does or why do you think lack of schema
support poses a problem?

The JDBC specification is written in such a way that schema support is
optional, so well-written JDBC tools should - at least in theory - be
able to handle lack of schemas.

Mark
--
Mark Rotteveel

[Pierre Vacher]

Yes, I've made some progress and it seems Trino handles this situation.

Since Trino requires tables to be named using catalog and  schema, the catalog name is the same as the name of the .properties file defining the connector (ie: a connection to the firebird database), and the schema is a fixed name (i.e: public).

I won't lie to you, I still have some work to do. But I'll get back to you to keep you updated.