LibreOffices' Base lazarus / 63-Database ---------------------------------------------------------------------- egsuh · 2024-09-06 06:35 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 · 2024-09-06 09:47 From here: https://en.wikipedia.org/wiki/LibreOffice_Base QuoteBase 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 · 2024-09-06 16:59 Quote from: Zvoni on September 06, 2024, 11:47:17 amThat said: I wouldn't touch that thing with a 10-feet long poker.... He's that bad? ---------------------------------------------------------------------- Zvoni · 2024-09-06 17:17 Quote from: VisualLab on September 06, 2024, 06:59:03 pmQuote from: Zvoni on September 06, 2024, 11:47:17 amThat 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 · 2024-09-06 19:29 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... Quote from: Zvoni on September 06, 2024, 07:17:00 pmLet’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 · 2024-09-07 01:10 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). ---------------------------------------------------------------------- tdb · 2024-10-30 07:54 Quote from: egsuh on September 07, 2024, 03:10:33 amI 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). I have been using Firebird 2.5 for a while now 5 years a least and seems to run well. My take is MYSQL is great but licensing is confusing, MS SQL has issues in my option and is slow and costly. Also way to cumbersome for small projects. Where as Firebird is basically free and easy to setup as server or standalone etc., runs on windows and Linux etc. I have been using FlameRobin for direct access to the .fdb file an seems to work well, although recently started using DBeaver and seems to offer much easier access etc. Anyway just my 2 cents. ---------------------------------------------------------------------- marcov · 2024-10-30 08:16 Access started as local database, then allowed to put the database on a file share with locking, and later when it got ADO capabilities a general database frontend. I assume Base is the same but then with JDBC rather than ADO as independent db API.  I haven't tried Base since 2010-12, at which time my boss tried to make his own crm database. After helping him and seeing him struggle for three weeks, I just grabbed zeos and made a complete app (in Delphi) interfacing to postgress in under a week. I still maintain that app, though since say 2018, much of these non core business app have been moved to Lazarus, so now it works under Lazarus.