WITH RECURSIVE example with Firebird 2.5.x . Article is in Japanese but you can try to read the google translation
Google translate bar from chrome shows you a better rendering of the page .
Video guide is showing, how to install Firebird Server on a windows platform.
http://www.youtube.com/watch?v=KLg0TuhMUU0
The example uses the latest 3.x version of the ExtJS Library
installed at demo.artesoft.gr/ext . I changed a little the database,
adding a before update or delete trigger to protect the demo account
from accidents.
The database is a firebird 2.1 Superserver, and the server is a CentOS
5.7 64bit with ISPConfig and the demo.artesoft.gr is a subdomain.
Feel free to do whatever you want with the demo as long is up and running.
Turbo Bird is a Firebird Administration tool. It enables you to create new Firebird database, create/modify tables, procedures, views, triggers, generators, roles, UDFs, Domains, and much more. Turbo Bird application is very easy to install and to use.
There are Linux 32 bit, Windows 32 bit, and Mac OS binaries. You can install the source and compile it using Lazarus in any other Plateform that already supported by Lazarus.
I suggest to drop Atkins [for news readers] and start using gmane.org. I use it for several years in FireBase, and it had always been very stable.
We have also archive on mail-archive :
http://www.mail-archive.com/firebird-devel <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-docs <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-net-provider <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-odbc-devel <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-python <at> yahoogroups.com
http://www.mail-archive.com/firebird-support <at> yahoogroups.com
on gmane :
http://dir.gmane.org/gmane.comp.db.firebird.user
http://dir.gmane.org/gmane.comp.db.firebird.documentation
http://dir.gmane.org/gmane.comp.db.firebird.dotnetprovider
http://dir.gmane.org/gmane.comp.db.firebird.general
http://dir.gmane.org/gmane.comp.db.firebird.net-provider
http://dir.gmane.org/gmane.comp.db.firebird.php
http://dir.gmane.org/gmane.comp.db.firebird.python
Update : Firebird support archive and NNTP is back on gmane
We have this question on serverfault and the answer is in that thread too :
I have a server with 16 cores. What do I set the CpuAffinityMask to?
1111 1111 1111 1111 is 65535, should I put 65535?
Also, how to I configure the SuperClassic server?
This is for Firebird 2.5.
I recently had reason to revisit transaction management in our application. The application makes extensive use of data aware grids (TDBGrid) and, as I am sure everyone is aware, it is impossible to explicitly manage transactions when you are displaying data in a grid.
Fortunately, IBObjects provides the means to automatically clean up transactions left hanging by TDBGrid. Unfortunately, this isn’t as well documented or as straightforward as I would like. So, after much research using the programmer’s secret weapon (Google) and a few questions posted to the IBObjects support group (thanks Jason) I think I finally understand how it works.
Philippe Makowski did some TPC tests and posted the results at fb-devel:
Hi,
I’m a bit puzzled by the results I get I made test on Fedora 16 with Kernel 3.1.1-1.fc16.x86_64 on LVM2 Logical Volume of 10G
Firebird 2.5.1 Classic
hdparm /dev/vg_tests/testfb
/dev/vg_tests/testfb:
multcount = 0 (off)
IO_support = 1 (32-bit)
readonly = 0 (off)
readahead = 8 (on)
hdparm -Tt /dev/vg_tests/testfb
/dev/vg_tests/testfb:
Timing cached reads: 12976 MB in 2.00 seconds = 6496.46 MB/sec
Timing buffered disk reads: 174 MB in 3.02 seconds = 57.53 MB/sec
database : 1,8G
created with -w20
and buffers 1024
The package is done (imported from debian repository) with minor modifications (ignoring new dpkg version requirement)
The install guide is the same located in the ubuntu wiki
https://help.ubuntu.com/community/Firebird2.5
I’d like to share vital statistics on the activity, growth, and demographics of this group with you.
