Ask Your Question
0

Independent FireBird install versus LO Embedded Install

asked 2019-11-02 05:53:01 +0100

libraryOffice gravatar image

I am an experience MS Access user who decided to give LO Base a try. I created a LO embedded FireBird database. I had created half a dozen tables and populated them with data. Then there was a power failure. When I got my machine booted back up, LO gave a restore option but both the original file and the restored file were both empty - all tables and data lost. I lost several hours effort but I will live. It was my first attempt to use LO and I hadn't yet made a backup.

I did some research and I see that there is an independent FireBird install that can run as a service. Would I have increased stability if installed FireBird running as a service and then connected to it via Libre Office Base or is there no substantial benefit over the embedded install? Are there any concerns or downsides with this approach? Besides making frequent back-ups, closing the the LO Base when not actively using, and buying a UPS are there any other alternative/additional recommendations for preventing data loss? Please feel free to refer me to any relevant documentation that I would benefit from reading.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-11-02 18:11:44 +0100

Ratslinger gravatar image

updated 2019-11-02 18:14:47 +0100

Hello,

Using Firebird embedded does have (my opinion) this major drawback. Data to the tables is not committed to the tables until you actually save the Base .odb file. This is not true when using other DB connections including Firebird File as you mention.

Using a Firebird File does not require any 'independent FireBird install' but can be created when creating a new Base file -> Connect to an existing database->Firebird File.

Portability is probably the main consideration in using an embedded DB.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-11-02 05:53:01 +0100

Seen: 44 times

Last updated: Nov 02