At 07:05 AM 22/01/2007, you wrote:

>Hello,
>
>Would someone please give some ideas of which Firebird to choose for
>general database support for a single user appication?
>
>I am confused to see Firebird 1.5 still supported with new releases.
>
>Perhaps someone could point me to information about the differences?

It's not a question of which one is better for your single user
application vs some other deployment model. It's an issue *only* if
you are coming to the table with legacy applications to consider. If
you are starting out with no legacy applications then you have don't
even have to think about it: there would be no reason to choose Fb
1.5.x, because it lacks features you might wish to use.

If you have legacy applications that use Fb 1.5.x and you need time
to work out what you need to do to bring them up to meet the
requirements of Fb 2.0 then you probably want to upgrade to v.1.5.4
when it is released, to take advantage of the backported bug
fixes. Sub-releases do not introduce new features or change how an
existing feature works, so existing application code should not be
affected by stepping up to a new sub-release.

For "information about the differences" read the v.2.0 release
notes. If a new feature is described there, then it is not available
in Fb 1.5.x. If you do have legacy apps then there is a good chance
that the app developer might have used questionable SQL syntax that
is no longer legal in Fb 2.0. On the other hand, if the app was
developed by someone who was well aware of the risks of using sloppy
SQL and has always been careful to avoid it, then there won't be
much, if anything, to do at all.

./heLen