Change to Base Guide Supplemental to include Firebird engine example files

Howdy,

As you know starting with 6.4 both the HSQL and Firebird embedded databases
are supported by default in the application.

It seemed like a good idea to begin by offering the same set of example
databases using a Firebird RDBMS as currently exist for HSQLdb.

I've add Robert G. to CC on this email because it could be that he has
already done what I've just started.

Two days ago I started the conversion of the set of files to Firebird.

The initial step was to run each through the Migration assistant, this
rendered all files with migrated data tables.

Now comes the task of fixing up those things which would not migrate
automagically. Some views in a few of the files, queries and embedded SQL
in components and macros.

What I propose is to create two folders in the supplemental (HSQL and
Firebird) under the 6.2 guide section each folder holding like named odb
files, even though I don't expect the 6.2 guide will mention them - this
way they are available for anyone to compare one against the other.

I thought I'd start by putting this batch of files, as is, to the Firebird
folder with a calc file listing which are finished and which still need
work.

If there is no objection.

Thanks

Drew

Actually there is another way which may make much more sense.

Leave the files in the Base Guide 6.2 folder untouched.

Create a Base Guide 7.0 instead which supplemental/hsql and
supplemental/firebird folders and I suppose for the moment nothing else.

I think that makes more sense.

Drew,
Doing that for BG7.0 is a good idea.
I assume you are keeping notes on what to do to fix up those things
which would not migrate
automagically. Might be a useful appendix to the book? Or... something.

Jean

Hi Drew,

I have migated many of the databases to Firebird but havent translated
these databases to English. The main problem is to migrate the queries
and the views.

But there is another discussion to set creation of Firebird back to
experimental, because there are many bugs and nobody, who has time to
fix these bugs:
http://document-foundation-mail-archive.969070.n3.nabble.com/About-putting-Firebird-creation-option-experimental-td4274028.html

I will change the content of the Base-Handbuch a little bit, because
there are many people, who have started with Firebird, which is
described as the future of LO-Base there. But there is nearly no
developement the last year and the bugs are almost the same. So I won't
recommend people to change to Firebird.

Regards

Robert

Hi Drew,

I have migated many of the databases to Firebird but havent translated
these databases to English. The main problem is to migrate the queries
and the views.

So far the queries have not been all that bad. The views are a bit of a
different story. But I've only touched one of those so far.

But there is another discussion to set creation of Firebird back to
experimental, because there are many bugs and nobody, who has time to
fix these bugs:

http://document-foundation-mail-archive.969070.n3.nabble.com/About-putting-Firebird-creation-option-experimental-td4274028.html

Darn, seems I was no longer signed up for the DEV ML. Fixed now.

Anyway, I pulled yesterday's builds for 6.4.2 and 7.0. This change has
already landed in 7 but not the 6.4 build.

I will change the content of the Base-Handbuch a little bit, because
there are many people, who have started with Firebird, which is
described as the future of LO-Base there. But there is nearly no
developement the last year and the bugs are almost the same. So I won't
recommend people to change to Firebird.

Fortunately with the change a user can open and run an embedded Firebird

file from a default install, just can't create new ones without first
turning on experimental features.

For myself I'm going continue on, if for no other reason it is a good way
to exercise the 7.0 code against Base. That already yielded one issue, as
you know, and there may be more.

Best wishes,

Drew

sorry that wiki page is at
https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

Drew,
Doing that for BG7.0 is a good idea.
I assume you are keeping notes on what to do to fix up those things
which would not migrate
automagically. Might be a useful appendix to the book? Or... something.

Indeed - there is already a page on the wiki, thanks Beluga, Robert,

Ohallot, K-J and Dan. I'll look to that and if there is anything to
contribute will update the page.

Best wishes,

Drew