In all of the speculative fiction I’ve ever read in which there are computers, there are very few times when anyone guesses that, at this stage of the game, it is not hardware manufacturers who differentiate between computers, but operating systems. When someone asks about your computer, that is usually what they mean. It is a strange state of affairs, that’s for darn sure – to be concerned with the software run at the lowest level on your hardware, rather than the hardware itself.
Month: October 2003
Downtime
The last couple of days of the website being down are aparently due to a PHP upgrade. The new version does not include by default the PEAR database abstraction library installed, and so several aspects of this site which use them borked. Little things like database connection. That has been fixed and the server rebooted, but it definitely means that I should re-code to avoid depenence on modules on whose presence I cannot count.
MySQL and mSQL
If you’ve never used a UNIX-like system before, or a programming language, you will have some trouble with this book. If you are somewhat familiar with one modern programming language and know at least the rudiments of the UNIX filesystem, this book is a great introduction to databases and these two popular database tools.
The opening chapters outline the basic concepts really clearly, and walk you through the short course in database design. If you are creating a small database with one of these tools (MySQL or mSQL) this book will get you started in fine style. The chapter on installing the tools is comprehensive and very well laid out. The basic style of the prose is easy to read and very comforting if you are new to the topic.
The big problem with the book is that it is organized with the information about the two tools explained in parallel. This is quite simple to understand and easy to read, but once you start trying to flip back through the book you realize that you get hopelessly snarled by the subtle differences between the two software packages. MySQL and mSQL are so close in function, and implement SQL so similarly, that it is easy to get confused by the tiny differences in syntax and structure that that these two systems demand.