Technical articles, How-tos, guides, etc.
Jiri wrote on his blog :
I recently improved the command logging in ADO.NET provider for Firebird. Let me start with little bit of history and then you’ll see the motivation and current improvements.
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
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.
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.
Here are the notes on using Firebird Embedded in Azure
Recently I was playing with Amazon EC2 trying what I could use it for. I was playing with Firebird there as well. But in fact you have virtual machine you can use. So using Firebird there wasn’t that hard. But I got and idea about Azure, because it’s more platform for applications than computers.
Then the VM role was introduced and the challenge was somehow not so challenging.
Also the firebird nodejs driver is updated in the git version please check the changelog and the guide
I have made an example of a master-detail-subdetail application http://mantis.freepascal.org/view.php?id=18491
It uses the Firebird employee-database.There is a bug in the subdetail-handling. But master-detail works fine.
Full Discussion was on lazarus list (asking for a master detail example to study from)
