MySQL vs. HSQL

[Bobiscool]

Can I use The Base in openoffice.com(HSQL) as a sibsitute for MYSQL? If so how do you add it to your PHP/HTML?

[Villeroy]

You could substitute MySQL with a HSQL server. This may be useful for Java programmers. The HSQLDB which can be wrapped in OOo's database documents is not accessible from any other software. It's a desktop database for a single application, in a single file, for a single almighty user.
You could use Base as an alternative way to access your existing MySQL, create pretty reports to print on paper or pdf, input forms attached to office documents and you can feed spreadsheet calculations with data.

Base is not a full featured database application. Base is just a bridge between databases and office documents. Everything is tied to ODF documents.
[any server] <--> [Base] --> [Writer/Calc&Co]
The embedded HSQL data get extracted to a temporary directory before they are served by a HSQL server.

[paulparker]

One reason for setting up Database is for other users to have read or write access to some of the data. Eventually like make available when logging in from elsewhere...

Villeroy advised: "The HSQLDB which can be wrapped in OOo's database documents is not accessible from any other software. It's a desktop database for a single application, in a single file, for a single almighty user."


Is OOo database NOT available to other users after they log themselves in on same pc, even if use OS permit for them to have read/write access ?

[r4zoli]

s OOo database NOT available to other users after they log themselves in on same pc, even if use OS permit for them to have read/write access ?

Not in this way.
If odb files open in one OOo creates a lock file, if others try to open it file opens as read only.
No other measures to stop opening files.

[Zeke_3]

Is this valid for HSQLDB 2.x also?
Only one user can connect to the database at the same time?

As I understand ooo 3.5 will include HSQLDB 2.x.

If you need access from 2 or 3 computers at the same time, is mysql the choice of db-engine?

[Villeroy]

Is this valid for HSQLDB 2.x also?
Only one user can connect to the database at the same time?

As I understand ooo 3.5 will include HSQLDB 2.x.

If you need access from 2 or 3 computers at the same time, is mysql the choice of db-engine?

The problem is the local file access when the embedded database gets installed (extracted) every time you "open" the database document.
I run HSQLDB 2 in a mixed Win/Lin network with Base forms and Calc reports. The same should work with any other database engine such as MySQL, Postgre, Oracle, MS SQL Server, H2 and many, many more.
You can also run HSQLDB 1.8 as a server for multiple users.
The embedded HSQLDB 2 in OOo 3.5 will be the same unstable trash as the current one (with more featues of course). The embedded mode is the problem, not HSQLDB

[DACM]

Is this valid for HSQLDB 2.x also?
Only one user can connect to the database at the same time?

The default 'embedded database' configuration is limited to a single-user which currently requires a specific version of HSQLDB (1.8.0) as delivered with OOo/LibO 3.4.x and earlier. But that's not you're only configuration option with HSQLDB. When connected to the same, built-in, HSQLDB engine through the built-in JDBC driver, you can choose between single-user and multi-user modes. These modes are setup as 'existing databases' with Base and are completely stable. In 'server' mode, HSQLDB supports multiple, simultaneous, read/write users through Base or any other front-end. See my signature links below for details.

See aslo: Base+RDBMS Pros/Cons
.