[EMAIL PROTECTED] on 7/23/02 4:34 PM wrote:

>>2) You can move the data from an Access database into the cross-platform 
>>MySQL, which is bundled with OS X. It is a free, robust relational 
>>database. The disadvantage is that it is a command-line program, and so 
>>it is not at all trivial for novices. Further, you will need to design 
>>new forms (often web-based) to interact with the ported database. There 
>>are some helpful resources at MacSQL (the site - http://www.macsql.com/ ) 
>>and there is a tool (also called MacSQL) which simplifies interacting 
>>with MySQL (it can even help you to build web-based forms,etc.) at 
>>http://www.rtlabs.com/macsql
>
>Pardon my dimness, but when you say "often web-based", does that mean 
>that the database is on a Web page somewhere? Or that whatever you're 
>working on is a Web browser page on =your= Mac?

Dimness? Nonsense! More probably my imprecise scribblings...

The short answer is "both". The database can be either on a server 
somewhere OR it could be on your own Mac, in which case your mac acts as 
both client and server. Another way to think of it is that your web 
browser is really the "client" no matter where the database lives, and 
the database/webserver software is the "server", even if it is on the 
same machine as your browser.

Elaborating a bit more: what I meant by "often web-based" is that several 
scripting language/web server combinations support connecting to MySQL. 
An individual with light-to-moderate scripting skills can use a scripting 
environment like PHP <http://www.php.net/> to create interactive web 
pages for adding, viewing, or modifying data in a MySQL database. 
Typically, the Apache web server <http://httpd.apache.org/> is used to 
serve the pages.

The nice thing about this combination is that it is all freely available: 
Apache and PHP are included with OS X and OS X Server. MySQL is included 
with OS X Server, but is also freely downloadable for plain old OS X 
10.1+ from several sources.

Now for some practical advice: if you don't have experience with 
scripting, configuring web servers, etc., and you just want to get a 
database up and running, you'll probably be better off getting FileMaker, 
Panorama, 4D, etc. because you won't need to invent your own interface (a 
bit overstated, but basically true). On the other hand, the fact that the 
PHP-MySQL-Apache combination is both free (except for your own labor) and 
widely used on the internet makes it attractive for hobby/learning 
purposes, and once proficiency is obtained, the knowledge gained is 
definitely marketable!

For more information, search for "MySQL and PHP" at amazon.com or visit 
your favorite bookstore - there are a lot of books out there on the 
subject. Other sites include
http://homepage.mac.com/macgurutemple/mysql_on_macosx.html 
http://www.macdevcenter.com/pub/a/mac/2001/07/20/php_macosx.html
http://www.lowendmac.com/tech/php1.html

Sorry for the wordy explanation. Let me know if you need more info 
(though maybe it would be better to contact me directly -- I want to be 
respectful of the fact that this is an Emailer mailing list.)

-Joe



___________________________________________________________________________
To unsubscribe send a mail message with a SUBJECT line of "unsubscribe" to
<[EMAIL PROTECTED]>  or  <[EMAIL PROTECTED]>

Reply via email to