Category: Developer News
News from the Firebird developers.
Connecting from iPhone to Firebird
I decided to challenge MonoTouch and create iPhone application that connects to Firebird server using .NET provider for Firebird. Read more…
#Fisheye in the Firebird #jira tracker
From the cool stuff department if found the Fisheye in the Jira tracker and it shows all bugs closed and related code changes (diffed)
Firebird Tracker is Restored
Firebird’s Jira Tracker is now restored on the new VM, with data up to 5 December 2009. However, we have lost attachments from the last two years. Missing ticket headers from after Dec 5 will need to be reconstructed from notification messages. Read more
Testing Firebird 2.5 Almost RC1 packages on #debian or #ubuntu
Damyan Ivanov requested from us to test the new Firebird 2.5 (almost rc1) packages on Debian based distros (Ubuntu)
I have updated the HowTo build the packages from Git repository.
There are still known big issues but you can start testing and give feedback on Firebird Debian list
#RIP #Dudley #GDML in Firebird 3.0 – #Sql won
Dudley – Sounds like DDL (data definition language) and is the pre (interbase) 4.0 data definition utility GDEF. It’s actually named after Dudley Doright, a character from Rocky and Bullwinkle. GDEF accepts a data definition language based on GDML.
Full thread on Firebird-devel list
Another definition on original source code description (interbase 6.0)
DDL utility. Interpreted commands in the old data definition language (declare relation, declare field – square brackets where you want to put parentheses). Generates BLR for views and triggers, GDML (non-SQL relational language) for metadata updates.
#Django firebird driver project news
Hello everyone, I want to make a summary of the changes implemented in
recent times about the project django-firebird:
-
* More complete exception error messeges (ported from pre-django 1.0
version)
* Added a new attribute to obtain the version of Firebird. Useful to
ensure compatibility with firebird 1.5 and 2.x
* Implemented the proper support for data conversion. (Issue 8)
* Fixed bug on with_limits parameter on FirebirdQuery.as_sql. (Issue 9)
* Fixed bug on autoinc implementation (Issue 3)
* CHAR is mapped to CharField now (formerly TextField) – (Issue 6)
* NUMERIC/DECIMAL are mapped to DecimalField now (formerly Integer) –
(Issue 6)
* Correct interpretation of RDB$FIELD_SCALE for NUMERIC/DECIMAL fields –
(Issue 6)
* Correct consideration of is_null behaviour at field level – (Issue 6)
* Correct FOREIGN KEY evaluation in get_relations() – (Issue 6)
* Support for UNIQUE indices for UNIQUE – (Issue 6)
* Clean and better source code organization.
Remember, this software is still in alpha version, use it at your own risk.
Feel free to try and make any comments on this subject.
We need to add more experience with django and firebird to resolve some
issues. Any help will be apreciated.
Regards.
—
Maxi.
Benchmarks with Firebird, #MySQL and #PostgreSQL
From Tomneko (Tsutomu Hayashi)
I tested Firebird, MySQL and PostgreSQL with my DbBench on HP ML115G5.
This presentation was already done in japan. (
It’s now uploaded to google docs)
You can view odp presentation here also ppt version is here
It’s up to SlideShare too for thouse who like flash or want to embed it in the blogs.
http://www.slideshare.net/tomneko/firebird25-benchmarksenglish20091031
TPC-R results on Intel quad core
Tsutomu Hayashi did some benchmarks and here are the results with the time in seconds
Intel Core2Quad 9550 with 4G Memory Firebird Protocol: LocalConnection
All Firebird is defalt settings FB-2.1.2 is very slow, FB-2.5 is fastest.
DBcreation (Seconds – Lower is Better)
FirebirdSS-1.5.5 3007
FirebirdSS-2.1.2 1651
FirebirdSS-2.5Beta2 1289
TPC-R (Seconds – Lower is Better)
FirebirdSS-1.5.5 621
FirebirdSS-2.1.2 2748
FirebirdSS-2.5Beta2 526
#Debian gives #FreeBSD some love becomes official part of the distro – Firebird port included
Firebird does have official ports for debian kFreeBSD and maybe it’s easier to use FreeBSD kernel from an Debian/Ubuntu background (apt-get)
News via tuxradar
Upcoming release of Debian, codenamed Squeeze, will be available in a juicy new FreeBSD flavour alongside the regular Linux version. Well, Debian GNU/kFreeBSD has been around for a while, but now it will be an official part of the distro, combining the titanium-strength FreeBSD kernel with the GNU C library
What is left to be done on the porting front ? maybe fixing the building on avr, hurd and m68k (sh4 is already done) but these are not yet official debian ports.
Also alpha cpu support seems to be dropped from debian release archiectures so no porting effort is needed
I took one list from 2007 and you can compare where we are now
Already ported:
i386
amd64
mipsel
sparc
powerpc
kfreebsd-i386
kfreebsd-amd64
arm
ia64
mips
s390 = IBM/S390
superH (sh4)
Need to be ported:
alpha is dead
m68k
hurd
avr
hppa
ps:
So you can install firebird on the phone (maemo is arm debian linux) or on the mainframe linux (ibm s390)
