Thursday, February 4, 2010

Section B.5.  Desktop Database Management: MySQL









B.5. Desktop Database Management: MySQL


We recommend using MySQL with the Windows desktop as a replacement for Microsoft Access. While MySQL is a fully featured relational database management system (RDBMS), it is fast and lightweight enough to be used on a desktop system. You can use MySQL on the desktop in several different ways:


  • On a Windows desktop, you can use Access as a frontend to MySQL using the MyODBC driver. Alternatively, you can install MySQL natively, and use it via GUI tools such as MySQL Query Browser.

  • On a Linux desktop, you can easily install, use, and manage MySQL via web-based interfaces such as phpMyAdmin, KDE applications such as Kexi, or other GUI tools such as MySQL Query Browser.


MySQL is a fast, robust, and easy-to-use database. It is supported by MySQL AB, the company that funds MySQL development. It also has a large and active end-user community. MySQL's main features are:


  • Broad ANSI SQL syntax support

  • Multiple storage engine options, including MyISAM for performance and InnoDB for full transaction support and row-level locking

  • Query caching and full text indexing

  • Numerous third-party tools to help manage data









    No comments: