Understanding creation of split databases

[LeroyTennison]

I have found the recommendations to use split HSQLDB databases and references to Split_HSQLDB_Wizard_v3c.odb and mydb_wizard.obd as well as dbscript.sql (but the link to it isn't connecting for some reason). While I appreciate the efforts to make things easy for users, I'm of the mindset that I want to understand what's being done and why. Is there a step-by-step set of instructions describing what I can do to manually create a split HSQLDB database and configure Base to use it? Thanks for your help.

[Villeroy]

The database software is HSQLDB and the office suite is OpenOffice. Virtually all databases are split into a backend (storage, structure, query functionality) and one of more frontends to do something meaningfull with the stored data (office suite, html, scripts, internet shop, book keeping software, ...). Wrapping everything into one file is typical for MS Access which has a very bad reputation among database professionals. Doing the same thing with OpenOffice 2.0 was the ugliest mistake ever made. It looks somewhat like MS Access but it isn't. Building useful relational databases is professional work and Base does not help by any means. First of all, this office suite is about ODF and nothing but ODF. Database connectivity is mandatory for any professional office suite so you can feed serial letters and spreadsheet with data from varoius database backends that exist in any business environment. A database development suite to create database applications from scratch is beyound the scope of an office suite.

So we have this excellent HSQL engine bundled with OpenOffice and we can build databases from scratch with a little help from incomplete, clumsy and buggy wizards. The resulting self-contained database in a single odb file is unsafe, insecure, not feature complete, slow and not accessible from 3rd party software. Once you get your database out of the odb container, you can use the latest version of HSQL with lots of improvements. You can use your database online and offline with all kinds of tools. You can run a HSQL database server for multi-user access. You will not lose all of your data as easily as with the single file database.

[LeroyTennison]

I understand and agree with your comments which is why I'm seeking a set of directions to do just what you recommend. My concern with using OBD files, etc. to convert to a split HSQLDB database is that it doesn't increase my understanding of how to make the change without assistance. The fact that dbscript.sql seems to no longer be available illustrates the risk of depending on scripts, etc. rather than understanding how to accomplish the task directly. Can someone provide a set of steps to accomplish that task?

[Villeroy]

Open the odb with a zip tool and extract the database. Read HSQL documentation and use HSQL with what you extracted. Read the exhaustive tutorials on this forum (subforum "Tutorials" sub-subforum "Base").
2 weeks ago: viewtopic.php?f=13&t=68246&p=304374&hil ... db#p304374