#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.

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

null

TPC-R (Seconds – Lower is Better)
FirebirdSS-1.5.5 621
FirebirdSS-2.1.2 2748
FirebirdSS-2.5Beta2 526

null

1 30 31 32 33 34 58