Firebird Database Management Tools?

Hello, i guess someone else using the Firebird Database and using maybe a differnt Management Tools for it.

one if it is IBExpert, an other is DBeaver.
is there a similar good tool like IBExpert to edit database users and trigger, stored procedures and sequences etc.?

what Firebird is:

not available for macos arm ??? showstopper for me …

I see macOS ARM in the list:

1 Like

It looks like the web download page was created January 11 and the macos arm was build January 16.

1 Like

Due to this

@MarkusR,
Firebird is the main database I had been using in all my XOJO programs in the last years
DBeaver on Mac and SQLMaestro on Windows are the tools I use to manage the databases.
I am running my programs on Windows (all versions 7, 10, 11 and Windows Server 2012, 2016 and 2109) and on MacOS Intel (i5 and i7) and ARM (M1, M2 and M3), except in Sonoma in all Mac OSx.
I am using Firebird 2.5 and 3.0 and I am planning to migrate all to Firebird 4.0 in the next months.
Whatever I could help please let me know.

1 Like

@Mariano_Poli
thanks SQLMaestro sounds promising alternative in compare with IBExpert.

As Xojo does not support it natively… yet, what bridge (wrapped DLL, proxy service, ODBC, plugin…) are you using?

i can say that ODBC works with Xojo and Windows

Ashampoo_Snap_Freitag, 29. März 2024_13h1m47s_001_Firebird ODBC Setup

https://firebirdsql.org/rlsnotesh/config-db-alias.html#config-db-alias-path

But I detest ODBC. I like an approach more like SQLite, run the app, the app takes care of everything… directly, at runtime, programmatically. Watching the ODBC driver, looks like wrapping FBClient.DLL could be the way of doing it.

In case of someone wanting to wrap the DLL, and create proper Xojo classes, here is the starter data to work on:

Latest API Guide available: https://www.ibphoenix.com/downloads/60ApiGuide.zip

Latest interface header: firebird/src/include/ibase.h at 69d0a38aea942960a919e9486a568a3d6549421d · FirebirdSQL/firebird · GitHub

MBS Xojo SQL Plugin can do Firebird directly using the DLL/dylib.

See
Connecting to a Firebird database using Xojo, Real Studio or FileMaker

1 Like

I am using MBS Xojo SQL Plugin for many years.
Great Plugin.
Christian always available to assist if I have any trouble.
I recommend it if you want to use this great database

1 Like

I don’t intend to buy 500 functions to use one. Firebird became outstanding in V5. And I would say that with 2026 V6 it should not be ignored anymore. It is like a small Postgres (feature complete server) that can be used as a kind of SQLite too (embedded, no server install). I guess it is just a question of time to Xojo support it as others do.

If I had spare time I would play with this: Firebird Database Management Tools? - #11

For others, needing it right now, MBS is the way to go.

3 Likes

I don’t think that plugin has 500 functions.

It is confusing that MBS force (at least looks like that) to download the complete set to use the SQL but we need to pay a different license (didn’t spend much time on the plugin-sql page). Maybe there is a link to just download MBS SQL Plugin somewhere.

Yes, the SQL Plugin offers more than just connect to Firebird (it looks like 12 options directly without using ODBC).

Since Apple asks us to notarize the dmg files, I stopped making individual ones and just made one.

So you can download a dmg every few months and you have all plugins together.

1 Like