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.

[Pierre Vacher]

Well, I wasn't able to complete it (Trino doesn't really support databases without a schema), so I'm eagerly awaiting Firebird version 6 so I can resume development of the Trino connector for Firebird.

I did manage to create a connector for SQLite because it doesn't support schemas but does support the use of a main schema in SQL commands. This allowed me to bypass Trino's limitations.

I'll keep you updated here.

Regards,

Pierre

[Pierre Vacher]

It’s finally done: Firebird now has a Trino connector in my Juda fork.

Although schema management is implemented, I haven't been able to test it due to a lack of JDBC driver support.

I am eagerly awaiting the arrival of Jaybird 7 for that.

A tool once reserved for the tech giants is now available to the average person.

[Mark Rotteveel]

On 04-09-2026 14:41, Pierre Vacher wrote:
> Although schema management is implemented, I haven't been able to test
> it due to a lack of JDBC driver support.
> I am eagerly awaiting the arrival of Jaybird 7 for that.

For testing purposes, you can use the 7.0.0-SNAPSHOT from the Sonatype
snapshot repository
(https://central.sonatype.com/repository/maven-snapshots/). Although I
irregularly publish new snapshots, the currently published version
should be complete with regard to schema support (bar bugs, of course).

Mark
--
Mark Rotteveel

[Pierre Vacher]

Thanks Mark for the info.

I’ll run some more tests for the next version of juda, there’s no rush as long as Firebird 6 isn’t available yet.

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
You received this message because you are subscribed to the Google Groups "firebird-java" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-jav...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/firebird-java/5dae0109-3812-4cb0-9825-9828dc3fffa2%40lawinegevaar.nl.