Author: mariuz

http://wiki.ubuntu.com/Mariuz

An ODBC driver for Firebird on MacOSX

Leave a comment

Via Paul Beach Blog

I was recently contacted by a Firebird user on MacOSX who was trying to get the Firebird ODBC driver to build on MacOSX. I thought I would try and step in to help.

For those of you who follow the CVS checkins for OdbcJdbc you might have noticed the addition of a number of a new directory in the Builds directory called Gcc.darwin containing a makefile, a readme and a .sh file to create a lipo’ed dylib. The driver sucessfully builds and passes some simple tests. Feel free to contact me for a copy of the dylib to test further.

The readme contains the following information

Microsoft Access killer : LibreOffice Base + Firebird

Leave a comment

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

node-firebird vs node-firebird-libfbclient (pure JavaScript driver vs Firebird library wrapper)

Leave a comment

Denys Khanzhiyev (node-firebird-libfbclient creator) wrote on nodejs mailing list:
I must admit your lib is faster than mine (See the response from Henry (node-firebird creator) , it is the result of the firebird library mode of operation : synchronous vs asynchronous mode of nodejs)

Here is code
https://gist.github.com/2854642

here is ab results

node-firebird-libfbclient:

Concurrency Level: 5
Time taken for tests: 3.346934 seconds
Complete requests: 1000
Total transferred: 885000 bytes
HTML transferred: 821000 bytes
Requests per second: 298.78 [#/sec] (mean)
Time per request: 16.735 [ms] (mean)
Time per request: 3.347 [ms] (mean, across all concurrent requests)
Transfer rate: 258.15 [Kbytes/sec] received

node-firebird:

Concurrency Level: 5
Time taken for tests: 2.928723 seconds
Complete requests: 1000
Total transferred: 885000 bytes
HTML transferred: 821000 bytes
Requests per second: 341.45 [#/sec] (mean)
Time per request: 14.644 [ms] (mean)
Time per request: 2.929 [ms] (mean, across all concurrent requests)
Transfer rate: 295.01 [Kbytes/sec] received

1 … 107 108 109 110 111 … 296