Language Selection

English French German Italian Portuguese Spanish

MySQL 5.0 open source database

Filed under
Reviews

List price: Free to download and use (support extra)
Made by: MySQL
Pros: Free; Loads of new features over 4.1; Excellent support for a range of platforms; Performs well in small and medium applications
Cons: You probably wouldn't use it for a big, heavy-duty installation
Buying advice: MySQL has always been an attractive option, and continues to be so. If you're already running it, you may as well move to 5.0 as it seems stable and the update path only gets complicated (and then only slightly) if you're using replication.

MySQL is by far the best known, and most popular Open Source database engine. It ships with most Linux distributions (not to mention commercial Unix incarnations such as Mac OS X) and has become immensely popular over the years because it's an ideal way to run a decent-sized database at minimal cost.

As a developer, though, I've had to work around some fundamental flaws over the years. My main gripe about MySQL so far has been that it hasn't supported stored procedures. These are user-defined procedures that you build into the database itself and then call from client-end applications - so you define stuff once and can then call it from a number of client platforms. Buzzword enthusiasts call this a "multi-tier" approach; think of it as "write once, use many".

Full Review.

great possibilities

Sounds great. If I could find a way to run it from a DVD-ROM on both Macs and PCs, then I would seriously consider migrating my 17,000 file websites to a MySQL database.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

More in Tux Machines

Leftovers: Ubuntu

Leftovers: Software

today's howtos

Phoronix on NVIDIA

  • Compute Shader Support Patches For NVIDIA Fermi On Nouveau
    Samuel Pitoiset has published a set of twelve patches for implementing compute shaders support within the Nouveau NVC0 Gallium3D driver for the GeForce 400/500 "Fermi" graphics processors.
  • NVIDIA Posts Latest PRIME Sync Patches On Road To Better Support
    Alex Goins of NVIDIA has spent the past several months working on PRIME synchronization support to fix tearing when using this NVIDIA-popular multi-GPU method. The latest patches were published this week.
  • The Best Graphics Card Brands For NVIDIA/AMD GPUs As A Linux Consumer?
    One of the most frequent topics I'm emailed about is any brand recommendations among NVIDIA and AMD AIB partners for graphics cards. For Linux users, is there a particular brand preference for graphics cards? The short story is, no, there isn't one particular brand when selecting either a GeForce or Radeon graphics card that a Linux gamer/enthusiast should go with over another AIB partner. Over the past 12 years of running Phoronix, there has been no single AIB partner that superbly stands out compared to the rest when it comes to graphics card AIB partner brands like ASUS, Zotac, HIS, MSI, etc. They all work under Linux, rarely the AIB differences extend beyond the heatsink/cooler and any default clock speed differences, and I haven't seen one that's over-the-top crazy about Linux. I also haven't seen any major partner consistently put the Tux logo or other Linux markings on their product packaging, let alone incorporate any Linux drivers onto their CD/DVD driver media.