[permalink] [id link]
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack — LAMP is an acronym for " Linux, Apache, MySQL, Perl / PHP / Python.
from
Wikipedia
Some Related Sentences
MySQL and is
MySQL ( " My S-Q-L ", officially, but also called " My Sequel ") is the world's most used open source relational database management system ( RDBMS ) as of 2008 that runs as a server providing multi-user access to a number of databases.
MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google ( though not for searches ), Facebook, Twitter, Flickr, Nokia. com, and YouTube.
MySQL is primarily an RDBMS and ships with no GUI tools to administer MySQL databases or manage data contained within the databases.
The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.
The official MySQL Workbench is a free integrated environment developed by MySQL AB, that enables users to graphically administer MySQL databases and visually design database structures.
MySQL Workbench is available in two editions, the regular free and open source Community Edition which may be downloaded from the MySQL website, and the proprietary Standard Edition which extends and improves the feature set of the Community Edition.
* OpenOffice. org – OpenOffice. org Base can manage MySQL databases if the entire suite is installed.
MySQL is written in C and C ++.
MySQL 5. 5 is offered under the same licences.
* Strict mode ( ensures MySQL does not truncate or otherwise modify data to conform to an underlying data type, when an incompatible value is inserted into that type )
* Multiple storage engines, allowing one to choose the one that is most effective for each table in the application ( in MySQL 5. 0, storage engines must be compiled in ; in MySQL 5. 1, storage engines can be dynamically loaded at run time ):
MySQL and popular
In addition to current support for the popular and efficient MySQL database, plans are underway to support Oracle and other generic ODBC-compliant databases ( Sybase, Microsoft SQL Server, etc.
A popular example is the LAMP ( Linux, Apache, MySQL, PHP ) stack, which is usually distributed free of charge.
Soundex is the most widely known of all phonetic algorithms ( in part because it is a standard feature of popular database software such as PostgreSQL, MySQL, MS SQL Server and Oracle ) and is often used ( incorrectly ) as a synonym for " phonetic algorithm ".
Since popular databases like MySQL do not allow nesting BEGIN-COMMIT brackets, a framework or a transaction monitor is needed to handle this.
Recently ( as the other layers became more compatible with Windows ) WAMP has become more popular as a more literal Windows alternative to LAMP, using: Windows, Apache, MySQL, and Perl / PHP / Python.
Most popular DBMSs are supported, such as Microsoft SQL Server, Oracle, DB2, Informix, PostgreSQL and MySQL.
MySQL and choice
The software of choice was C, Perl, Apache, Squid, MySQL some Oracle and Sybase.
Small Business ), and at the same time began offering new customers the choice of a more standard PHP / MySQL web hosting environment instead of the RTML-based Store Editor.
MySQL and database
* MySQL database system – Prior to v5. 1, MySQL included a BDB data storage backend.
Examples include GNOME and K Desktop Environment 3 as well as the MySQL database and the PHP scripting language.
While earlier versions of BIND offered no mechanism to store and retrieve zone data in anything other than flat text files, in 2007 BIND 9. 4 DLZ made available ( as a compile-time option ) zone storage in a variety of database formats including LDAP, Berkeley DB, PostgreSQL, MySQL, and ODBC.
" Free-software-open source projects that require a full-featured database management system often use MySQL.
Users may use the included command line tools, or use MySQL " front-ends ", desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records ..
Similar to other third-party packages, but still considered the authoritative MySQL frontend, MySQL Workbench lets users manage database design & modeling, SQL development ( replacing MySQL Query Browser ) and Database administration ( replacing MySQL Administrator ).
Third-party proprietary and free graphical administration applications ( or " front ends ") are available that integrate with MySQL and enable users to work with database structure and data visually.
Like Access, it can be used as a front-end for various database systems, including Access databases ( JET ), ODBC data sources, and MySQL or PostgreSQL.
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.
In this configuration, application owners do not have to install and maintain the MySQL database on their own.
* Managed MySQL cloud hosting-the database is not offered as a service, but the cloud provider hosts the database and manages it on the application owner's behalf.
MySQL and for
* DBEdit – a free front end for MySQL and other databases.
* SQLYog-a free community-developed UI for MySQL.
* Toad for MySQL – a free development and administration front end for MySQL from Quest Software
Other available proprietary MySQL front ends include dbForge Studio for MySQL, DBStudio, Epictetus, Oracle SQL Developer, SchemaBank, SQLPro SQL Client, Toad Data Modeler.
* Maatkit-a cross-platform toolkit for MySQL, PostgreSQL and Memcached, developed in Perl.
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 JDBC driver for Java.
* Independent storage engines ( MyISAM for read speed, InnoDB for transactions and referential integrity, MySQL Archive for storing historical data in little space )
MySQL and use
Applications which use MySQL databases include: TYPO3, Joomla, WordPress, phpBB, MyBB, Drupal and other software built on the LAMP software stack.
* Virtual Machine Image-cloud users can upload a machine image of their own with MySQL installed, or use a ready-made machine image with an optimized installation of MySQL on it, such as the one provided by Amazon EC2.
The MySQL server software itself and the client libraries use dual-licensing distribution.
This had little effect, as Berkeley DB was not widely used, and was dropped ( due to lack of use ) in MySQL 5. 1. 12, a pre-GA release of MySQL 5. 1 released in October 2006.
As part of the negotiations with the European Commission, Oracle committed that MySQL server will continue until at least 2015 to use the dual-licensing strategy long used by MySQL AB, with commercial and GPL versions available.
MySQL, Eucalyptus, StarOffice and others use this model to market an " enterprise " version with additional features see open core for more details.
The no-charge version of DB2 is called DB2 Express-C. DB2 Express-C is in some ways similar to the open source databases such as MySQL and PostgreSQL as it is offered unsupported, free of charge for unrestricted use including use in production environments.
However, via plug-ins, PmWiki can already use MySQL or SQLite databases for data storage.
With Gambas, developers can also use databases such as MySQL or PostgreSQL, build KDE ( Qt ) and GNOME GTK + applications with DCOP, translate Visual Basic programs to Gambas and run them under Linux, build network solutions, and create CGI web applications.
Moodle version 1. 6 could use MySQL or PostgreSQL.
It was written in PHP for use with MySQL by Michel Valdrighi, who is now a contributing developer to WordPress.
The following tools use Crow's Foot notation: ARIS, System Architect, Visio, PowerDesigner, Toad Data Modeler, DeZign for Databases, Devgems Data Modeler, OmniGraffle, MySQL Workbench and SQL Developer Data Modeler.
0.661 seconds.