GSOC 2013: LibreOffice Firebird SQL Connector

Yesterday I found out that I’d been accepted into the Google Summer of Code 2013 to work on LibreOffice! Many thanks to the Mentors for accepting me!

My project involves implementing an SDBC driver for the Firbird SQL Database for LO Base, with a view to having this replace the current default of HSQLDB, which depends on Java, meaning that Java could the eventually be removed as a fixed dependency for full LibreOffice functionality. Further to this I’d also be looking at migratiom of files from HSQLDB to Firebird, and also implementing some unit tests for the database functionality, something that has been previously been missing from LO Base. (Currently .odb files use HSQLDB for their internal database, although it is also possible to use other external databases — this connector would mean that future .odb files would use Firebird internally.) There are a number of other developers who are also working on this at the moment, meaning development should be fast and exciting!

I’m currently concentrating on exams which finish at the end of the next week, after which I’ll be free to work on this full time. I’ll also be continuing with the Firefox OS Impress Remote which I started work on some time ago (but this will be completely independent of the GSOC). I now have a Firefox Phone meaning I can get on to testing things on actual hardware, and have also been doing some experimentation on implementing the UI using jQuery mobile, meaning something testable/usable isn’t too far away.

Continuing on from my GSOC project last year, there are two fellow students working on the Impress Remote this summer: Artur Dryomov will be working improving the Impress Remote / Current app, Siqi Liu will be working on an iOS version of the remote app.

Tagged with: , , ,
Posted in GSOC2013, LibreOffice
4 comments on “GSOC 2013: LibreOffice Firebird SQL Connector
  1. Hi,

    Great to hear ๐Ÿ™‚ have dun coding ๐Ÿ™‚

  2. Just curious … why Firebird and not some other FLOSS database? Was there any testing, research involved in the decision? Is it documented somewhere?

    • ahunt says:

      Licensing is the main reason as most databases are GPL — meaning they can’t be embedded into LO (LibreOffice is LGPL/MPL) . There’s a discussion on the choice here: https://bugs.freedesktop.org/show_bug.cgi?id=51781 Essentially the choice was between a newer version of HSQLDB (but that needs Java, which we’d rather get rid of), SQLite (but that doesn’t have the desired functionality) and Firebird.

  3. Allan says:

    I’m anxious to see LO ( and OO ) finally get a serious database. It would be an incredible marriage ( or perhaps love-affair ) to be able to use the other apps in the LO suite in developing a front end for useful applications for my customers. The only thing which has been holding me back has been that the apps I develop are Database apps, for vertical markets, and “base” isn’t multi-user. Here’s 3 cheers for all who’re working on making FB more available / usable w/LO !!!