In my honest opinion this leads to nowhere until somebody shows me a working, non-trivial example database with one-to-one, one-to-many, many-to-many relations and all data types fully supported with queries, forms and reports. leaving aside the option to create an embedded Firebird database with LibreOffice 6. In many cases Base can help transfering data from one type of database to some other type of database. In a third step you may even set up a HSQL server to serve many instances of the office suite or any other type of frontend, including web based frontends. If that database turns out to be productive by any means, you can convert it easily to a stand-alone HSQL database by extracting the embedded database out of the containing Base document. If you want to learn something about relational databases in general you may start with a Base document and embedded HSQL. LibreOffice Base has nothing to offer in this context. If you have some database finished, up and running and you want to access the contained data with a browser on some network, then you certainly need a completely different set of tools. If you have some database finished, up and running and you want to access the contained data with your favourite office suite, then you may connect a Base document to that database and work with the contained data (not with the db itself) in the context of this office suite. This depends on the database driver (the actual software which handles the data) and Base's capability to handle the capabilities of the driver. Any other product that may be connected to a Base document may be edited on data level but not on the design level. The one and only type of database you can create with Base is HSQL version 1.8 embedded in the Base file. Base is just a bridge between some database and an office suite. For any stack like LAMP, MAMP or similar, you have mature tool sets. If you don't know what fits your needs, we don't neither. Use whatever database engine fits your needs. By contrast, I believe large databases like Oracle have hundreds or thousands of files which make up the database.) Q4.) Whether I choose HSQLDB or Firebird, where does the actual database, and database files, exist? (When I used MS Access long ago, your entire database was in one or maybe two files. Q3.) How does HSQLDB compare to Firebird? Q2.) Is it true that if I choose the Firebird database that I won't need the JRE running on my Mac?
Q1.) According to this gentleman, LO Base is not aptly named in that it is just a front-end application designed to interact with a database on the back-end.
So far, LO Base looks almost identical to MS Access, which I suppose is a good thing based on my needs right now. I have been watching videos from TheFrugalComputerGuy.
While on my trip, I have decided to try LibreOffice - since it is more modern with apparently better support.
0 kommentar(er)
