|
I like Mysql but find I have a need to implement many features that you get with bigger databases like functions and triggers.
Does anyone else use postgres as opposed to MySql and if so why do you use it.
I.E PL/SQL language, triggers functions etc.
Also I have used both DB's and i find it hard to beleive that many claim pg to be slower. Has anyone come across this and if so have they tidied up thier SQL and normalised their tables and benchmarked it again.
What was your outcome.
LASTLY
I have come across a growing trend from some developers that use their databases without much thought. The ethos behind this is that todays DB's are built to be abused (I.E. they can handle large request quite seemlessly). With this in mind i have started to wonder whats going on.
Is it me been older than some and sticking to my old ways (as in database design and management) compared to younger guys who lack DB skills that can get away with it because todays databases are much more powerfull and less likely to fall over should a big query start hitting them.
Its bloody awfull when you have to tidy up a database of 100+ tables that dont seem to have much in common with each other.
Ibbo
|
