The third edition of the conference will happen on July 29th, 2006 at UNIMEP (in Brazil). The expected audience size this year is from 500 to 750 people. This is mostly a portuguese-speakers conference, and an unique chance to reach directly hundreds of potential customers. Paying your sponsorship until 31/March you get 20% discount! Contact fdd.at.firebase.com.br to get the conference mediakit with all the information, including sponsorship plans and prices.
iSCSI is making network shared storage an increasingly popular choice in the midmarket. A $15K device can offer 2.5TB shared storage to 6 servers. Now that looks remarkably like the architecture of the VAX clusters of old. Perhaps it is time to resurrect the Firebird VAX clustering code.
Read more here
FLAPS is FLAP with Ssl (that is why S is at the end of word)
FWAP is an acronym for the combination Microsoft Windows, Apache, Firebird and one or more of Perl, PHP and Python. It is modelled after the more well-known FLAP, referring to the all-open source/free software approach which uses Linux instead of Windows.
FWIP is the WIMP equivalent (alias) with firebird used instead of mysql
Shutdown mode prevents everyone other than SYSDBA and the owner from
This allows you to safely run metadata scripts etc and be sure no-one
else is connected while this happens.
This statement is base on my experience, so maybe it’s not true for you. Firebird version that I know for the first time is 1.0 version, since then I fall in love with Firebird (FB).
Read more on this blog
Aviram Jenik and Damyan Ivanov discovered a buffer overflow in firebird2, an RDBMS based on InterBase 6.0 code, that allows remote attackers to crash.
The old stable distribution (woody) does not contain firebird2 packages.
For the stable distribution (sarge) this problem has been fixed in version 1.5.1-4sarge1.
For the unstable distribution (sid) this problem has been fixed in version 22.214.171.12470-3
We recommend that you upgrade your firebird2 packages
In the latest Edition of IBExpert, we added some new modules, on is
a database script with a simple sales database, that creates its test
data from a stored procedure.
now i had some time to test it against fb153, fb2b2 (and ib751)
What does it do: first it creates a almost empty database with just
some entries in helptables. after the database is created, you have to
start one procedure and wait for the time it takes.
the procedures creates a customer table from the strings in the
helptables, it creates products from other strings, it creates
order header and order lines. based on that some trigger also
write a sales history etc.
all in all you can create a testdatabase as large as you need, because
the procedure called initall gives you the possibilty to fill a
parameter with an integervalue, that defines the size of the final
database. when you use the value 10000, then 10000 customers are
created, 10000 articles and a lot of orders etc. The Testdatabase
is before starting the procedure created with 16k pagesize and the
cache buffers were changed to 50000.
for the test i used a value of 100000 so the final database that is
created has a size of about 200MB.
While executing this procedure with the parameter 100000, it starts
about 5,200,000 Selects, 800,000 Updates and 1,700,000 Inserts, all
in all about 7,700,000 Operations.
now the time when starting this on a dual core AMD Athlon 64 x2 3800+
with 2 GB RAM.
using fb153: 486 Seconds (not bad, about 16,000 Operations per second)
uninstalled fb153, installed fb2 beta 2: 244 Seconds!!!!!!!!
Wow, not that i would say it was slow on fb153, but the results on
fb2b2 are impressive. About 31500 Operations per second.
Congratulations to the developer Team. they made a brilliant job.
Starting with the next IBExpert Version, the Demodatabase will be
available also in the trial version and in the personal edition.
if you would like to test it now on your machine, just Install
IBExpertLive (download details on www.ibexpert.com). I have added
the demodatabase in my session “Holger Klemt – Server Performance –
How to make your application run faster (FBC2005)”, so you can connect
to view this session and press on the left side on “download session
files” to get the installer.
p.s.: did i mention the result from ib751? 838 Seconds
What’s new in Data Comparer 2005 for InterBase/Firebird version 1.1?
- New BLOB viewer tool is implemented
- Increased speed of data comparison
- Ability to view the connection information is added
- The new option “Use only compare key for where clause” is added for sync script generation
- The new option “Add computed and read only fields to the new table” is added when exporting compared data to a new table
- Ability to specify required client library is added (InterBase/Firebird)
- The new option “Commit after XXX records” is added to add COMMIT statement after specified number of altering SQL statements
- Color highlight of non-identical records is added
EMS Data Comparer for InterBase/Firebird is a powerful and easy-to-use utility for data comparison and synchronization. You can view all the differences in compared tables and execute an automatically generated script to eliminate these differences. Flexible customization of the comparison and synchronization process will enable you to select tables and fields for comparison and tune many other options. Data Comparer for InterBase/Firebird includes a graphical wizard, guiding you through the data comparison and synchronization process step by step, and a command-line service for synchronizing data in one-touch.
You can learn more about EMS Data Comparer 2005 for InterBase/Firebird at: www.sqlmanager.net/products/ibfb/datacomparer
You can download EMS Data Comparer 2005 for InterBase/Firebird at: www.sqlmanager.net/products/ibfb/datacomparer/download
The 2006 SourceForge.net Community Choice Awards.… time to vote for your favourite database.