Favorite Database

[glencooley.com]

Good post Paul that was worth much more than 2 cents!!

I agree SQL/DDL is one of my favorite languages as well and being a standard it means that all the core stuff works across the board its only the nuances that you have to rewrite it for datatypes, functions etc.

It is interesting to see the wide ranging interpretations of database though. From a computing science point of view almost anything is a database to a degree but from a top down aspect it seems that the common consenus is that a database is the sum of its IDE, API and tools as apposed to the formatted standard of stored data.

 

[Page]

This will make you all smile: http://www.neopoleon.com/home/blogs/neo/archive/2003/09/29/5458.aspx

Thanks

If you have not looked at it yet - it WILL make you smile - worth the detour - only simple cartoons nothing to taxing for a Friday - just scroll down.

 

[RobertSagoyan]

I think MSSQL is very good database.
Store procedures/Events works good.
Speed of selecting rows are very fast for my opinion.

I also work with postgres and mysql. Both are good dbs.

 

[n3w813]

Depends on what is being used by my favorite is probably sql server 2005

 

[watchman]

SQL Server, MySQL

 

[tommy]

SQL Server 2005/8 and oracle 9 upwards.

 

[DBMark]

My favourite database? Has to be Oracle (despite the price). It's famed for its stability, speed, portability and extensive procedural capabilities. For the larger enterprise this still has to be the preferred option. However I must admit to becoming more enamoured with Mysql, now that it has the capability to utilise sql subqueries, and store procedures and triggers (these facilities and more, were not available on version 3.23.) Add in the fact that Mysql (when administered correctly) is very fast, and you can use it on many platforms, then Mysql has to be a top contender. I've not used MS-SQL but I think the downside with this database is you need Microsoft operating systems on which to function ie it's not portable like other databases.

 

[dan11]

i find mysql and php work well together .. and the cost is very low!!