Worth on SWiK

Store server generated values in Entity Framework in Firebird

Mon, 11 Aug 2008 09:13:35 -0700

Server generated values - not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.

Forrester: Open source databases should be part of every database management system strategy

Fri, 01 Aug 2008 11:10:53 -0700

Open source technologies continue to make headway in the enterprise, and none more so, perhaps, than open source database management systems (DBMS). Read full story here.

Setting up ColdFusion and Firebird

Wed, 30 Jul 2008 07:08:44 -0700

After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.

Another great new feature of Firebird 2.5

Wed, 23 Jul 2008 08:53:20 -0700

Other than CREATE USER something really valuable has been added, the ability to query other databases.

Firebird SuperClassic - Another option

Tue, 22 Jul 2008 07:55:22 -0700

Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0. Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic. Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for [...]

The Darwin Race of Languages

Fri, 27 Jun 2008 11:08:42 -0700

The Darwin Race of Languages is a “competition” started by Bart Roozendaal to check what programming language is better. It seems that they will choose a kind of application that need to be developed, and participants will use the language of their choice to code it, and in the end, they will choose which one [...]

Firebird 1.5 SQL Temporary Reference Update

Thu, 19 Jun 2008 01:18:50 -0700

This guide documents the changes made in Firebird 1.0 and 1.5 SQL since the fork from the open-sourced InterBase 6.0 codebase. Here is the Pual Vinkenoog’s announcement on firebird-docs list Just uploaded a Firebird 1.5 SQL Update Reference to this temporary location: http://www.firebirdsql.org/devel/doc/manual/temp/ You [...]

Firebird qli.exe scripts documentation

Fri, 13 Jun 2008 06:18:21 -0700

Does someome have any links or documentation for qli.exe? I recently used qli.exe scripts for fixing BD structure corruption as described in http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr , since then and I’ve been searching for information about qli commands or scripts but it seems not to be so much information about it. Near the bottom of this page is a download link for the qli syntax [...]

Open Source Awards Accepting Nominations - Firebird mention

Sun, 08 Jun 2008 10:02:42 -0700

Is open source software a part of your daily computing life? Now is your chance to sound off about it. Sourceforge.net, an online community that hosts open source projects, is accepting nominations for its annual Community Choice awards. [ED:Read the rest of the article here At the end Firebird is mentioned for the last year awards] . It’s [...]

Firebird Experts Forum - fastest forum i have ever seen is powered by firebird

Fri, 30 May 2008 02:43:50 -0700

The forum here is created using the phpBB Software, available on http://www.phpbb.com. It is a great and free Open Source Solution and since version 3, it has full support for firebird. This installation uses apache 2.0, phpBB 3.01, php 5.21 and firebird 2.1 on windows 2003 server. If you never installed a WAFP Server (WIndows+Apache+Firebird+PHP) on [...]

remember to upgrade to firebird 2.0.4 or firebird2.1

Fri, 23 May 2008 00:15:52 -0700

Stack-based buffer overflow in Firebird before 2.0.4, and 2.1.x before 2.1.0 RC1, might allow remote attackers to execute arbitrary code via a long username. http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-0467 Security vulnerability in Borland InterBase A security vulnerability discovered early this year in open source database Firebird also affects Borland’s InterBase. The security vulnerability allows …

Firebird ports for Intanium and hppa to be released soon

Fri, 23 May 2008 00:15:52 -0700

If you watch the debian building logs for different architectures then there are a few ones left to be done , Itanium , Hppa and Alpha (dead one) http://buildd.debian.org/build.cgi?pkg=firebird2.0 and seem that this will be solved very soon

CodeGear sold to Embarcadero

Wed, 07 May 2008 07:17:57 -0700

Today was announced that Embarcadero is buying CodeGear (Borland division responsible for programming tools, including Delphi and InterBase).

Get to know FB in 2 minutes - Updated!

Mon, 21 Apr 2008 09:21:41 -0700

With the recent release of Firebird 2.1 final, it is time to update the “Get to know Firebird in 2 minutes” paper. English (PDF/HTML) and Brazilian Portuguese is already up to date (revision 1.2). You can help translating/updating the document to other languages. [Upd] German, French and Czech versions are now updated too.

Infovark is using firebird

Sun, 20 Apr 2008 23:18:41 -0700

We’ve been using Firebird as infovark’s SQL database for several months now.

Compare it yourself

Sun, 20 Apr 2008 08:18:15 -0700

This slides are from Michael (Monty) Widenius, original MySQL author, and talks about the future of MySQL, problems, and why he thinks MySQL is not really Open Source. Interesting read to be compared with Firebird.

Installing firebird 2.0.x client with screenshots

Wed, 09 Apr 2008 01:53:04 -0700

When configuring a Windows machine for use by the Evolution™ payroll service-bureau system, a common step is installing the open-source Firebird database software; this Evo Tip details the process.

NULL Handling in SQLite Versus Other Database Engines

Sat, 29 Mar 2008 09:50:43 -0700

The goal is to make SQLite handle NULLs in a standards-compliant way. But the descriptions in the SQL standards on how to handle NULLs seem ambiguous. It is not clear from the standards documents exactly how NULLs should be handled in all circumstances.

xampp and firebird

Sat, 29 Mar 2008 00:50:00 -0700

How to enable firebird support in xampp http://www.llodra.es/archives/93

Going distributed with Plastic 2.0

Fri, 28 Mar 2008 07:50:45 -0700

One of the most important new features in Plastic 2.0 is the distributed system. Today I’m going to talk about the set up I’m using to work from my laptop, disconnected from any network, and how I use the distributed system to synchronize changes back and forth.

New Firebird packages fix several vulnerabilities in debian

Thu, 27 Mar 2008 08:51:20 -0700

This Debian security advisory is a bit unusual. While it’s normally our strict policy to backport security bugfixes to older releases, this turned out to be infeasible for Firebird 1.5 due to large infrastructural changes necessary to fix these issues. As a consequence security support for Firebird 1.5 is hereby discontinued, leaving two options to administrators running a Firebird database: I. [...]

SQL Compact Edition or Firebird Embedded ?

Thu, 20 Mar 2008 08:49:23 -0700

I need to choose an embeded database for my Windows desktop application programmed in C# .NET.

Firebird JDBC and OOo 2.3

Wed, 19 Mar 2008 08:49:56 -0700

I having been trying to connect (without success) to a Firebird server from OOo 2.3.[ED:but in the end it was solved by using this guide and it was fast too ]

firebird2.0 package is now included in debian etch backports (stable)

Tue, 04 Mar 2008 03:46:35 -0800

firebird2.0 package is now included in debian etch backports (stable) http://packages.debian.org/etch-backports/firebird2.0-super for using the etch stable backports read this reference firebird 2.0 package is also included in testing http://packages.debian.org/lenny/firebird2.0-super and unstable http://packages.debian.org/sid/firebird2.0-super

Firebird Developer Progress Reports for this year

Thu, 28 Feb 2008 09:46:53 -0800

You can read the progress reports for this year on various engine development areas Dmitry Yemanov, 2008-02-01 Vlad Khorsun, 2008-01-27 Adriano dos Santos Fernandes, 2008-01-27 Alex Peshkov, 2008-02-02

Playing with Django and Firebird

Thu, 14 Feb 2008 03:44:46 -0800

I’ve been messing around with Django for a while now and having fun. It reminded me of why and how I got started in this field. [ED:There is an nice firebird mention ] Using Apache, Webware and Firebird as the database I set out to build something. Firebird? Yes anything to avoid the MySQL bandwagon. I couldn’t say [...]

ADA (Autonomic Database Agent) - new project

Mon, 04 Feb 2008 23:40:02 -0800

ADA (Autonomic Database Agent) is a project that shows how to use AC concepts using AC techniques to implement autonomic behavior on a DBMS, a very popular kind of application, widely used nowadays and also a field where exploring autonomic concepts will show clear results. [He is using firebird for this autonomic unit]

FirebirdSQL Reference - up again

Sat, 19 Jan 2008 16:52:54 -0800

http://home.lsces.co.uk/lsces/wiki/index.php?page=FirebirdSQL+Reference Has MySQL updated to 6.0 and PostgreSQL updated to 8.2. Some pages will request a login. That is because we are using private information to provide them and can’t allow access in the public domain.

Sun buys MySQL

Thu, 17 Jan 2008 05:48:29 -0800

Sun Microsystems Announces Agreement to Acquire MySQL. More information here.

Origin of the firebird/interbase port 3050

Sat, 12 Jan 2008 02:10:08 -0800

Here is the question on Firebird-Support group > How did port 3050 get selected as the “gds_db” service port. Was it > chosen arbitrarily or is there some interesting story behind it? Maybe > Jim Starkey’s phone number in Groton? No story there at all. It was just a number that nobody else seemed to be using at [...]