Wednesday, April 2, 2014

Open Source Database Engines - MySQL

Okay, now we come to our and the world's favorite DBE: MySQL. It is a massively powerful and Open Source DBE. It powers giants like Facebook (remember, in 'The Social Network', Jesse Eisenberg says 'I need a dedicated Linux box running Apache with a MySQL backend'?).

The source code is available under the GNU General Public Licence, as well as under several proprietary agreements. It is a popular choice to be used in LAMP based web design.

LAMP stands for Linux, Apache, MySQL, Perl/PHP/Python. Popular examples of applications that use MySQL databases are:

  • TYPO3
  • MODx
  • Joomla
  • Wordpress
  • phpBB
  • MyBB
  • Drupal

Websites that use MySQL include:
  • Google
  • Wikipedia
  • Flickr
  • Facebook
  • Twitter
  • Youtube

MySQL Workbench is a free integrated environment that allows users to graphically alter and work on their databases. As opposed to SQLite, it is native to a machine, and its data cannot be directly copied to another database. On the other hand, it allows customized queries which results in faster searches and more effective operation.
That's a bird's eye view of MySQL folks!
Cheers!

No comments:

Post a Comment