Author: mariuz

http://wiki.ubuntu.com/Mariuz

Firebird 2.0 (and up) Maximum Number Of Records In Table

Leave a comment
Maximum number of records in table in Firebird is depended on record_size and page_size.
Here is a spreadsheet in Open/Libre Office Calc (for all calculations look at sheet 1, sheet 2, sheet 3 and sheet 4):
I would like to here from developers from Firebird is this calculations are correct.
Here is the original blog post , and here are the related threads on firebird-support

Tips:How to Identify if your run 64 bits of Firebird engine

Leave a comment

Question: I have a requirement to Identify whether a Firebird system is 64 bit or not,in order to know whether to deploy a 64 bit UDF or a 32 bit UDF. Is there any thing to give the correct information?
The best Answer: Identify this information this way:
fbsvcmgr service_mgr -user sysdba -password masterke -info_server_version -info_implementation

see the manual for more  : http://firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-util-svcs

On ubuntu/debian 64 will give :
fbsvcmgr service_mgr -user sysdba -password masterke -info_implementation | grep 64
Server implementation: Firebird/linux AMD64

or you can count if the 64 string is present with -c in grep (notice that there is no need for username and password)

fbsvcmgr service_mgr -info_implementation | grep -c 64

1



 

Jiří Činčura Blogged: Tokenize string in SQL (Firebird syntax)

Leave a comment

Few days ago I wrote “Some thoughts on denormalization” post. Though concatenating data to one string is easy with there introduced function, splitting it back could be harder. I left it as exercise, but I feel, to make it complete, it’s good to show one possible implementation.

Here’s one I came with today (using Firebird syntax, however it’s almost pure SQL), quickly. It’s something I created from start to finish in one row and sure for some cases it could be optimized.

 

Amazon’s EC2 Micro Instance and Firebird

Leave a comment

Jiří Činčura Blogged about his impression on Amazon’s microinstance :

Few months ago I was playing with different VPS providers and I was also considering deploying the application to some “small instance” cloud. I came to Micro Instance of Amazon EC2. Part of the solution I was doing research for is Firebird database and because the pricing looks good, I tried to install Firebird (2.5 SuperClassic) on this instance.

TURBU – The Ultimate Rpg BUilder is switching to Firebird as storage mechanism

Leave a comment

From the about box :

TURBU is an RPG-building engine currently under development. It is being written by Mason Wheeler, and will be able to create and edit RPGs with a wide variety of customizable options, including importing existing project from RPG Maker 2000 and 2003.

And here is the blog post and the message With several advantages listed

I’ve added a bunch of new Event Builder editors, plus music-playing capabilities, but probably the biggest change is to the project database. I’m changing the storage mechanism from the old, built-in file format to a Firebird database.

1 … 131 132 133 134 135 … 298