[DUG] SQL 2005 express

[Neven MacEwan]

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
> Delphi at ns3.123.net.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>