Tag: Firebird

..contributing to IT in London since 2002..

Tape backup on CentOS

In this occasion, we have a PHP/Firebird application. We had to backup the database and the code (which includes PHP, HTML, CSS, Javascript files as well as user documents uploaded into a folder). We have created a folder /mybackup/ and created a bash script backup.sh to do the following, using nano command line editor. We …

Paging records in MS SQL Server 2005

After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).

It is simply unacceptable, non-standard, impractical! By the way, you can not use column numbers (e.g. ORDER …

Setting up a web application on CentOS 5.3

Ingredients for our web application are Apache HTTP Server 2.2, PHP 5.2, Firebird 2.1and Oracle 10g Express Edition. Like in any IT project, not everything goes according to plan and there are so many pitfalls; some of which are: Repositories Linux Firewall SE Linux Permissions Using the package manager (Yum) to add, remove and upgrade …

Firebird SQL: The Power of Simplicity

Firebird SQL Server has always been a “proper” database system since it forked from Borland’s famous Interbase. I just love it! In some big database applications, I found that the developers preferred to duplicate a set of tables for probably performance reasons. For example, in most accounting databases, there is a notion of company so …