[Solved] How to tell HSLQDB version in LibreOffice?

Discuss the database features

[Solved] How to tell HSLQDB version in LibreOffice?

Postby kbellis » Mon Apr 15, 2019 3:05 pm

How to tell HSLQDB version in LibreOffice.PNG


How can one tell which HSLQDB version is being used in LibreOffice?
Last edited by kbellis on Mon Apr 15, 2019 3:42 pm, edited 1 time in total.
LO6222(x64) • AOO416 • Windows 10 Pro, 64-bit
User avatar
kbellis
 
Posts: 58
Joined: Sat May 28, 2011 6:25 pm
Location: Ellsworth, ME

Re: How to tell HSLQDB version in LibreOffice?

Postby Villeroy » Mon Apr 15, 2019 3:28 pm

This will always be 1.8 for the embedded HSQLDB documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27114
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to tell HSLQDB version in LibreOffice?

Postby kbellis » Mon Apr 15, 2019 3:58 pm

Villeroy wrote: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
LO6222(x64) • AOO416 • Windows 10 Pro, 64-bit
User avatar
kbellis
 
Posts: 58
Joined: Sat May 28, 2011 6:25 pm
Location: Ellsworth, ME

Re: [Solved] How to tell HSLQDB version in LibreOffice?

Postby MrProgrammer » Mon Apr 15, 2019 4:21 pm

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
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3815
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: [Solved] How to tell HSLQDB version in LibreOffice?

Postby Villeroy » Mon Apr 15, 2019 4:34 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27114
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: Google [Bot] and 4 guests