sorted by: recent | see :
popular
Content Tagged with Technical + news
Performance improvement by using firebird client from cvs head
He doubled his performance by just switching the firebird client :
We’ve just built and tested ‘libfbclient.so’ from the head branch and tested
it against the release version 2.0.3. In other words, we only switched out
the client library, and left the database server itself intact at version
2.0.3.
The performance improvement is huge:
fbclient-head: 6% processing time spent in ‘futex’
fbclient-2.0.3: [...]
reading
firebird
performance
news
developer
Articles
Technical
Firebird remote BOF POC
Firebird Remove Buffer Overflow Proof of concept was posted on BugTraq
The bug is the one fixed in the next stable releases and is not present in firebird 2.1 rc1& rc2 here is the description:
Integer overflow in Firebird SQL 1.0.3 and earlier, 1.5.x before 1.5.6, 2.0.x before 2.0.4, and 2.1.x before 2.1.0 RC1 might allow [...]
Collation charts
The goal of this project is to provide information about how various pieces of software (e.g. operating systems, DBMS and others) sort textual data, in the form of easy-to-read charts.
Check Firebird collation charts.
Synchronization changes in cvs HEAD
A bunch of major changes has just been committed into HEAD. This message
is intended to explain the details.
Firebird Relational Database ‘protocol.cpp’ XDR Protocol Remote Memory Corruption Vulnerability
Firebird is prone to an integer-overflow vulnerability because it fails to ensure that integer values aren’t overrun. Attackers may exploit this issue to overflow a buffer and to corrupt process memory.
Attackers may be able to execute arbitrary machine code in the context of an affected application. Failed exploit attempts will likely result in a denial-of-service [...]
Security
firebird
news
developer
Articles
Technical
integer-overflow
Firebird embedded example for delphi is now ported to lazarus
I modified fb_embedded2.pas originally written for Delphi by Fikret Hasovic. Now it works with Lazarus!
[See remaining text…]
fb_embedded2.pas is a Pascal unit that can be included in a Lazarus project to enable embedding of [...]
how to use DDEX provider for Firebird in VS2008
I’ve decided to try to install into VS2008 the DDEX provider. It has been working like a charm. I’ve been doing steps like in any other installation
HOW TO Contribute to the Firebird Reference Documentation Sub-Project
The Firebird Reference Documentation Sub-Project has the goal to create a comprehensive Reference Documentation for the Firebird SQL Database.
PS: Anyone can pick a topic and write a piece of documentation for it. It’s small pieces on a per-keyword-basis, with no markups, just plain text with a very basic structure skeleton - so no skills in [...]
DDEX, Vista (64-bit), Firebird, Visual Studio 2005
Installing Firebird DDEX provider into Visual Studio 2005 on Windows Vista (64-bit). Nothing brand new, but can help begginers when trying to use Firebird in .NET and in VS.
Gfix manual added to the firebird-docs repository
After many lunchtimes of testing and documenting, and with a little (!) help from Paul in the Limbo Transactions testing, I have checked in the gfix manual.
Onwards to other things now - gpre!
Cheers,
Norman.
New GDS ( first thoughts )
Carlos Guzmán Álvarez wrote on dotnetprovider mailing list:
We are going to need to implement the version 11 of the Firebird Protocol (in .net provider) and review the buffer handling code to make better checks on
buffer lengths and server responses.
La gestion des transactions dans Firebird
you can read the article translated here
La gestion des transactions dans Firebird
Présentation du concept de transaction et du modèle transactionnel de Firebird, comparaison par rapport à d’autres SGBD. Avantages et inconvénients, bonnes pratiques de conception et de programmation.
Via http://firebird-fr.eu.org/doku.php?id=wiki:rendez-vous2007
Firebird date & time literals
Martijn wrote on his blog: For those of you who don’t know yet, or aren’t following the Firebird-support list, Helen Borrie just posted a small part of the excellent “The Firebird Book”, the date/time literals accepted by Firebird: Firebird Date/Time Literals
Keep that one for future reference.
Docbuilding Howto and Docwriting Guide updated
The Docbuilding Howto and Docwriting Guide have been updated. The most
important modifications are:
[See remaining text…]
Docbuilding Howto
Section “Improving the PDF” has been thoroughly reworked to reflect
the changes since we moved to FOP 0.93-patched.
[...]
Call for Testers: Mono 1.2.4 and Firebird .NET Provider
Mono 1.2.4 preview sources, packages, and installers are available at:
http://mono.ximian.com/monobuild/preview/download-preview/
The beginnings of the release notes for 1.2.4 are available at:
http://go-mono.com/archive/1.2.4/
[See remaining text…]
If no critical bugs are found after the preview period, these same
downloads will be [...]
Some basic PHP calls for use in Delphi for PHP or pure PHP
I was doing some coding today and couldn’t find some routines I’ve used often in the past. Since I had to search for them, obeying my rule, they get posted here. Maybe they can be of use to others.
Wahoo! I did it! The last part of a WP-DB.PHP for Interbase/Firebird
I knew 9 years of IB/FB experience would come in handy. [ED:wordpress firebird conversion in progress]
[See remaining text…]
wp-db is the mini database abstraction layer for WordPress. It allows you to run WordPress on various [...]
The Python Papers , Volume 2, Issue 1, 2007
This is the complete issue containing Python User Group highlights, interviews, more on coding idioms, and an academic paper on the Firebird Database. (Revision 2)
[See remaining text…]
This paper presents a simple data dump and load [...]
Delphi for PHP - First impressions
Myles Wakeham wrote about Delphi for PHP and firebird issues:
Well I received my downloadable Delphi for PHP today. I haven’t had a huge amount of time to play with it, but there are some very impressive features, but a couple of ‘critical’ missing features for me.
New article about optimization of network traffic in Delphi and C++ Builder applications
Devrace have published a new article “Devrace FIBPlus: Optimization of network traffic in Delphi and C++ Builder applications”. From it you will get to know:
Caching metadata.
Using poRefreshAfterPost option in TpFIBDataSet Options.
Recurrent use of queries.
Client BLOB-filters. «Transparent» packing of BLOB-fields, etc.
ANN: The InterBase and Firebird Developer Magazine #4
The owners of the InterBase and Firebird Developer Magazine iBase.ru and IBPhoenix today agreed to collaborate in producing future issues of the magazine. Under the agreement, free copies of the magazine will be distributed to IBPhoenix Support and Subscription customers automatically in advance of publication.
New Null Guide beta
There’s a new Null Guide beta at
http://www.firebirdsql.org/devel/doc/manual/temp/nullguide/nullguide.html
The following things have been added since the previous beta:
New section “Predicates”, with IN, ANY, SOME, ALL, EXISTS, SINGULAR
(IN was already present but has undergone some changes)
http://www.firebirdsql.org/devel/doc/manual/temp/nullguide/nullguide-predicates.html
- Added to section “Aggregate functions”:
Counting frequencies
http://www.firebirdsql.org/devel/doc/manual/temp/nullguide/nullguide-aggrfunc.html#d0e14798
The HAVING [...]
Firebird Core Engine Development - Activity report for 2006/2007
Developer Progress Reports for Core , DSQL , INTL & Security/Linux Builds (POSIX)
vulcan and firebird merging plan
Dmitry Yemanov today posted to the Firebird-devel list his proposals for merging the Firebird 2 code with the Vulcan code. If you are interested in how it will be done and who will be doing it, subscribe to the list and watch the thread entitled “Merge Proposal”.
Firebird docs - how can you help ?
Rodney Gedda wrote on documentation list
I caught up with Helen this week and she mentioned help was needed
with Firebird documentation. Well, here I am. Let me know if there
is anything I can help out with.
and Paul gave him this answer:
Your helping hand is very welcome. I don’t know how much experience
you [...]
Firebird Embedded and web sites
Can I (Dean Harding)make a simple suggestion:
Do not use Firebird in Embedded mode in a website
Firebird Embedded and web sites
Can I (Dean Harding)make a simple suggestion:
Do not use Firebird in Embedded mode in a website
Embedded Firebird Db on Vista ?
Is anyone using an embedded firebird database on Windows Vista?
[ED: new topic on discuss.joelonsoftware.com]
Damyan Ivanov restarted the linux powerpc port
You can watch the powerpc porting thread on sf.net devel mailing list
UPDATE:firebird started on powerpc (make passed create_db stage so first database was correctly created on that platform)
It seems that, despite the public beliefs, today is my lucky day.
create_db passed on a DEV_BUILD.
SuperServer future - think about it
From Jim Starkey:
I said in a post this morning that I thought a single code base for
superserver and classic was a mistake. I thought it might be useful to
elaborate.
Classic is defined as a set of independent server processors sharing a
database file (or files) synchronized by a lock manager. The lock
manager, in turn, is [...]
FB server is running on mips processor now
I have a FB server running on mipsel now - superserver debug version, in
a chroot over NFS, but anyway, it seems to work at first glance. I was
able to run the script to create our production database.
Is there any regression test I could try to run?
Best regards,
Fabrice Aeschbacher
New FB 2.0 book will be released at FDD
“Firebird 2“, my new book devoted only to the new features of Firebird 2.0 will be released at the Firebird Developers Day Conference, in Brazil at July, 29. The book is written in portuguese and will be sold with special price during the conference.