mysql to valentina using libdatabase

Robert Mann robmann at gp-racing.com
Fri Dec 29 13:06:11 EST 2006


Thanks for the great explanation,
I already have mysql running locally(using xampp) for a rev application that
I have built and that works great I am now exploring valentina(for the fact
that I can deploy and not have the expense mysql) so I need to convert the
mysql database to valentina so was trying to get libDatabase working to help
me do the conversion. I tried to use valentina studio but have had problems
getting it to do the conversion.

So more specifically how are people using libDatabase to do a conversion of
a mysql database to valentina?

Thanks
Robert Mann


-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Stephen
Barncard
Sent: Friday, December 29, 2006 12:30 PM
To: How to use Revolution
Subject: RE: mysql to valentina using libdatabase



>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
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the Use-livecode mailing list