Useful MySQL-related links

Tutorials

• A beginner's tutoral of how to start using MySQL
• http://www.analysisandsolutions.com/code/mybasic.htm Beginners MySQL Tutorial on how to install and set up MySQL on a Windows machine.
• A lot of MySQL tutorials
• Setting Up a MySQL Based Website
• MySQL-perl tutorial
• PHP/MySQL Tutorial
• Hands on tutorial for MySQL

Porting MySQL / Using MySQL on different systems

• The MacOS Xclave. Running MySQL on MacOSX
• MySql for MacOSX Server
• Client libraries for the Macintosh

Perl related links

• Perl DBI with MySQL FAQ

MySQL discussion forums

• Examples using MySQL; (check Top 20)

Commercial applications that support MySQL

• SupportWizard; Interactive helpdesk on the web (This product includes a licensed copy of MySQL)
• StWeb StWeb - Stratos Web and Application server - an easy-to-use, cross platform, Internet/Intranet development and deployment system for development of web-enabled applications. The standard version of StWeb has a native interface to MySQL database.
• Right Now Web; Web automation for customer service
• Bazaar; Interactive Discussion Forums with web interface
• PhoneSweepT is the world's first commercial Telephone Scanner. Many break-ins in recent years have come not through the Internet, but through unauthorized dial-up modems. PhoneSweep lets you find these modems by repeatedly placing phone calls to every phone number that your organization controls. PhoneSweep has a built-in expert system that can recognize more than 250 different kinds of remote-access programs, including Carbon CopyT, pcANYWHERET, and Windows NT RAS. All information is stored in the SQL database. It then generates a comprehensive report detailing which services were discovered on which dial-up numbers in your organization.

SQL Clients/Report writers

• MySQL Editor/Utility for MS Windows Platforms.
• KDE MySQL client
• KMySQL KMySQL is a database client for KDE that primarily supports MySQL.
• Win32 GUI client A Win32 GUI client by David Ecker.
• Kiosk; a MySQL client for database management. Written in Perl. Will be a part of Bazaar.
• A free report writer in Java

Web development tools that support MySQL

• PHP: A server-side HTML-embedded scripting language
• The Midgard Application Server; a powerful Web development environment based on MySQL and PHP
• SmartWorker is a platform for web application development
• XSP: e(X)tendible (s)erver (p)ages and is a HTML embedded tag language written in Java (previously known as XTAGS)
• dbServ is an extension to a web server to integrate databases output into your HTML code. You may use any HTML function in your output. Only the client will stop you. It works as standalone server or as JAVA servlet.
• Platform independent ASP from Chili!Soft
• MySQL + PHP demos
• ForwardSQL: HTML interface to manipulate MySQL databases
• WWW-SQL: Display database information
• Minivend: A Web shopping cart
• HeiTML: A server-side extension of HTML and a 4GL language at the same time
• Metahtml: A Dynamic Programming Language for WWW Applications
• VelocityGen for Perl and TCL
• Hawkeye Internet Server Suite
• Network Database Connection For Linux
• WDBI: Web browser as a universal front end to databases which supports MySQL well.
• WebGroove Script: HTML compiler and server-side scripting language
• A server-side web site scripting language
• How to use MySQL with ColdFusion on Solaris
• Calistra's ODBC MySQL Administrator
• Webmerger This CGI tool interprets files and generates dynamic output based on a set of simple tags. Ready-to-run drivers for MySQL and PostgreSQL through ODBC.
• PHPclub. Tips and tricks for PHP
• MySQL and Perl Scripts
• The Widgetchuck; Web Site Tools and Gadgets
• AdCycle advertising management software
• pwPage provides an extremely fast and simple approach to the creation of data base forms. That is, if a data base table exists and an HTML page has been constructed using a few simple guidelines, pwPage can be immediately used for table data selections, insertions, updates, deletions and selectable table content reviewing.

Databse design tools with MySQL support

• "Dezign for databases" is a database development tool using an rick> entity relationship diagram (ERD).

Web servers with MySQL tools

• An Apache authentication module
• The Roxen Challenger Web server

Extensions for other programs

A Delphi interface to MySQL. With source code. By Matthias Fichtner.
• TmySQL; A library to use MySQL with Delphi
• Delphi TDataset-component
• MySQL support for BIND (The Internet Domain Name Server)
• MySQL support for Sendmail and Procmail

Using MySQL with other programs

• Using MySQL with Access

ODBC related links

• Popular iODBC Driver Manager (libiodbc) now available in Open Source format
• The FreeODBC Pages
• unixodbc The unixODBC Project goals are to develop and promote unixODBC to be the definitive standard for ODBC on the Linux platform. This is to include GUI support for KDE.

API related links

• www.jppp.com Partially implemented TDataset-compatible components for MySQL.
• qpopmysql A patch to allow POP3 authentication from a MySQL database. There's also a link to Paul Khavkine's patch for Procmail to allow any MTA to deliver to users in a MySQL database.
• Visual Basic class generator for Active X
• Client libraries for the Macintosh
• MySQL binding to Free Pascal
• SCMDB. SCMDB is an add-on for SCM that ports the mysql C library to scheme (SCM). With this library scheme developers can make connections to a mySQL database and use embedded SQL in their programs.

Other MySQL-related links

• Registry of Web providers who support MySQL Links about using MySQL in Japan/Asia
• Commercial Web defect tracking system
• PTS: Project Tracking System
• Job and software tracking system
• ExportSQL: A script to export data from Access95+
• SAL (Scientific Applications on Linux) MySQL entry
• A consulting company which mentions MySQL in the right company
• PMP Computer Solutions. Database developers using MySQL and mSQL
• Airborne Early Warning Association
• MySQL UDF Registry
• Y2K tester

SQL and database interfaces

• The JDBC database access API
• Patch for mSQL TCL
• EasySQL: An ODBC-like driver manager
• A REXX interface to SQL databases
• TCL interface

Examples of MySQL use

• Little6 Inc An online contract and job finding site that is powered by MySQL, PHP3 and Linux.
• DELECis A tool which makes it very easy to create an automatically generated table documentation. They have used MySQL as an example.
• World Records A search engine for information about music that uses MySQL and PHP.
• A Contact Database using MySQL and PHP
• Web based interface and Community Calender with PHP
• Perl package to generate html from a SQL table structure and for generating SQL statements from an html form.
• Basic telephone database using DBI/DBD.
• Installing new Perl modules that require locally installed modules
• JDBC examples by Daniel K. Schneider
• SQL BNF
• Object Oriented Concepts Inc; CORBA applications with examples in source
• DBWiz; Includes an example of how to manage own cursors in VB
• Pluribus Pluribus, is a free search engine that learns to improve the quality of its results over time. Pluribus works by recording which pages a user prefers among those returned for a query. A user votes for a page by selecting it; Pluribus then uses that knowledge to improve the quality of the results when someone else submits the same (or similar) query. Uses PHP and MySQL.
• Stopbit A technology news site using MySQL and PHP
• Example scripts at Jokes2000
• FutureForum Web Discussion Software
• http://www.linuxsupportline.com/~kalendar/ KDE based calendar manager The calendar manager has both single user (file based) and multi user (MySQL database) support.
• Example of storing/retrieving images with MySQL and CGI
• Online shopping cart system
• Old Photo Album The album is a collaborative popular history of photography project that generates all pages from data stored in a MySQL database. Pages are dynamically generated through a php3 interface to the database content. Users contribute images and descriptions. Contributed images are stored on the web server to avoid storing them in the database as BLOBs. All other information is stored in on the shared MySQL server.

General database links

• Database Jump Site
• Homepage of the webdb-l (Web Databases) mailing list.
• Perl DBI/DBD modules homepage
• Cygwin tools. UNIX on top of Windows
• dbasecentral.com; Development and distribution of powerful and easy-to-use database applications and systems.
• Tek-Tips Forums Tek-Tips Forums are 800+ independent peer-to-peer non-commercial support forums for Computer Professionals. Features include automatic e-mail notification of responses, a links library, and member confidentiality guaranteed.

There are also many web pages that use MySQL. See section Some MySQL users. Send any additions to this list to MySQL logo somewhere (It is okay to have it on a ``used tools'' page or something similar) to be added.