ANN: IBX for Lazarus and Firebird – Call for Testers
|
Author: mariuz
http://wiki.ubuntu.com/Mariuz
#GoLang and Firebird first steps and more details soon
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
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):
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
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)
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.
Firebird Web redevel : Next round of web-site testing – Documentation
|
We are approaching the end of web-site development process.
Now we need attention of beta-testers for Documentation section Please look through Documentaion section, try to find your favorite documents/guides/articles and report found issues to the tracker Thanks in advance. Regards, |
Someone is studying Firebird on #Maemo / #Meego tablet
Portuguese to English translation for this tweet picture
http://twitpic.com/4sbzw7
As I’m still awake, I’m studying a bit of #Firebird on the tablet.
Firebird and booleans in #Delphi + DBX one more hurdle : writing back
I wrote my last post about enabling booleans in Firebird after several hours of poking around in database code trying to get my query to execute without errors. Once it worked, everything seemed great. But I missed an important step: I hadn’t tried to write anything back to the database yet.
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.