Does anybody have any suggestions for a good database for an e-commerce web app? I don't need anything that will handle millions of records (I'm anticipating the DB won't grow beyond 200 MB anytime soon), but I'd like it to support things like transactions, stored procs, triggers... I'm looking at deploying on Solaris 8 (or 9), but my development env is WinXP, so I'd like something that would make the transition smoothly.
Cloudscape seemed like it would work, but I was informed by a sales person at IBM that they don't know how to sell anything to individuals or small businesses, only large corporations (well, not so much in those words.. :roll: ). So I thought about mySQL, but it doesn't support stored procs or triggers. I may look at Daffodil, but I'm worried I'll need to fork over too much $$ to have a decent number of concurrent connections.
Am I asking too much? All I want is an inexpensive, stable, feature-rich database!
And it wouldn't hurt if it were platform-independent, scalable and low-maintenance...
I'm asking too much, aren't I?