Firebird News

Firebird slow? Well, maybe it is Windows fault.

February 17, 2011 Cantu One comment

So, you just moved to that new cool server, with lots of RAM, Windows and Firebird 64bits, but suddenly you found that Firebird performance gets worse and worse. When you check TaskMan, you see that 99% of the RAM is being used (and so, swap is going on). If you close Firebird process, RAM usage seems to be back to normal. Weird, uh?

First, you may think this is the common problem of Classic/SuperClassic with too many connections and crazy buffers value… but, you checked all the settings, and everything is ok.

If this happening to you, take a look again in TaskMan (or Process Explorer), and check how much memory the OS Cache is consuming. If you find something abnormal, like if it is consuming almost all of your physical RAM, you should take a look at this: http://support.microsoft.com/kb/976618/en-us

(2 votes, average: 5.00 out of 5)

Firebird usage with SchemaSpy – Java based Graphical Database Schema Metadata Browser

February 17, 2011 mariuz Leave a comment

On devshed firebird forum someone asked if anyone used SchemaSpy with firebird , and later he got it working , here is the command line option (after installing jaybird.jar)
1) Download the ZIP file for jaybird
2) unzip it
3) Copy the file jaybird-full-2.1.6.jar into a convenient directory
4) specify the full path to the .jar file when starting schema spy

java -jar /home/java/schemaSpy_5.0.0.jar -t firebird -db /var/lib/firebird/2.1/data/employee.fdb -s schema -u SYSDBA -p ******* -o /home/firebird/ -port 3050 -host localhost -dp /home/user/jaybird-full-2.1.6.jar

ps:that is a single line

(4 votes, average: 4.75 out of 5)

Firebird used in AVG Internet Security Business Edition 2011

February 17, 2011 mariuz Leave a comment

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

(3 votes, average: 5.00 out of 5)

Firebird 2.5.1 Snapshot is now in #Debian experimental

February 17, 2011 mariuz Leave a comment

For people who want to live on the edge , there is a new upload in experimental for 2.5 release branch

[See remaining text…]

(1 votes, average: 5.00 out of 5)

Database Workbench 4.1.1 released

February 17, 2011 Martijn Tonies Leave a comment

Ladies, gentlemen,

Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:

” Database Workbench 4.1.1 Pro ”

This release includes the FREE Lite versions for InterBase, Firebird
and MySQL.

A bugfix release that fixes a possible crash in 4.1.0

For more information, see here.

Click here for the full list of changes in v4.1.1

Database Workbench supports:
– Borland InterBase ( 4.x – XE )
– Firebird ( 1.x, 2.x )
– MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
– MySQL 4.x, 5.x
– Oracle Database ( 8i, 9i, 10g, 11g )
– Sybase SQL Anywhere ( 9, 10, 11 and 12 )
– NexusDB ( 3.0 and up )

(1 votes, average: 5.00 out of 5)

(2 votes, average: 5.00 out of 5)

#ilovefs , #ilovefirebird:I Love Free Software Campaign , I love Firebird

February 14, 2011 mariuz Leave a comment

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’

(No Ratings Yet)

Firebird used on a site with 1 Million users / day

February 14, 2011 mariuz Leave a comment

Q:What kind of system is this? .The response is on Firebird-support

Monitoring software with also web access by many many users ~1 000 000
They do something which need transaction and some select(reports) which “not need” transaction
but in transactional database select also start short transaction then i can not remove it creation..
1 000 0000 x 10 queries per day i got 10 000 000 transaction+ system self generate 8 000 000 transaction per day (to
storing/updating/computing.. data)
and Forced Writes are ON but database work on some not mechanical device like normal HDD and corruption is reduced to minimal possible but this transaction counter do may problem :/

Karol Bieniaszewski

(7 votes, average: 5.00 out of 5)

Average of Firebird users DB sizes

February 14, 2011 Cantu Leave a comment

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.

(4 votes, average: 5.00 out of 5)

Virtual Laboratory portal uses firebird

February 12, 2011 mariuz One comment

Some time ago I’ve written a portal in pure PHP for controlling test laboratory of C# applications. The whole testing process is based on a framework of our own production.

(4 votes, average: 5.00 out of 5)

« 1 … 215 216 217 218 219 … 485 »