We've been using Oracle, Sybase, MS SQL, DB2 and even other databases in our company, and we've decided to go with - mainly - MySQL. We didn't really have a hard time convincing the management about this decision, since we produced a whole "Open Source"-strategy at the same time, giving some design principles that gives us as much flexibility and scalability as possible.
One of these, regarding databases, is that we want to minimize the use of stored procedures. Stored procedures are of course nice in many cases - they save network traffic, speed up queries, eases the application programmers tasks and so on; but they are certainly not flexible in that you can easily change your database vendor without having to rewrite your code. Therefore, since flexibility means most to us, we've chosen to move as much of the logic as possible up to the layers above the database (for example, in ejbs). Oracle is of course brilliant for banking, finance, government databases etc. - but probably waste of money for web-portals, e-commerce and so on. The result is that it's easy to swap any components in the platform that we're not satisfied with, for example the database. Also, we see that MySQL delivers most of the functionality we want, including hot-backups (using InnoDB), fulltext searches and foreign keys. Armed with systems like linux, jBoss, Resin, ant, junit, xdoclet, middlegen, apache, perl and many more, I believe our platform is about as good as it can be. We are of course lucky NOT to have top-managers who think they know more about technology than the tech-department ;-) Regards, Kent Vilhelmsen Head of Systems Architecture Eniro/Scandinavia Online On Fri, 2002-08-16 at 15:07, Mary Stickney wrote: > > It doesn't suport alot of differnt things.... > it dosent have store procedures , dosent have a complete SQL command set... > > I am using it becasue I am being forced to... > > > > -----Original Message----- > From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:25 PM > To: [EMAIL PROTECTED] > Subject: MySQL vs. Oracle (not speed) > > > > A company I work with is in the process of upgrading its databases from > some > motheaten system to something current. My impression is that they > want to go with Oracle, and I'm not sure if this is based on anything > other than being impressed with the size and presumed quality support > of Oracle. I'd like to encourage them to at least seriously consider > using > MySQL instead. > > I don't think that speed is a huge factor here; we do a lot of XML > publishing > and content management, but at most we'd have several gigabytes of > data and several dozen simultaneous users, so well within the > capabilities > of MySQL. I've looked at various things I could find, like the benchmarks > pages (probably not relevant) and the MySQL myths page, which was > somewhat helpful, but I couldn't find anything more along the lines of > "How to Convince my Management to go with MySQL." I don't even know > what to expect from them, but I'm imagining they'll say, "But MySQL > doesn't support sub-selects," to which I can reply, "But you can write > most of those as joins anyway, so it won't matter because the software > will all be written from scratch." Etc. > > Are there pointers anyone can give me? > > E. Bognewitz > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --------------------------------------------------------------- | / / Kent Vilhelmsen | / / Head of System Architecture Scandinavia Online |/\ / mob +47 40213917 desk +47 22583917 off +47 22583800 / \/ * Standardise your content to fit ALL browsers! * --------------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
