Re: [firebird-support] Is the embedded version right for me?
Author
Ray Cote
Post date
2014-01-12T19:43:23Z
----- Original Message -----
From: "Lester Caine" <lester@...>
To: firebird-support@yahoogroups.com
Sent: Sunday, January 12, 2014 1:54:32 PM
Subject: Re: [firebird-support] Is the embedded version right for me?
Bjorkman wrote:
>
>
> Hello,
> I currently have a java application using another database as an embedded db.
> I'm looking for replacement.
>
> The benefits of current db:
>
> 1) Embedded (just copying files into proper directory at install)
For the software to run it - yes just copy firebird files
> 2) My install use a DB already setup with tables and some initial values
> 3) If a client has problems with the SW they can send the db (4 files) to me and
> I can test with their DB in my develop environment.
> 4) If I find a problem with the DB I can update and send back to them
The database is a single file. While one can simply copy it, it makes more sense
to use the backup and restore functions to compress the data and rebuild indexes
when restoring.
My own systems use a database per website which gets automatically backed up
each night - something which can be run while the site is live! - and then
copied to the storage area for duplicating to another machine.
I'll second the suggestion to use backup the file before sending it to you.
Backups can be done while the system is live.
Copying the file while the software is running leads to potentially corrupt data files.
> 5) There is a good GUI SQL Browser with the project to work with the DB (setting
> up tables, running sql-script files, adding users, etc.) http://www.flamerobin.org/ except users are not used for the embedded server,
they form part of a full server which has it's own user database.