Berend
Thats interesting, Version 8 of PostgreSQL addressed one of my main
concerns, Windows native version.
And from what you say they have eased the storeproc returning a dataset
issue (before it was possible but difficult) this
is an oversight on their part as many developers use this
functionaility, but as they have multiple script languages (and a
Transact SQL like one)
you would think making it more MS SQL like would be advantageous (I
think they targeted oracle more)
One gotcha on MSSQL (with v7 I haven't checked recently) is case
sensitivity, If you turn it on then all your object names
become case sensitive, so you can break your whole system if it was
developed case insensitively (as most are).
I'll watch with interest what happens in the next 12 months as tests
are coming out that suggest that MySQL degrades under
high loads and PostgreSQL may be 'faster' in these situations, MySQL may
be suffering from 'tack on disease' ie as it
gets all the features it didn't have it could lose its hyped advantage -
raw speed
Neven
Neven> Berend How do you rate the following "free" databases
I have to note that I'm talking about FireBird 1.5 here, haven't used
2.0 (none of my customers use it).
Ease of programming:
MS SQL Express
MySQL
PostgreSQL
Firebird
(just look through what hoops you have to go through to write a
procedure that returns a data set, i.e. the result of a select
statement)
SQL language expressibility (built-in functions, language power):
PostgreSQL
MS SQL Express
MySQL
Firebird
Optimiser quality:
MS SQL Express
PostgreSQL
MySQL
Firebird
Administrative burden:
all similar
- --
All the best,
Berend de Boer
PS: This email has been digitally signed if you wonder what the strange
characters are that your outdated email client displays.
PGP public key: http://www.pobox.com/~berend/berend-public-key.txt
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.8 <http://mailcrypt.sourceforge.net/>
iD8DBQFGAxiqIyuuaiRyjTYRAgTjAKDW9g/fi8305nWeLFYim41GxVPg3QCaAqYG
9+ktHs7v5mmbc97JumooOAo=
=rHOh
-----END PGP SIGNATURE-----
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
