ok so what is the best way to use libDatabase?
Robert Mann
install a database or use one provided by your ISP. The ISP method
could be used if you've never installed a db. Dreamhost is one such
provider. Or go to MYSQL.org and download a version of mysql to
install locally on your machine or on another machine on your
network. Versions of mysql can be downloaded free, however
professional deployment and use must be licensed $$.
if you've done this, then get a SQL client like Navicat (paid) or
CocoaMySQL(free, mac only) to create populate and talk to your
database. This will make it easier to then script your sql commands
and test results. It also helps to see what's happening when your
scripts don't work.
Get the example database and scripts from Trevor's site. import the
simple data to the database, then explore. Eventually you can replace
all the functionality in those clients with your own code. For
instance, you could make a simple stack with two fields, one with
your SQL statement, and one to show the results.
Sarah at Trozware has a couple of stacks that have worked well for me
for getting started. Her stacks use the built in rev database hooks,
but do not use Trevor's libraries.
MySQLtests.rev
This stack provides a GUI for testing connections to MySQL databases.
It does basic queries as well as editing of tables and records. Not
intended for long term use, but I found it helpful when starting to
learn about MySQL.
MySQL.rev
This stack is a simple client for communicating with MySQL servers
either on your own computer or remotely. It accepts any MySQL command
and displays the results in a simple text-based table form. It is
supposed to be similar to the client available when using OS X's
Terminal, but does not require that the client & server be installed
on your computer.
http://www.troz.net/Rev/tutorials.php
sqb
--
stephen barncard
s a n f r a n c i s c o
- - - - - - - - - - - -
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
