[Solved] How to tell HSLQDB version in LibreOffice?

[kbellis]

How can one tell which HSLQDB version is being used in LibreOffice?

[Villeroy]

This will always be 1.8 for the embedded HSQLDB documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html

[kbellis]

This will always be 1.8 for the embedded HSQLDB documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html

Thanks for clearing that up Villeroy.

I'm still curious why v1.8 isn't clearly listed in LO's about screen, particularly since it's deprecated and so much effort appears to avoid its use? This is all quite new and nuanced for me, and I may have gotten the wrong impression at this early stage of learning LO Base. Man!, I was at first thinking Base would be a simple thing to learn in a few days or even a few hours. Regardless of my false expectations, your guidance and encouragement, and from others here in this community, are heartening - THANK YOU!!

Kind regards,

Kelly

[MrProgrammer]

You can verify the version by creating a new embedded database, unZIPping the ODB file, and viewing the database/properties file.

$ cat database/properties
#HSQL Database Engine 1.8.0.10
#Mon Apr 15 09:08:16 CDT 2019
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=true
hsqldb.cache_size_scale=8
readonly=false
hsqldb.nio_data_file=false
hsqldb.cache_scale=13
version=1.8.0
hsqldb.default_table_type=cached
hsqldb.cache_file_scale=1
hsqldb.lock_file=true
hsqldb.log_size=10
modified=yes
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0

[Villeroy]

Base is extremely simple (too simple) for anybody who is familiar with databases in general. The whole component weighs no more than 30 MB including various database drivers.

Embedded HSQL 1.8 is fine for demos and education. 10 years ago I implemented a fairly complex project with embedded HSQL and it allowed me to collect dozends MB of data over 2 years without a single problem.
I was aware of the problems with this data format, saved and closed my work properly and I do daily backups of all my data.

Meanwhile I run a little HSQL server with a database for up to 6 clients. HSQL 2.3.4 works pretty well with our office suite and the stand-alone HSQL meets all my expections. I do not feed any web site with this database but even that should be possible.

Others use Base successfully with PostgreSQL or with MySQL. Base is just a set of tools to connect text and spreadsheet documents with databases. The ability to generate databases from scratch and wrap them into one document file has been added in 2005. IMHO, this was a mistake and LibreOffice with embedded Firebird will not change anything to the better.