mysql to valentina using libdatabase

Stephen Barncard stephenREVOLUTION at barncard.com
Fri Dec 29 12:30:01 EST 2006


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





More information about the use-livecode mailing list