1.8 Useful MySQL-related links

1.8.1 Tutorials

• A beginners tutoral of how to start using MySQL
• A lot of MySQL tutorials
• Setting Up a MySQL Based Website
• MySQL-perl tutorial
• PHP/MySQL Tutorial

1.8.2 Commercial applications that support MySQL

• SupportWizard; Interactive helpdesk on the web (This product includes a licensed copy of MySQL)
• 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.

1.8.3 SQL Clients

• MySQL Editor/Utility for MS Windows Platforms.
• KDE MySQL client
• Kiosk; a MySQL client for database management. Written in Perl. Will be a part of Bazaar.

1.8.4 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

1.8.5 Databse design tools with MySQL support

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

1.8.6 Web servers with MySQL tools

• An Apache authentication module
• The Roxen Challenger Web server

1.8.7 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
• Support for BIND (The Internet Domain Name Server)
• Sendmail extensions using MySQL

1.8.8 Using MySQL with other programs

• Using MySQL with Access

1.8.9 ODBC related links

• Popular iODBC Driver Manager (libiodbc) now available in Open Source format
• The FreeODBC Pages

1.8.10 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.

1.8.11 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

1.8.12 SQL and database interfaces

• KMySQL KMySQL is a database client for KDE that primarily supports MySQL.
• The JDBC database access API
• Patch for mSQL TCL
• EasySQL: An ODBC-like driver manager
• A REXX interface to SQL databases
• TCL interface

1.8.13 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.
• Steve Fambro Uses MySQL and webmerger. There is an employee database, and a license plate database with all of the registered Utah vehicles (over 1.2 million). The License plate field is indexed.....so the *searches* are instantaneous.
• World Records A search engine for information about music that uses MySQL and PHP.
• Examples using MySQL; (check Top 10)
• 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.

1.8.14 General database links

• Database Jump Site
• Homepage of the webdb-l (Web Databases) mailing list.
• Perl DBI/DBD modules homepage
• Cygwin tools (MySQL +Apache + PHP under Win32
• 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. A 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.