LibreOffices' Base

[egsuh]

I could open my Firebird file with LibreOffice Base. Is LibreOffice Base designed to edit or maintain existing databases, like FlameRobin?

Or does it have its own database type, .odb type, like MS-Access (.accdb)?   

Or both?

I found that even though I opened my preexisting Firebird file, a new .odb file is created.

[Zvoni]

From here: https://en.wikipedia.org/wiki/LibreOffice_Base

Base is able to work with both embedded and external database files. Embedded databases are stored as a single file using C++ based Firebird and Java-based HSQLDB as its storage engine.
When connecting to external databases, Base acts as a graphical user interface front-end to facilitate interactions with various database systems including Access Database Engine (ACE/JET), ODBC/JDBC data sources, MySQL, MariaDB, and PostgreSQL.[7]

That said: I wouldn't touch that thing with a 10-feet long poker....

[VisualLab]

That said: I wouldn't touch that thing with a 10-feet long poker....

He's that bad?

[Zvoni]

That said: I wouldn't touch that thing with a 10-feet long poker....

He's that bad?

Let’s say i prefer the „specific“ clients to databases (DBbrowser for Sqlite, MySQL workbench et al)
That way i really have the full set of tools for each DBMS

[MarkMLl]

My experience is that "general purpose" clients fare very badly when asked to work with a non-trivial database. The first thing that happens is usually that they try to load a billion-row table into local storage...

Let’s say i prefer the „specific“ clients to databases (DBbrowser for Sqlite, MySQL workbench et al)
That way i really have the full set of tools for each DBMS

Having said which, it should not be beyond the wit of man to define the available SQL facilities using something like LSP, so that the client knew in advance what could be used to control the queries it needed to use and how it could recover metadata.

MarkMLl

[egsuh]

It's enough to know that I can manage Firebird DBs with LibreOffice's Base. And hope that Base's support for Firebird would be excellent as Firebird is the default embedded DB for Base.

I am using FlameRobin as main tool, but one thing it does not fully support is printing of texts --- stored procedures, etc. So I use DBeaver as an assist.

Not sure I can open stored procedures (and DDLs) using Base. But if possible, LibreOffice would be a better option than DBeaver because LibreOffice is used frequently and I have better access (within my cognitive system).