Firebird News

January 2007

Monthly Archive

SQLObject 0.7.3

Posted by Oleg Deribas on 30 Jan 2007 2:14 pm. Filed under Tools & Products releases.

SQLObject Version 0.7.3 release is now available.

SQLObject is a popular python ORM for providing an object interface to your database, with tables as classes, rows as instances, and columns as attributes.

SQLObject includes a Python-object-based query language that makes SQL more abstract, and provides substantial database independence for applications.

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

Pascal Data Objects

Posted by Cantu on 30 Jan 2007 8:28 am. Filed under Tools & Products releases.

Unsatisfied with the available libraries for object Pascal to connect to various databases with a standard API, I created “Pascal Data Objects” which is loosely patterned after PHP Data Objects, and originally supported MySQL 4.0, 4.1, and 5.0 using native client libraries. I recently moved the project to Sourceforge ( pdo.sourceforge.net ) and added support for Firebird 1.5 and 2.0.

PDO is licensed LGPL as it contains some code from Zeoslib, which is LGPL. One particularly nice thing about my implementation of the Firebird drivers is that I built in “prefetch” support. By default, the driver prefetches the entire result set and stores it internally so that functions that depend on knowing how big a result set is before accessing the data can be supported. There is also some data abstraction functions.

The source code is packaged at Sourceforge and works on Delphi and Free Pascal Compiler, tested and used in both Windows and FreeBSD programs. If you decide that this is newsworthy, then I’ll leave the wording up to you.

Regards,
John (J.R.Marino — firebirdnews @ marino.st)

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

Interbase/Firebird Development Studio has been updated.

Posted by Paul on 30 Jan 2007 7:42 am. Filed under Tools & Products releases.

SQLLY Development team is happy to announce the availability of the next version of Interbase/Firebird Development Studio. This release introduces InterBase 2007 support. New interesting feature is an ability to automatically collect undefined variables in the SP or trigger and detect their data types.

Please find detailed list of news and fixes at:
http://www.sqlly.com/news/chagelogs/changelog9.en.html

More information about Interbase/Firebird Development Studio can be found at:
http://www.sqlly.com/IBDS.en.html
http://www.sqlly.com/features.en.html

30-days evaluation version is available at the following page:
http://www.sqlly.com/download.en.html

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

BlazeTop (SQLHammer) version 1.7.0.99 – a tool for IB/FB database administration

Posted by Marina Novikova on 29 Jan 2007 3:42 pm. Filed under Tools & Products releases.

BlazeTop (former SQLHammer) version 1.7.0.99 is available for download.
What’s new in version 1.7.0.99?
Purchase BlazeTop (129 Euros for Single license):

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

FIBPlus version 6.5 (trial) is available for download

Posted by Marina Novikova on 29 Jan 2007 3:36 pm. Filed under Tools & Products releases.

I am happy to inform that FIBPlus 6.5 (trial) is available for download.

As I have already announced, version 6.5 in particular has a better support of Firebird 2.0.

Purchase FIBPlus for 235 Euros only.

[See remaining text...]

FIBPlus 6.5 Release Notes

New features and enhancements:

1. Now the SQLMonitor shows the SQL text after applying macros and
conditions

2. Now the OnFillClientBlob event is called after the record is
first read as well as after it’s modified.

3. TpFIBDataSet.Options has a new option poUseSelectForLock. It can
be used if poProtectedEdit = True. In case poProtectedEdit = True, the
record will not be locked by “dummy update”, and the following statement
will be used instead:
Select * from TABLE1 WHERE … for update with lock
Note: This feature works ONLY for Firebird)

4. The FIBQuery.ExecuteImmediate method has been added. It executes
the query immediately, without Prepare (see the isc_dsql_execute_immediate
function in the IB API manual)

5. Now ExecuteImmediate executes DDL queries.

6. The CopyFieldsProperties procedure has new properties:
AutoGenerateValue, ConstraintErrorMessage, CustomConstraint, Tag and
Index.

7. The pFIBDataSet.ReceiveEvents property and the
pFIBDataSet.OnUserEvent event are being deprecated and will be removed from
the main code in future versions. People, who are still using this property
should compile the library with the define USE_DEPRECATE_METHODS2 in
FIBPlus.inc.

Bugs fixed:

1. Occasionally an incorrect record was added to a sorted dataset.
Fixed.

2. An error in TpFIBCustomService.GenerateSPB occurred if the
Params property was empty. Fixed.

3. On changing the Filter property previous filter results were not
refreshed. Fixed.

4. An error in the Locate method on searching numerical values in
string fields. Fixed.

5. The SQLMonitor worked incorrectly on exception monitoring
(sometimes caused suspension). Fixed.

6. Incorrect behaviour of the SQL dataset editor with queries
containing the same table in several places. Fixed (guaranteed for Firebird
2 only).

7. Cached calculated fields in TFIBCustomDataSet.RecordFieldValue
did not have the ftSmallInt type. Fixed.

8. Incorrect handling of fields with charset UTF8 and collate,
different from the default value. Fixed.

9. If the database was in the shutdown mode, the connection
automatically closed. Then the lost connection was handled (with
pFibErrorHandler). Fixed.

10. An error in the query generator has been fixed: the field type
was not shown for DOUBLE PRECISION fields. Fixed.

11. A small memory leak on working with the BLOB parameters. Fixed.

12. An error on locating a Unicode-string in the field
varchar(unicode_fss) if poTrimCharFields was set to True. Fixed.

13. Function InvertOrderClause(const OrderText:string):string;
incorrectly functioned:
it did not handle Order By using NULLS FIRST, and thus caused
incorrect work of the confined local buffer for such queries). Fixed.

14. TpFIBDataSet.PSInTransaction, PSStartTransaction,PSEndTransaction methods functioned incorrectly. Fixed.

15. An error on executing DDL queries in the Unicode Connect (comments in languages other than English were corrupted). Fixed.

« Hide it

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

Firebird Embedded and .NET

Posted by Jiri Cincura on 28 Jan 2007 1:16 pm. Filed under Developer News , General news.

I (Jiri Cincura) have created a small how-to for Firebird Embedded and .NET.

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

SQLAlchemy 0.3.4 release is now available

Posted by Cantu on 28 Jan 2007 9:59 am. Filed under Tools & Products releases.

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

Changes in firebird module:

order of constraint creation puts primary key first before all other constraints; required for firebird, not a bad idea for others ticket:408]
Firebird fix to autoload multifield foreign keys [ticket:409]
Firebird NUMERIC type properly handles a type without precision [ticket:409]

Download it at http://www.sqlalchemy.org/

(No Ratings Yet)

Loading ...

Permalink | Leave your comment |

Garbage Collection problem in IB/FB

Posted by Cantu on 27 Jan 2007 10:54 am. Filed under Technical Articles.

Dmitry Kouzmenko just posted a new article in his blog, describing currently Garbage Collection problems with both IB and FB. Very interesting reading!

His blog has other interesting posts, you really should read it.

(No Ratings Yet)

Loading ...

Permalink | [5] Comments |