For those of you with more complex needs, we can provide both PHP scripting and MySQL support for your sites.  Your web site control panel provides a PHP based tool, PhpMyAdmin (Version 2.6.4) to support mySQL administration, and also allows you to install some example JSP and ASP example code to access our MySQL server.

This is a full featured SQL database.  We are currently running version 4.1.20 and you can ALSO use the new version 5.0.x or testing. Both include support for both European and Asian wide character sets.  It also includes innodb table support for those of you requiring transaction support. It is well integrated with PHP or PERL, and provides very high performance query response with excellent stability. There is a minimum charge of $10/month for database access.  We do not recommend using MySQL queries for high-traffic pages (our staff can give you tips on how to reduce activity). Consult the MySQL site for complete documentation and new features.

MySQL 5.x - This is the new version of MySQL which has support for stored procedures, triggers, and views. We are running a 'test version' of the database ONLY.  It is available to you via your control panel & phpMyAdmin access and we hope it will allow you to experiment with some of the new features MySQL has to offer. You can also confirm  your old applications will run properly under MySQL 5.x.  It is located on a test server used by our staff and configuration/status is liable to change without notice.  Let our staff know if you have any questions.

Web based SQL Tutorial - if you are not familiar with SQL, this is a good place to start. We can also HIGHLY recommend the book, "The Practical SQL Handbook - 3rd Edition" by Judith Bowman -- it is excellent.

• Accessing your mysql database using MS Access and myODBC - Accessing your MySQL database using MS Access and myODBC An ODBC interface to your database on our web servers allows you to make convenient updates using MS Access from your PC at home or office
  
• Transaction Support -  Our version of MySQL has full transaction support based on the innodb table. See this section of the MySQL manual for complete documentation.  If you are interested in top speed, use the default MyISAM tables already provided.

Please remember that we cannot edit/debug scripts you may write. These are programming tools and do require more experience than standard HTML. If you need a project done, we would be happy to give you a quote on the effort.

NOTE: As part of the services we include with MySQL is a daily SQL back up of your entire database.  We also do a check, analyze, and optimize command of all your tables once each day to avoid performance problems.

We have a complete set of demo code available which show you the proper connection string and how to do a simple query from ASP, PHP, PERL DBI, PERL MySQL, and both Java JSP and Servlets. 
Click here for the examples page.

[Home]   [Web Hosting]   [Extras]   [FAQ List]   [Support]    [Sign Up!]   [About Us]   [Contact Us] © Copyright 1996-2007 Software Workshop Inc.™