Re: Server Database - MySQL?

JamesR wrote:
I've heard MySQL is the best way to go for a server database (in the
free catagory).

Now that MySQL has reached version 5, it finally has support for transactions, triggers, stored procedures, and views. (The default MyISAM storage engine still doesn't support foreign keys, but InnoDB does.) Postgres and Firebird have supported all those things for a while, so you might find better third-party support for those features with those databases than you would with MySQL.

What is the preferred method to connect to this through
Delphi? Using the BDE? - I've heard the BDE isn't very good.

When I first started doing database stuff with Delphi, my only experience had been with Access and MySQL. I knew enough to stay away from Access, so I started looking for ways of using MySQL in Delphi. I came across ZeosLib, which aimed to cover lots of databases, but only supported MySQL at the time.

I wasn't terribly happy with it. (This was a couple of years ago, so I can't really be any more specific than that.) That's when I noticed Interbase and Firebird. (Firebird is the open-source branch of Borland's Interbase.) Delphi comes with IBX, an Interbase-specific set of database components. Since Firebird and Interbase are so similar, IBX usually works fine with Firebird, so that's the setup I decided to use.

Recently, I've been using PostgreSQL. I'm using it with a PHP project intended to run on a Linux server, though, so I have no idea how Delphi might interface with it. Maybe ZeosLib supports it by now.

--
Rob
.

Relevant Pages

  • Re: integration with the non_MS Tools
    ... Personally I didn't like MySQL when I tried it, but that's not the point :-) ... There is already 3rd party support for MySQL. ... > whay we havn't any extra Oracle Feautures, ... You obviously aren't aware of how "Delphi" got its name? ...
    (borland.public.delphi.non-technical)
  • ANN: SQLDirect 5.2.2 with Delphi 2007 support
    ... Delphi 2007 support ... TWideStringField support (MySQL, PostgreSQL) ... The latest trial versions are available at SQLDirect Home. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Interbase not required for CodeGear?
    ... Borland should take a look to Firebird... ... good support for a good free Database is a benefit für Delphi. ...
    (borland.public.delphi.non-technical)
  • My thoughts about Delphi and its future
    ... I only mention the Pascal part of Delphi because ... Cross-platform support. ... VCL framework is in my opinion the single most ... UI controls haven't changed since the beginning. ...
    (borland.public.delphi.non-technical)
  • Re: TChart questions
    ... For some Delphi versions there's an editor help available, ... Steema Support Central ... We wouldn't have even looked at TChart without it. ... If I'm doing a bar graph, side by side, two series, I get the chart ...
    (borland.public.delphi.thirdpartytools.general)