Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.pascal.delphi.misc > #85

Re: New application developement with Delphi 2011

Show all headers | View raw

On 2011-10-13, alessandro f <a.fedelex@gmail.com> wrote:
> I'm starting application development with Delphi 2011 (i am a
> beginner) and I have to assess what DB to use and the "technology" to
> access the DB (considering tools that will support 64-bit)

If you are free in all your choices, choose firebird/interbase because
Delphi supports that best IMHO, and 32-bit for client apps, consider 64-bit
for server(-side) apps.

> I would like to ask for advice on what DB to choose and what kind of
> tecnology of access
> to choose. I  would like to choose a solution that let me be
> independent from a specific DB and i know that maybe  dbExpress can be
> but it requires a specific expencive licenze version of embardadero
> delphi.

There is also ZEOS. But if you want to do serious database development,
consider getting an enterprise (not pro) license.

> I have suggested solutions such as MySQL, but basically my application
> will not be weboriented. I am also a bit skeptical about  MYSQL which
> is free (but it is not actually free when you resell your software -
> if I understood correctly)

Firebird IS free, and better and better supported by delphi. But IMHO any
real database (firebird, postgresql,oracle,mssql) is better than mysql, with
the first two (firebird and postgresql) being wholly free.

I don't know how well dbexpress supports postgresql though, which is why I
advised firebird.  ZEOS supports both fine.

Aside from the license trouble, Mysql is also horribly versioned, and that
might limit you from upgrading it in the future.

So I wouldn't use mysql unless forced too.

> or MS SQL Express which is free up to 5 users ( that should be enough
> unless some rare cases)

I've no experience with express versions, but I unless you seriously
consider updating to the full SQL Server product later, I would use a fully
free version like firebird (or postgresql), and not some limited version.

> Being developing  from scratch I was thinking to avoid using ADO (or
> other third party tools for  free or not ) that will "bring me" in the
> near future to move e reprogramm maybe to  dbExpress
> In any case i must consider ability of the technology / db to can
> scroll/browse the records

I would choose (dbexpress or something free) depending on your future
outlook. If you are serious about dbexpress, get it now. If that is only a
"nice to have" and theoretical possibility, don't make decisions on it now.

Back to comp.lang.pascal.delphi.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

New application developement with Delphi 2011 alessandro f <a.fedelex@gmail.com> - 2011-10-13 04:19 -0700
  Re: New application developement with Delphi 2011 Marco van de Voort <marcov@toad.stack.nl> - 2011-10-13 11:39 +0000
    Re: New application developement with Delphi 2011 Sven P <svenp@non.commercial.sv..com> - 2011-10-14 11:09 +0200
      Re: New application developement with Delphi 2011 Marco van de Voort <marcov@toad.stack.nl> - 2011-10-14 20:35 +0000
  Re: New application developement with Delphi 2011 "Maarten Wiltink" <maarten@kittensandcats.net> - 2011-10-13 18:02 +0200

csiph-web