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

today's leftovers

  • Xfce Power Manager 1.5.0 Finally Ported to GTK3+
    Xfce's Power Manager was getting behind the times, but it has been updated and ported to GTK+ 3.14. As you can imagine, this is an important update, and it packs other changes as well.
  • There Are 140k Benchmark Results So Far On LinuxBenchmarking.com
    Yesterday data access to LinuxBenchmarking.com was opened, the public results viewer to the immense amount of test data -- primarily the Linux kernel, LLVM Clang, and GCC -- collected on a daily basis within the new server room. Here's some numbers behind it.
  • Interview with Andrei Rudenko
    When I became interested in Linux and open source. I found Krita, it had everything that I needed for a digital painting. For me it is important to repeat that feeling like you paint using traditional materials.
  • KDE Plasma 5.3.1 Is Out with Fix for "Show Desktop"
    The KDE Community has just revealed that Plasma 5.3.1, the desktop for the KDE project, has been made available, and it comes with a large number of changes and various small fixes.
  • Friction Building Around An Ubuntu Community Council Decision
    Scott Kitterman exposed the email exchanges today of the Ubuntu Community Council informing Jonathan Riddell that due to his aggressive, confrontational behavior towards some within the Ubuntu community and Canonical, he should step away from "all positions of leadership in the Ubuntu Community for at least 12 months." His leadership positions should be put aside for both Ubuntu and Kubuntu while he would be able to keep his upload/commit rights and still participate as a member of the Ubuntu community.
  • Reaffirmed on the Kubuntu Council
    I’d like to thank all the Kubuntu members who just voted to re-affirm me on the Kubuntu Council. Scott Kitterman’s blog post has a juicy details of the unprecedented and astonishing move by the Ubuntu Community Council asking me to step down as Kubuntu leader. I’ve never claimed to be a leader and never used or been given any such title so it’s a strange request without foundation and without following the normal channels documented of consultation or Code of Conduct reference.
  • Mark Shuttleworth, Ubuntu Community Council ask Kubuntu developer to step down as leader
    Friction between the lead Kubuntu developer Jonathan Riddell and Ubuntu reached extreme temperatures on Monday when the Ubuntu Community Council (UCC) asked Riddell to step down from the position of Kubuntu Leader.
  • The last planned Qt 4 release is here: Qt 4.8.7. Is your app runnning with Qt5?
  • Qt 4.8.7 Released with over 150 Improvements and Bug Fixes
    On May 26, the Qt Company, through Tuukka Turunen, had the great pleasure of announcing the immediate availability for download of the seventh maintenance release of Qt 4.8.
  • Qt 4.8.7 Released - Marks The End Of Qt4
    While Qt 5 has so many compelling advantages over Qt4, for those still running the older version of the Norwegian toolkit, version 4.8.7 of Qt4 is now available and it ships with tons of changes.
  • GNOME Disk Utility 3.17.2
    The GNOME Project released version 3.17.2 of Disks, better known as GNOME Disk Utility. This utility contains several significant improvements and new features, for example D-Bus is now activatable and the appearance of the volume grid has been refined.
  • Technology Is A Tool, Not A Learning Outcome
    Croatia is gaining in usage of GNU/Linux. That TFA was written shows the awareness of a lack of availability of IT. All that is needed to bridge the digital divide is for Croatian schools to catch up with and to exceed the rest of society in using GNU/Linux, the right way to do IT in education. Croatia needs to treble its IT in schools. That isn’t going to happen with Wintel. With FLOSS it is possible and can be done within a few years for no extra expenditure. With a little extra effort the change can be done in two years.
  • Gartner Reports Strong Chromebook Sales in Schools, Enterprises...Not So Much
    Gartner researchers report that worldwide Chromebook sales are set to reach 7.3 million units in 2015, a 27 percent jump from the 5.7 million units sold last year.
  • You might be surprised by how few businesses protect their Linux servers with antivirus
  • Alpine 3.2.0 Features MATE 1.10, Xfce 4.12, and Linux Kernel 3.18
    Natanael Copa has been happy to announce today, May 26, the immediate availability for download of the Alpine Linux 3.2.0 operating system, which includes several attractive new features.
  • Ubuntu 15.10 Wily Werewolf Started Updating The GNOME Packages To Version 3.16
    Canonical has added some of the GNOME 3.16 packages in their Ubuntu 15.10 Wily Werewolf system, but the changes will not be spotted by the regular user. The problem is not with the updated applications, but with an upgraded GTK version, which may really affect the system. Before implementing apps by default, Canonical patches them to work well with Unity, basic on the philosophy that an app that works well does not need to get updated.

Leftovers: Software

today's howtos

Leftovers: Gaming