Tip : How can i find size of table in firebird?
You get an approximate value by running gstat and then check out the
Data pages value for the table. Multiply that value with your database page size. This is the allocated space on disk.
Category: General news
Firebird related news
Multiple Firebird servers in #Ubuntu #Linux
In this tutorial I will show you how to install multiple separate Firebird 2.1 servers on a single Host
Important! Firebird 2.5 Classic/Superclassic on Linux
From www.firebirdsql.org:
It has been found that V.2.5 Classic for Linux has problems with AST delivery if used with glibc 2.5. With glibc 2.7 it works properly. The situation with glibc 2.6 is unknown for now. If your glibc version is lower than v.2.7, it must be upgraded before using Firebird 2.5 Classic/Superclassic.
Firebird used in AVG Internet Security Business Edition 2011
here is the mention.
Istallation proved very easy, and intelligently chosen defaults allowed us simply to press ‘Next’ through most of the wizard. A Firebird database is provided
Getting Started with FireAlarm a server performance and health monitoring tool written in #Java
FireAlarm is a server performance and health monitoring tool for the Firebird RDBMS. It is written in the Java programming language and released as open source.
This is a quick guide to the FireAlarm API, which shows how easy it is to register FireAlarm Database Aliases and to add and configure Alarm instances.
#ilovefs , #ilovefirebird:I Love Free Software Campaign , I love Firebird
Today is the day when you can share your love towards Firebird and the Free Software world (libreoffice , qt , debian)
There are lots of ways to declare one’s love… Here are some ideas on how you can go public and proclaim your love to Free Software/Firebird
- Send active Free Software supporters a message thanking them for their work
- Microblog about how you love Free Software, and tag those messages with #ilovefs/#ilovefirebird.
- Hug a developer (ask permission first!)
- Buy your favourite developer a drink. Or buy someone else a drink and while savouring it, tell him/her about your favorite Free Software application!
ps whey you search for i love firebird i have this example of trim function 🙂
select trim (‘la’ from ‘lalala I love Firebird’) from rdb$database
— returns ‘ I love Firebird’
Average of Firebird users DB sizes
In a recent survey for the next Firebird Developers Day in Brazil, one of the questions was about the average size of the participants (and/or their customers) databases. A total of 344 people answered, and the result can be seen below:
In general, your (or your customer’s) database has…
 |
|||
| Percent | Count | Answers | |
|---|---|---|---|
|
|||
|
20.3% | 70/344 | up to 500MB |
 |
31.1% | 107/344 | up to 2GB |
 |
20.9% | 72/344 | up to 5GB |
 |
17.2% | 59/344 | up to 10GB |
 |
10.5% | 36/344 | more than 10GB |
|
|||
| 100.0% | 344/344 | Summary | |
|
|||
PS: Note that this survey was directed only to people who intends to participate in the next Brazilian FDD edition.
OMEGA SYNC: Effortlessly compare and synchronize your local or remote databases.
Omega Sync can compare and synchronize both database schema and table data.
You can even synchronize data of heterogeneous databases (for example, compare your local Firebird database with a MySQL replica on your web site – and synchronize all the differences in just a few minutes).
http://www.spectralcore.com/omegasync/
Flamerobin rebuild for #fedora linux 15 and 16
Philippe Makowski managed to rebuild the flamerobin 0.9.2 package for fedora 15 also for the 16 version too .
There were some issues with new strict compiler rules in fedora similar with what happened when we tried to compile
flamerobin with clang
Hero of the day :Jiri presented a firebird talk at #p2d2
He was afraid that it will be his last tweet but he survived presenting to the postgres people