MySQL
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack—LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python".
Many programming languages with language-specific APIs include libraries for accessing MySQL databases. These include MySQL Connector/Net for integration with Microsoft's Visual Studio (languages such as C# and VB are most commonly used) and the ODBC driver for Java. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The HTSQL - URL based query method also ships with a MySQL adapter, allowing direct interaction between a MySQL database and any web client via structured URLs. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.
Features
- Cross-platform support
- Stored procedures
- Triggers
- Cursors
- Updatable Views
- True support
- Information schema
- Strict mode further explanation needed
- distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine
- Independent storage engines for read speed, InnoDB for transactions and referential integrityMySQL Archive for storing historical data in little space)
- Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB
- SSL
- Query caching
- Replication support (i.e. Master-Master Replication & Master-Slave Replication) with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
- Full-text indexing and searching using MyISAM engine
- Embedded database library
- Partial Unicode support
- Partial ACID compliance (full compliance only when using the non-default storage engines InnoDB, BDB and Cluster)
- Partititoned tables with pruning of partitions in optimiser
- clustering through MySQL Cluster
- Hot backup under certain conditions
More Projects
Property Carousel Monitor application is bespoke software for Digital Office Systems designed initially for viewing capture images of their clients screen. It a...
live site
demo site
The website provides a central point for news, resources, communication and administration across baseball and softball. One of the most important functions of ...
live site
demo site
MembersGear provides you with everything you need to easily power a membership or subscription web business.
This PHP web based software lets you easily integr...
live site
demo site
Anderson Vintage Parts is online shopping cart for bike parts.
AVP has supplied parts for museums, restorers, collectors, vintage bike racers and even supplied...
live site
demo site
It is site for Hickory Ground Solutions (HGS) which is an American Indian owned professional services firm formed in 2008.
live site
demo site
Online Inspection Report Combines "Web-Based" application along with software for PC based computers. Online Inspection Report is the most technologically a...
live site
demo site
Cogneti provides an entirely new class of learning tools that combine Cognition science, Community-based contributors & learners, Mobile devices & smartphones.
live site
demo site