On Thu, February 5, 2009 9:24 am, Patrick Coskren wrote: > On Feb 5, 2009, at 12:21 PM, Lawrence Sica wrote: > >> MySQL is, to be frank, shittastic. I never understood >> the joy and awesomeness that some people think that it is made up of. > > Short learning curve and very quick for tasks with high-frequency > reads, low-frequency writes, and no strong need for data integrity.
Which describes me, and my application, perfectly. Well, at least me. The short learning curve is a big part of my frustration - my SQL skills have been developed on the fly over the years - I'm not a DBA and don't pretend to be one... but I do need to muck with large volumes of data from time to time - and I tend to understand the data better than the administrators - so it is much more efficient when I'm in command of the tools and queries - so I have the baseline SQL skills I need, and I'm quite comfortable in that. I'm just finding, for my type of interaction, a lot of frustration. Seriously, the lack of multi-row inserts and insert-or-update functionality is mind-boggling. Yes, both can be hacked together, but those approaches make for some very ugly SQL, and for queries which don't lend themselves to ad hoc use. Maybe, again, I'm just looking for a better client than MS SQL Mgmt Studio. I'm sure there is one, but I've yet to find anything. > There are tasks for which that's a good set of tradeoffs. That > describes what a lot of web developers think they need. (I believe a > lot of web developers underestimate their need for data integrity > until it bites them in the ass.) The next generation of this application will be running on top of SQL Server as well, though it'll be far more rare to touch the database directly - there's a clean set of APIs for .NET and web services which will suit me just fine 90% of the time. _______________________________________________ OSX-Nutters mailing list | [email protected] http://lists.tit-wank.com/mailman/listinfo/osx-nutters List hosted at http://cat5.org/
