GSOC LibreOffice Firebird Integration Weekly Update 14

New GSOC update for the previous week with
current status of the firebird-sdbc driver :

Progress this week:
- Some dbexception cleanup.
- Fixed ColumnLocate::findColumn implementations (for all 
  db drivers) and api definition.
- Fixed index rebuilding.
- Tried to experiment with different ICU versions, but haven't 
  managed to actually produce any errors when switching ICU 
  version 
- Fixed formatting of integers as a currency, integers now
  show as a number and not currency by default.
- Fixed segfault when setting Null as first value in 
  PreparedStatement.
- Reintroduce statement specific Mutexes (instead of a
  connection-wide Mutex).
- Implemented simple firebird unit tests to see that we can 
  really transfer a .fdb between machines with different 
  OS/CPU/bit-ness.
- Some generic cleanups.
- Tried to create a hsqldb cppunit-test.

GSOC LibreOffice Firebird Integration Weekly Update 13

New GSOC update for the previous week with
current status of the firebird-sdbc driver :
Progress this week:
– Made libatomic-ops buildable meaning that we should now be able to build embedded firebird on non-X86 systems too
– Added rebuilding of indices to deal with the icu collation issues.
– Implemented a simple .odb loading test (in gerrit atm.) that also
tests that the embedded firebird .fdb can be connected to.
– Implemented Index retrieval and dropping
– More fixes to do with the firebird temporary and lock directories
– Some coverity fixes
– Started working on foreign key retrieval

Code commits can be reviewed in the LibreOffice git repository

GSOC LibreOffice Firebird Integration Weekly Update 12

New GSOC update for the previous week:
Current status of the firebird-sdbc driver is:

– (Var)Char, Numeric and Date/Time types all supported. (No support for blob/clob/array/etc. yet.)
– Data Editing in the GUI works.
– Data Insertion works.
– Table and Column definition/manipulation is mostly complete, there might still be a few minor-to-major issues, indexes aren’t supported at all.
– Usable on Linux, Mac, Windows (thanks to tml for fixing the fbembed
library / loading on Mac).

ps: you can check also the previous updates #11,#10,#9

Firebird Driver and Embedded version merged into LibreOffice git master

Changes to libreoffice and firebird driver can be seen in the git log

And here is announcement :

Firebird has now been integrated into LibreOffice master!

It now builds on Mac and Windows in addition to Linux. (I’ve only tested on Linux but will be testing/fixing as necessary on Mac/Windows this week.)

The database driver itself is almost unusable at the moment as I’ve been refactoring various things to do with transaction control and execution of statements. More and more functionality should be appearing in the course of this week, making the driver more usable .

Odb with embedded firebird db

Firebird .ODB

 

 

Microsoft Access killer : LibreOffice Base + Firebird

There is a discussion on the libreoffice-dev about replacing the HSQLDB default database used in libre base with something better and faster than the java based solution:)

* SQLite vs. HSQLDB for base (Lionel)
+ SQLite very sloppy typing can cause serious problems cf.
https://bugs.freedesktop.org/show_bug.cgi?id=38811#c22
+ no date/time datatype.
=> perhaps not a good idea to switch to sqlite longer term
+ without tons of special casing, get lots of
nasty bugs outside string, float
+ a new candidate with sane licensing, sane language,
and code size required – thinking ongoing.
+ our best shot might be firebird
+ MPL license variant
+ feature set looks good

Update : Firebird Driver and Embedded version merged and integreated into LibreOffice git master

1 2 3 4 5