[fpc-pascal]Databases and FPC

[James Mills]

On Mon, May 05, 2003 at 07:11:49PM +0200, Michael Van Canneyt wrote:
> 
> 
> 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.

Firebird seems overly complex for my purposes, but then again perhaps I
haven't read enough information. I have to tell you all I have never
worked with databases much before except years ago using MS Access and
SQL, and mySQL on Linux.

cheers
James

> 
> Michael.
> 
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-pascal