I have not any experience of Firebird, so I can only comment on MySQL.

MySQL is SQL database which is free of charge, except when distributed
together with your Clarion application.
However, the price for their server (with unlimited users) is USD 440,00
which I would call still being free if talking about using it in commercial
application.
And for non-commercial use MySQL is always free.
(For info of their licensing policy visit http://www.mysql.com )

The current "production" version (4.1.18) lacks many features that are more
less standard in other RDBMS - including Firebird. MySQL does not have
triggers or stored procedures - just to mention the most important missing
things.
All these will be implemented in the next version (5.0.00) of MySQL, which
is
currently under development. When browsing their website few weeks ago, I
found
there nice tool called MySQL Administrator. You can do most of
administrative
tasks with it, even scheduled backup of your database(s). For data
manipulation
there is number of utilities available - also for free.

Clarion does not have "native" MySQL driver, same is for Firebird.
FM3 by Capesoft supports MySQL, and makes ie. conversion from TPS very easy.
Firebird is not supported, but as per postings recently in this NG they have
it in the pipeline.

--
Timo Lahtinen
Helsinki Finland


"Werner Butterworth" <wb@...> kirjoitti viestissä
news:A921.1081201020.16996@......

> C5 ABC
>
> I'm about to start fiddling with SQL but I'm not sure which of the two is
> best to use with Clarion. I have started fiddling with Firebird as this is
> most mentioned in the ng and seems to be a good choice. I would like to

know

> what the most popular or better one would be. Any suggestions would be
> appreciated.
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.648 / Virus Database: 415 - Release Date: 2004-03-31


[Non-text portions of this message have been removed]