On 24 May 09:31, Mark Rogers wrote:
On 24/05/2011 07:44, Brett Parker wrote:
I'm wondering when MySQL became a database server rather than a noddy datalosing toy... but I may be being harsh :)
The remainder of the app uses DBF files and my other most obvious option was MDB files, so I'd say I'm close enough! To be fair to MySQL it is a capable RDBMS these days if you use the functionality, and to be fair to you you'd be right in thinking if I'm using MySQL I'm probably not using that functionality......
Even with the "sensible" backend that does foreign keys and transactions, it still has serious issues if you want to change the schema - rather than, you know, adding a column it creates a whole new table, locks the database, does a copy from the old table in to the new, drops the old table and renames the new...
Now do that with a large dataset...
Gotta love it :/
Oh, and of course, DDL statements aren't transactioned. (OK - so I only know of one database server that actually *does* do transactioned DDL, and it is my database server of choice - postgresql :)
I'm also wondering what the notepad replacement was, if it wasn't vim, it's not a real text editor (emacs users need not reply - you crazy crazy people you!).
Not that you really care, I'm sure, but it was notepad++. If I was on my desktop I'd be using joe (Wordstar bindings rule OK!)
Ah, I have heard reasonable things about that - when I'm stuck on a windows box, though, I tend to end up with gvim installed because my fingers have the right memory for that :)
Cheers,