[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]>

