MyODBC to Access your MySQL Database
MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. In this article Annette takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script. Active Server Pages are a Microsoft technology that allows developers proficient with either Visual Basic or VBScript to easily adapt their skills and knowledge to the web with very little effort at all. ASP uses ActiveX Data Object (ADO) to connect to several popular database management systems including Microsoft Access and SQL Server, Oracle, dBase and Visual Fox Pro. Did you know that you can also talk to MySQL databases using ODBC through ASP? The MySQL database can either be on the same server, or on the other side of the world; running Windows, Linux, Solaris, FreeBSD, MacOS X, or any other one of the several operating systems that MySQL supports.
MySQL Database Integrated into commercial software
MySQL AB, developer of the world's most popular open source database, today announced that MySQL has been selected as the embedded database for popular software products from Virage, Inc. (Nasdaq: VRGE), Blue World Communications, Inc., CoreSense, Inc. and SS8, Inc. These companies reflect a trend toward the increasing use of MySQL as the built-in database for commercial products that require a high-performance, reliable and resource- mefficient data management system. While MySQL continues to be a mainstay of Web development efforts and other mission-critical projects within companies, we've seen tremendous and growing interest in using it as the database within commercial products," said Marten Mickos, MySQL AB's CEO. Most of these customers value MySQL for its unique combination of speed and resource efficiency - features that can be critical to the success of a product.
MySQL database and Linux tutorial
This tutorial covers the MySQL database on Red Hat Linux. This tutorial will also cover the generation and use a simple database. The interface language of the MySQL database is the standard SQL (Standard Query Language) which allows for inserts, updates and queries of data stored in relational tables. The SQL language is also used for the administration of the database for the creation and modification of tables, users and access privileges. Tables are identified by unique names and hold data in a row and column (record) structure. A fixed number of named columns are defined for a table with a variable number of rows.
MySQL Database Scalability Peaks
MySQL AB announced late last month that it has certified the latest version of its namesake open-source database as production-ready and optimized it for the 64-bit Intel Corp. Itanium 2 processor running Linux. MySQL 4.0 includes features designed to make it more suitable for mission-critical, heavy-load database systems. Its performance can also be optimized as an embedded database, said officials, in Uppsala, Sweden. The update includes a query cache that's designed to improve performance in applications with repetitive queries, full-text indexing, searching on packed indexes, bulk inserts and other optimizations for faster query execution. It is available on all major Linux distributions plus Unix, Mac OS X and Windows.
If you enjoyed this post then why not add us on Google+? Add us to your Circles
Liked it! Share this Tutorial