LO Base

users
#1

I have a question about Base:

I used to work with standalone HSQLDB using Java on the OS/2 (eCS) platform. During that time, it was announced that Sun's upcoming release of Open Office would include HSQL as the builtin database engine. I have recently read that Open Office no longer uses HSQL. Is that also true of LO?

If HSQL is indeed the builtin database engine, is it really necessary to have another database product to do database work in LO Base?

I stopped using eCS a few years ago when the (at the time) latest version would not install on my new computer. I am now using Windows 10 (which I literally despise).

Dale Erwin

#2

I have recently read that Open Office no longer uses HSQL. Is that also

true of LO?
If a new Base is created in LO 5.1.x it will be default is "HSQLDB
Embedded" to store the data.

is it really necessary to have another database product to do database

work in LO Base?
Not necessarily, but this is a feature which allows Base to be used as
front end to another database. This might be done for various reasons like
(1) the other database already includes the needed data, (2) a concurrent
multi-user environment is wanted which is not available via HSQLDB embedded
but is possible with HSQL split , (3) a wanted feature is available in
another database but not in HSQL, (4) a preference for another database,
Etc. Reference this: https://wiki.openoffice.org/wiki/FAQ_(Base)