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

LILO Boot-Loader Development To Cease At End Of Year

While most of you probably haven't used the LILO bootloader in years in place of GRUB(2), the developer of "LInux LOader" intends to cease development at the end of the year. This summer's intern, Eric Griffith, pointed out today an undated message on the LILO homepage about the bootloader project planning to end development at the end of 2015. Read more

Systemd Takes Over su, FCC Bans Open Source Firmware

Paul Carroty posted Friday of the news that Lennart Poettering merged an 'su' command replacement into systemd and Fedora Rawhide - coming to a Linux system near you next. Elsewhere, Hackaday.com's Brian Benchoff said new FCC regulations just killed Open Source firmware replacement and Phoronix.com today reported that LILO is being abandoned. Several polls caught my eye today as did the new Linux workstation security checklist. Read more

Accelerating Scientific Analysis with the SciDB Open Source Database System

Science is swimming in data. And, the already daunting task of managing and analyzing this information will only become more difficult as scientific instruments — especially those capable of delivering more than a petabyte (that’s a quadrillion bytes) of information per day — come online. Tackling these extreme data challenges will require a system that is easy enough for any scientist to use, that can effectively harness the power of ever-more-powerful supercomputers, and that is unified and extendable. This is where the Department of Energy’s (DOE) National Energy Research Scientific Computing Center’s (NERSC’s) implementation of SciDB comes in. Read more

Open Source GPU now out

Hoping that MIAOW is not a catastrophe An open saucy general-purpose graphics processor (GPGPU) has been unveiled at the Hot Chips event. The GPGPU is relatively crude and is part of another piece of an emerging open-source hardware platform called MIAOW. Read more Also: Nvidia Linux Video Driver 355.11 Adds Experimental OpenGL Support to EGL