rfc: TRUNCATE TABLE in Firebird

Vlad Khorsun posted on Firebird-Architect

One of the often task in ETL applications is to quick erase all data in some table(s). Often amount of data is big or huge (tens of millions records). In Firebird we have two choices currently – DELETE all rows or RECREATE TABLE. Both have its own drawbacks. DELETE produced a lot of record versions to clean up, its slow as works row-by-row basis and fire triggers which is almost always is not needed. RECREATE is free from this drawbacks but it will fail if there is dependencies and all related objects such as triggers, indices, constraints must be recreated too. Read more

Lazarus 0.9.26 released

The changes in this release are as follows:
The LCL now uses Unicode strings encoded as UTF-8 on all platforms.
Lazarus now runs natively under Mac OS X using the “Carbon” widget
set. The LCL internal graphic system was rewritten for more
consistency, more flexibility, better Delphi compatibility, icon
support, and native image lists. The IDE designer now allows you to
connect form components, like databases on TDataModule.

Lazarus can be used with Firebird and there are many components to choose UIB, Zeos , FbLib , PDO

1 195 196 197 198 199 297