I am trying to document my database using DBschema. It has a JDBC driver for HSQL. Want to connect but no tables show in DBschema.
Linux Mint 22.1 Xia
Libreoffice 24.2.7.2
Base connected to HSQLDB database
Sorry, I do not understand all the abrevations.
DBschema can not work with a database that is embedded in a Base document.
Wasn’t there an extension that provided something like this?
BaseDocumenter?
Thanks.
I installed the BaseDocumenter-Extension. Works but the output is like a long table with rows and columns. No graphical visualization.
DBschema is visual pleasing but at first a bit confusing. Obviously no link to a .odb base for reverse engineering. I set up a new database-connection HSQL which works offline. Drawback is that the Linux non-pro-edition has no means of saving, at least I have not found one. The “SAVE” icon is greyed out.
I always recommend to extract embedded databases once the development of tables and indexes is finished. Stand-alone databases are more stable, more safe, more secure, faster, upgradable and connectable to other frontends.