Category: Developer News
News from the Firebird developers.
Change made to make Faster restores with gbak
There is a simple change which makes restores much faster, tested with Linux 2.5 embedded restore
Two databases, with two different tables filled with 2,000,000 records:
create table t1 (n1 integer);
create table t10 (n1 integer, n2 integer, n3 integer, …, n10 integer);
---------------------- Restore timings: T1: 14.5s T10: 20.5s Improved gbak timings: T1: 9.7s T10: 14.7s ----------------------
The good news is there is still room to improve the restore speeds , here is Adriano’s tweet:
I do have a slight different method, to insert 100K records in less than 1s over the same localhost method.
Also confirmed by the ending of the article:
PS: There is other restore improvement capable of take down time from
around 8.5s to 0.5s over TCP, but it still requires some analisys.
New development snapshots of FlameRobin 0.9.3
new development snapshots of FlameRobin (SVN revision 2092) to the sourceforge download area
Right now for Windows only, 32 and 64 bit, both installer and ZIP packages.
Debian Package is ready in experimental area
Update: There is a known error and new snapshot will be done on Monday in svn is already fixed in revision 2092
pyfirebirdsql will become the next Firebird Python driver
Philippe Makowski wrote on the firebird-python list
The driver is hosted on github https://github.com/nakagami/pyfirebirdsql
First thanks Hajime Nakagami for your job
I really thinks that we need to put our effort on this driver so it became the Firebird Python driver instead of Kinterbasdb
here few points I saw :
– need a change in setup.py so install work
– transactions parameter we need the possibility to send custom transaction parameter buffers, for what I saw today transactions are (isc_tpb_write, isc_tpb_wait, isc_tpb_read_committed, isc_tpb_rec_version)
– need documentation
– can we extend it or create a new module to work with trace api ?
….
ps after a small change in setup.py I will certainly package it for
Mageia and Fedora
perl-DBD-Firebird rpm package is in #Mageia, first distro with the new Firebird #perl driver
Mageia is a Mandriva Fork and is Perl friendly and become more and more Ruby friendly
Now the perl DBD Firebird driver landed in the Mageia repository
Firebird main website redesign : testers/proofreaders needed
We need all resources at the current stage of new web-site development.We have beta version now – www.firebirdtest.com, and it requires testing efforts.
The most important thing now is proofreading, so we need English native speakers first.
To report any problem, please create issues at tracker.firebirdsql.org in the Web site section http://tracker.firebirdsql.org/browse/WEB
(issues with wrong section will be not considered).
Please feel free to ask any questions.
#Mageia first #Linux distro with packages for Ruby and Rails
Philippe wrote on statusnet : fb and fb_adapter are packaged into Mageia first distro with packages for Ruby and Rails (Active Record driver)
PHP 5.3.6 released with changes for Windows users :VC++6 builds disabled
Officially VC++6 builds are dead (There are community builds but unsupported by core php developers)
Here is the announcement
Windows users: please mind that we do no longer provide builds created with Visual Studio C++ 6. It is impossible to maintain a high quality and safe build of PHP for Windows using this unmaintained compiler.
For Apache SAPIs (php5_apache2_2.dll), be sure that you use a Visual Studio C++ 9 version of Apache. We recommend the PHP builds as provided by ApacheLounge. For any other SAPI (CLI, FastCGI via mod_fcgi, FastCGI with IIS or other FastCGI capable server), everything works as before.Third party extension providers must rebuild their extensions to make them compatible and loadable with the Visual Studio C++9 builds that we no longer provide.
#AnyDAC Spring 2011 v 4.0.7 – #Delphi Components for Firebird, Interbase and more
 |
DA-SOFT Technologies announces the availability of AnyDAC for Delphi Spring 2011 release v 4.0.7.1719 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, DbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications. |
AnyDAC for Delphi can be immediately downloaded from the download page.
What is new in v4.0.7 and what is AnyDAC ?
Firebird Maestro 11.2 released
|
SQL Maestro Group is pleased to announce the release of Firebird Maestro v. 11.2, a powerful Windows GUI solution for Firebird administration and database development. |
New version features support for a lot of Firebird 2.5 and Firebird 2.1 new features, tools to generate CRUD stored procedures and updatable views, enhanced Dependency Tracker, and other useful things. Read full press-release.