Category: Technical Articles
Technical articles, How-tos, guides, etc.
Building firebird extension for #php 5.3.x on windows
Short notes on how to compile Firebird extension (called interbase) on Windows 32 bit (the same ideas can be used for 64 bit too)
I have used Visual Studio c++ compiler 2008 (aka Vsc 9)
ps:
By default php developers on windows don’t have the firebird extension enabled in php 5.3.0 and the required dll (fbclient)
we try to fix that the vodoo spell is to kill one compile firebird stable with vsc9 and send them the instructions how to do the kill compiling but we have the recipe for that too and maybe we can kill compete with microsoft sql server on windows too if they let us
“The memory barrier” – post mentions Firebird
Wings of Wind blog just posted the results of polls about Delphi 64bits and 4GB support. In the workarounds section, he mentions Firebird:
Use the 64-bit version of Firebird configured to keep the data in memory. It has the advantage that you have a full blown 64-bit SQL server (so, no AWE paging etc.) […]
Read the full post.
IBDeveloper magazines now on-line
From Firebird Surgeon blog:
As you know, IBSurgeon was a publisher of “The InterBase and Firebird Developer Magazine” (or shortly IBDeveloper) in 2005 and 2006. There were 4 issues which attracted a lot of interest (up to 20000 of readers) but at that time there was no way to monetize it, so IBSurgeon decided to close the magazine as a redundant line of business.
Now we’ve put all issues of IBDeveloper to Scribd for easy reading and full text search indexing. You know, there are still “all times greatest hits” articles and materials (like one regarding locking in Firebird by Ann W. Harrison in Issue 2).
Read full post and check the magazines here.
Firebird and #vb.net – Howto solve datagridview issue after new record editing
The issue, typical in Firebird, consist in the fact that, after you insert a new record with an autoincrement field in a datagridview, we have to exit from the application to be able to edit the new inserted record.
To solve this issue you have to proceed this way
Cast Date to Integer, like Delphi does.
Today I needed to convert a Delphi/Pascal code to Firebird PSQL. Part of the code used the integer value of a date to do some calcs. First, I tried to use Firebird CAST to convert a Date to Integer, but FB can’t do this type of cast (anyway, I’m not sure if the result would be the same as Delphi, since I don’t know what starting date Firebird uses for internal storage). So, the solution was to create a workaround and subtract the date from 30-December-1899 (Dublin Julian Day), ie:
my_int_var = current_date – cast(‘30.12.1899’ as date);
The above line will return the integer value of the today date, as Delphi/Pascal would do. In other words, it is the number of days since 30-Dec-1899.
Great presentation from Alex Peshkoff regarding Firebird Security is published
Great PPT from Alex Peshkoff (Firebird Core developer) regarding Firebird Security is published: http://bit.ly/3ITICI
via ibsurgeon’s tweet
C++ Wrapper Library for Firebird Embedded SQL
This article is devoted to the Embedded Firebird database usage and also development of C++ wrapper of this database.You can reply on code project for this article.If you wonder :”What is the difference between his wrapper and IBPP?” here are some answers
Firebird 2.1.3 – Recommended update
Douglas Tosi wrote about why is recommended to do the upgrade in a short like review (If you don’t want to parse the changelog yet)
Yesterday Firebird 2.1.3 was made public. As with all maintenance releases its focus is stability. A number of bugs are fixed and it is a recommended update for everyone using older versions of the 2.1 series
Via twitter status post
New article: Graphs in the database, SQL meets social networks
Lorenzo wrote another impressive sql article :This morning a new article of yours truly has been published on the TechPortal. The title is Graph in the database: SQL meets social networks, and it’s a natural sequel to my talk aboutTrees in the database.
You will learn how to retrieve linked nodes, and how to answer some of the queries typical of social networks like LinkedIn, Facebook, or recommendation systems (“You might also know/like”, “How you are connected to XY”, …).