[fpc-pascal]Databases and FPC

[Michael Van Canneyt]

On Mon, 5 May 2003, James Mills wrote:

> On Mon, May 05, 2003 at 01:26:39PM +0200, Jilani Khaldi wrote:
> > >I dunno if any of you have ever written an entire IRC Services in FPC
> > >before, but for the past few months I've been porting my 5 year old
> > >windows (delphi) version to linux.
> > >
> > >I'm wondering about databases however... The old windows version used to
> > >use a flat-file database to store nickname and channel registrations,
> > >the port I'm writing also uses the same thing. However this obviously
> > >will be slow if say an IRC network has 10,000 nicks/channels etc...
> > >
> > >Is there anything anyone would suggest I do ? I have only a couple of
> > >ideas, perhaps you might have a few more than I...
> > Try the great Firebird (InterBase fork) http://www.ibphoenix.com It is free, open, robust and works fine with FPC
> > and Linux.
>
> lol, thanks. You sound like you're the person that wrote it :P
> Was originally thinking of re-writing all my database code and using a
> mysql layer, oh heck I dunno what I"m going to do. I'll check our the
> url you suggested however...

Nothing of what the original poster said is exagerated. Forget MySQL;
MySQL is a simple filemanager supporting SQL syntax - that is why it
is so fast.

Firebird is a real relational database system (in industrial sense),
supporting stored procedures, views and so on.

Michael.