Subscribe

Subscribe today and receive our blog updates in your Inbox.

×

Mysql

MySQL

mysqlMySQL is an open source relational database management system based on Structured Query Language (SQL). MySQL, which was originally conceived by the Swedish company MySQL AB, was acquired by Oracle in 2008. Developers can still use MySQL under the GNU General Public License (GPL), but enterprises must obtain a commercial license from Oracle.

MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise stack called LAMP. LAMP is a Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language.

SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP application. Good examples of PHP/MySQL-based scripts are Joomla, Drupal, and WordPress.

Key Features

Client/Server Architecture: MySQL is a client/server system. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc.

SQL Compatibility: SQL is a standardized language for querying and updating data and for the administration of a database.

Robust Functionality: Including transactions, views, foreign key constraints, full text search, Unicode, subSELECTS, stored procedures, and much more.

Programming Languages: There are quite a number of APIs (application programming interfaces) and libraries for the development of MySQL applications. For client programming you can use, among others, the languages C, C++, Java, Perl, PHP, and Python.

ODBC Interface Connector: allows MySQL to be interfaced with all Microsoft Windows (.NET, Visual Basic, etc.) programming languages.

Platform Independence: Client applications and MySQL server run under a variety of operating systems, including Apple OS X, Linux, Microsoft Windows, and countless Linux/Unix variants.

The developers at delaPlex have years of experience in providing design to deliver the best overall performance for MySQL applications, and technical support for MySQL-based web sites.

More Info

About PHP

Back