Search Results for: libreoffice

LibreOffice 5.3 will be announced at the end of January 2017, with a large number of new features which are summarized on the release notes page: https://wiki.documentfoundation.org/ReleaseNotes/5.3.

In order to find, report and triage bugs, the LibreOffice QA team is organizing a third bug hunting session on Friday, December 9, and Saturday, December 10, 2016.

Here is Firebird 3.0 upgrade notice in LibreOffice Base 5.3.

Also detailed migration notes for older ODB files are in the Wiki.

Lots of missing features & big bugs were fixed recently .
All of the blockers that were initially mentioned on tracking bug are now fixed.

Lionel mentioned that he added a few more blockers that needs to be fixed until Firebird will be switched by default in LibreOffice Base :

I went over
https://bugs.documentfoundation.org/buglist.cgi?quicksearch=firebird

and added a few open bugs to the blocker bug

https://bugs.documentfoundation.org/51780

based on their description (and NEW instead of UNCONFIRMED status)
only, without reading the bug log in great detail.

Tamás Bunth (Wastack) agreed that 6 months time frame is more than enough to fix bugs that will appear

I agree, it would be reasonable to wait a half year. Until that we can
fix the already found and the upcoming bugs, solve the backward
incompatibility. Even if those can be solved quickly we can upgrade to
the c++ API.

Another issue is importing old hsqldb databases without java installed

It requires making a read-only parser for the HSQLDB “cached” table
data format in another language than Java. Most definitely possible,
the format may even be better documented than “read the source code”.

There is a medium difficulty task for a c++ programmer in current GSOC 2016

The Firebird driver for LibreOffice was started, and is mostly functional, in a previous GSoC, but it needs finishing and polishing. The main remaining issue is that the firebird data format embedded in the .odb file is endianess-dependent. The idea is to switch to Firebird’s “archive” format that is not.

Required skills / knowledge
C++, SQL, Reading other’s code, capacity to work autonomously.
Difficulty
medium
Potential mentors
Lionel Elie Mamane, IRC: schoinobates, mail: lionel AT mamane DOT lu

There is a medium difficulty task for a c++ programmer in current GSOC 2015

The Firebird driver for LibreOffice was started, and is mostly functional, in a previous GSoC, but it needs finishing and polishing. The main remaining issue is that the firebird data format embedded in the .odb file is endianess-dependent. The idea is to switch to Firebird’s “archive” format that is not.

Required skills / knowledge
C++, SQL, Reading other’s code, capacity to work autonomously.
Difficulty
medium
Potential mentors
Lionel Elie Mamane, IRC: schoinobates, mail: lionel AT mamane DOT lu

A few more Firebird fixes are commited in LibreOffice git
Fdo#79493 Refresh Tables option fails with Firebird
https://bugs.freedesktop.org/show_bug.cgi?id=79493

Fdo#73352 firebird don’t claim to support interfaces one doesn’t
https://bugs.freedesktop.org/show_bug.cgi?id=73352

Fdo#74019 – FILEOPEN: Any table or select query having more than 10 fields cannot be opened in a database with embedded FireBird
https://bugs.freedesktop.org/show_bug.cgi?id=74019#c19

You can try to use the Firebird Database within LibreOffice which doesn’t need Java. This feature is still marked as experimental. Firebird Databases are available since LibreOffice 4.2. (see the release notes for further information

To turn the experimental features on, you have to go to the Settings –> LibreOffice –> Advanced –> “Enable experimental features” (see screenshot bellow)
Then you can uncheck the Java from the same Dialog.

There are few components written in Java if you use them :The Wizards, Report Builder, and Report Designer sub-components are written in Java. Full list of Java dependencies here.

Original question and source is on ask.libreoffice.org

To make Firebird Embedded default database in the new database dialog open Expert Configuration and change this key
org.openoffice.Office.DataAccess/EmbeddedDatabases/DefaultEmbeddedDatabase/Value to sdbc:embedded:firebird

Libreoffice new release with small fix for firebird sql driver fdo#74160 firebird XParameters::setString truncate to 65535 characters [Lionel Elie Mamane]
You can check release note here
https://wiki.documentfoundation.org/Releases/4.2.1/RC1

New feature preview feature in LibreOffice 4.2  : Firebird SQL connector for LibreOffice Base ( contributed by Andrzej Hunt). When creating a new Database, select Firebird Embedded in the drop down menu (you have to first enable the Experimental features in Tools ▸Options ▸ LibreOffice ▸ Advanced).

 

This allows creation of databases that perform many times faster than the previous built-in HSQLDB 1.8, avoiding the C++-to-Java overhead inherent in using HSQLDB. We plan to phase HSQLDB out over the next few releases, and provide a smooth migration path to Firebird.

Here is the history of Firebird -> Libo GSOC integration (idea ,code ,bugs, blog posts)

http://en.libreofficeforum.org/node/6062

The Document Foundation announces LibreOffice 4.2 International Bug Hunting Session, which will start on December 6th and will end on December 8th. During the three days, volunteers from all over the world will test the beta of LibreOffice 4.2 to find bugs and regressions.

LibreOffice 4.2 will be released at the end of January 2014, with a large number of new features (https://wiki.documentfoundation.org/ReleaseNotes/4.2) and loads of fixed bugs. The community is working to make this major release the finest in the history of the free office suite.

In order to join the bug hunting session, volunteers should download LibreOffice 4.2 Beta 2, available fromhttp://www.libreoffice.org/download/pre-releases/.

Mentors will be available at least from 08:00 UTC to 22:00 UTC, and will be reachable through IRC (irc://chat.freenode.net/libreoffice-qa) and the QA mailing list.

Other information on LibreOffice 4.2 International Bug Hunting Session are available at https://wiki.documentfoundation.org/BugHunting_Session_4.2.0.

What is interesting for Firebird is finding/fixing bugs related to Libreoffice Base and Firebird

• NEW TECHNOLOGY PREVIEW FEATURE: Firebird SQL connector for LibreOffice Base (Andrzej Hunt). When creating a new Database, select Firebird Embedded in the drop down menu (you have to first enable the Experimental features in Tools ▸ Options ▸ LibreOffice ▸Advanced). This allows creation of databases that perform many times faster than the previous built-in HSQLDB 1.8, avoiding the C++-to-Java overhead inherent in using HSQLDB. We plan to phase HSQLDB out over the next few releases, and provide a smooth migration path to Firebird. Connecting to modern HSQLDB 2.x external databases remains available through HSQLDB’s native interface, namely JDBC.