Shared page cache ready to be commited in firebird 3.0

Vlad Khorsun wrote about the Shared page cache implementation in 3.0 :
After more than a year of development, testing, switching on another tasks and returning back i’m ready to commit shared page cache implementation into trunk.
I consider it stable enough to be committed into SVN. It runs some stability tests more than 10 hours for longest run and many shorter runs at different configurations.
Here i want to do overview of changes, what was tested, what was not, and what
is work in progress.

You can read more about Shared page cache in the Firebird 3.0 presentation
Update:Feature commited into trunk

1 Star2 Stars3 Stars4 Stars5 Stars (17 votes, average: 5.00 out of 5)
Loading...

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

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
1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 5.00 out of 5)
Loading...

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

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



 

1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 4.20 out of 5)
Loading...

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

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.

 

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Amazon’s EC2 Micro Instance and Firebird

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.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

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

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 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

1 205 206 207 208 209 485