Re: Getting Started with a Database
Thanks Trevor for the insight. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On Feb 16, 2006, at 5:34 PM, Kay C Lan wrote: On 2/16/06, Trevor DeVore <[EMAIL PROTECTED]> wrote: I recommend against using Valentina with revDB I take this to mean that you recommend using Valentina direct calls. Is this just because of speed issues, or are there bugs, gotchas or other complexities involved with using Rev calls to Valentina. (or is it just a shameless plug that you should use your excellent libDb to handle comms between Rev and Val;-) A couple of reasons - 1) Valentina is a database engine that receives frequent updates. The version of Valentina that was used in creating the RevDB driver can become outdated very quickly. By using the Valentina external you can always keep your database engine current. I'm not sure if Rev compiled in the last released Valentina 1.x code or not (Valentina is at 2.x). 2) You can't use encryption with RevDB. Valentina supports encryption of your data structure and/or data. This handy feature can't be used with RevDB. At least not with any of the published RevDB calls. 3) As far as I know, you can't access all of the handy Valentina functions through RevDB such as setting the the debug level. Not being able to set the debug level is painful when tracking down problems. Perhaps there is a way to do this with a SQL call, but I am not aware of how to do it. Valentina has a very rich API for interacting with the database. Only the external gives you access to this. Those were the main reasons I decided to use the Valentina external rather than the RevDB Valentina driver when I wrote libDatabase. One benefit is that I have been able to add support (though not fully tested) for Valentina 2 without waiting for RevDB to be updated. -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/16/06, Trevor DeVore <[EMAIL PROTECTED]> wrote: > > > I recommend against using Valentina with revDB I take this to mean that you recommend using Valentina direct calls. Is this just because of speed issues, or are there bugs, gotchas or other complexities involved with using Rev calls to Valentina. (or is it just a shameless plug that you should use your excellent libDb to handle comms between Rev and Val;-) ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On Feb 16, 2006, at 4:53 AM, David Burgun wrote:
put "SELECT * FROM myobjects WHERE Name LIKE '%" & tSearchString
& "%'" into tSQL
David,
One addition to the above code. You will want to escape the search
string in case someone enters a character like "'". So change it to:
put libdb_escape("mysql", tSearchString) into tSearchString
put "SELECT * FROM myobjects WHERE Name LIKE '%" & tSearchString &
"%'" into tSQL
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Again - FANTASTIC
Thank you all so much!
It took a while to figure out all the different components but with
the help of the posts here, I managed to do it!
I just created my Database using CocoaSQL and am about to start
accessing it with RunRev in a test stack. Once I have got the basic
record retrieve working, I will set about populating the database for
real. I reckon with the help from the people here I should have it
finished by this time tomorrow!
All the Very Best
Dave
On 15 Feb 2006, at 01:44, Kay C Lan wrote:
On 2/15/06, David Burgun <[EMAIL PROTECTED]> wrote:
I have now looked that three database solutions and none of them seem
to work and there seems to be very little "getting-started"
information supplied with them.
Just confirm that you have a copy of the MySQL reference manual. I
can't
remember if this is part of the 'full download', if not you can
download it
here:
http://dev.mysql.com/doc/
I use the pdf version as Preview makes it extremely fast (after a slow
opening as the file is HUGE) to "find" terms.
Chapter 3 is a very straight forward 'Tutorial' which you can do
through the
Terminal, although as previously posted CocoaMySQL is your friend
and I
can't emphasis enough how easy this makes life.
If you are having troubles right from the start of the Tutorial
then back
track to Chapter 2 which covers installation and a few possible
problems
that you may encounter.
Once you have a functional installation, and confirmed that you can
connect
locally, with CocoaMySQL the learning curve needed to create, add,
update
and query the database that you describe will be minor.
For your initial setup of CocoaMySQL the enteries will be:
Host: localhost
User: root
Password: [yourpassword]
NOTE: the installation instruction for MySQL make it clear that
after a
virgin install the root account (which is the MySQL root account
NOT the OSX
root account so the password can be different) has no password but
your
first action should be to allocate a password for the account.
Once connected you will have only one DB to look at, the mysql DB
which you
shouldn't touch for a while until you understand what it does - but
basically it keeps a DB on all the users and DBs you create with
MySQL.
From here you are a DB Demi-god, you can use the CocoaMySQL GUI to
create,
in your case:
1 x db
1 x table
4 or 5 fields (you might consider an Id field unless the Name field
can be
guaranteed to be unique in all cases)
My guess would be that apart from your Id and Size field ( which
would be
unsigned INTegers) your fields would be VARCHAR with sizes varying
from 4
for the Type, to 256 for the ImageFilePathName (although this could be
limiting if the path names are very very long - so you might need a
TEXT
field).
Initially, to make troubleshooting easy, I'd suggest you allow all
fields to
be NULL.
Once you have CocoaMySQL (or Terminal) and MySQL talking to each
other and
you have created your DB, the I recommend you use Rev WITHOUT
Trevor's libDB
to confirm that you can use the Rev DB calls (not the DB Query
Builder) to
communicate with MySQL. This should be a quick simple stack with 4
or 5
fields a button called something appropriate like 'Add Data'. In
your button
you should have these calls:
-- this assumes that your db is called myTestDb, your MySQL root
account
password is myTestDbPassword and your stack is called MyStack
-- this is a 9 line script so be carefull of where line breaks have
occured
on mouseUp
if (the propDbRef of stack "MyStack" = "") then
set the propDbRef of stack "MyStack" to
revOpenDatabase("MySQL",,"myTestDb","root","myTestDbPassword")
end if
put "INSERT INTO myTestDB (ID,Name,Type,SizeImageFilePathName)
VALUES (" &
quote & field "ID" of stack "MyStack" & quote & comma & quote &
field "Name"
of stack "MyStack" & quote & comma & quote & field "Size" of stack
"MyStack"
& quote & comma & quote & field "ImageFilePathName" of stack
"MyStack" &
quote & ")"
revExecuteSQL the propDbRef of stack "MyStack",tMyDbQuery
on mouseUp
Use the debugger and Variable Watcher to step through the script to
see what
tMyDbQuery looks like.
You should then be able to change all the data in the fields and
press the
"Add Data" button at your hearts content and then confirm the data
entered
your Db by using the 'Content' pane of CocoaMySQL. Note that to see
the
updates you will need to deselect your Test DB and select it again
to get an
updated view of the Db.
Having achieved this you can then go ahead an use Trevor's
excellent libDb
knowing that MySQL works, you have a Db that has data, and Rev can
communicate with the Db. From here on any failures to add,alter or
retrieve
data will be a failure in your own code - reassuring isn't it;-)
HTH
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe
Re: Getting Started with a Database
Hi,
Thank you all so much! WIth this information (and all the other
posts) I am just bound to get something working for Monday!
On 15 Feb 2006, at 19:19, Trevor DeVore wrote:
On Feb 15, 2006, at 7:58 AM, David Burgun wrote:
Ok, that's great, but I don't have any database to import, I want
to create a new one from scratch. Is there anyway to do this using
libDatabase (with either Version 2 or 1) ?
libDatabase has the functions necessary to execute the SQL commands
necessary to create a database. You would use libdb_executeSQL
with something like this:
get lidb_executeSQL("DatabaseIdentifier", "CREATE TABLE myobjects
(ID int(11) NOT NULL auto_increment, Name varchar(255) NOT NULL,
Type char(4) NOT NULL, Size int(11), ImageFilePathName varchar(255)
NOT NULL, PRIMARY KEY(ID))")
Usually it is easier to create your tables with CocoaMySQL though,
then just use libDB to connect to the database. For one table it
isn't a big deal but the graphic interface helps you know what
options are available when creating columns.
Great! I understand now! I couldn't figure out where CocoaMySQL came
into it.
Ok, I understand now, thanks. One question, will libDatabase 1.x
work with the version "MySQL" that I have already installed?
Yes. libDB just sits on top of RevDB and the Valentina externals
(1.x and 2.x).
I tried that already! They like what they see as implemented as a
Card Database. An SQL database is the main feature of the app and
something that I said (maybe by mistake) would be no problem under
RunRev. The rest of the app I coded really quickly and have it
working just fine, now all they want is to see it working with an
SQL database. They will use the SQL database with other
applications, not just the one I am working on.
Okay, let's see if we can get this working then.
All my Stack needs to do is:
1. Create the Database.
I have a list of image files in a folder, the name field is the
name of the file, the Type and Size fields are determined by
looking up the name in a text file and the path is just the local
path to the image file. This operation can (and will be slow) but
this is acceptable since it will only be performed once.
You can separate creating and populating the database into two
different tasks if you would like. You can create the database
with something similar to the code I posted above or with CocoaMySQL.
You would then use libDB to populate the database. So perhaps you
could do something like this (libDB version 2 syntax):
--> REGISTER CONNECTION SETTINGS
put "mysql" into tDBA["Type"]
put "localhost" into tDBA["Host"]
put "myobjects" into tDBA["Name"]
put "root" into tDBA["Username"]
put "" into tDBA["Password"]
libdb_registerDatabase "mydb", tDBA
try
--> TO DO: CREATE LIST OF IMAGES. tImages CONTAINS VALUES
repeat for each line tImage in tImages
--> TO DO: LOOKUP IMAGE TYPE AND SIZE. tType AND tSize CONTAIN
VALUES
put tImage into tAddA["Name"]
put tTypeinto tAddA["Type"]
put tSizeinto tAddA["Size"]
put tPathToImageFolder & slash & tImage into tAddA
["ImageFilePathName"]
--> ADD TO DATABASE
put libdb_addToTable("mydb", "myobjects", tAddA, "ID") into
tAffectedRows
end repeat
catch e
answer "A database error occurred:" && e
end try
2. Retrieve from the Database.
The user enters a name, the record with this name is returned.
--> CREATE THE QUERY. THIS IS A BASIC "CONTAINS" QUERY.
local tDataA
try
put "SELECT * FROM myobjects WHERE Name LIKE '%" & tSearchString
& "%'" into tSQL
--> USE LIBDB FUNCTION FOR CONVERTING A QUERY TO AN ARRAY. FOR
BETTER PERFORMANCE, YOU CAN USE
--> LIBDB CURSOR FUNCTIONS LATER ON IF YOU WANT.
get libdb_getTableRecords("mydb", tDataA, tSQL)
--> tDataA IS NOT AN ARRAY CONTAINING ALL RETURNED RECORDS. THE
"Length" KEY CONTAINS THE NUMBER
--> OF RECORDS RETURNED.
--> POPULATE FIELD WITH RESULTS.
repeat with i = 1 to tDataA["Length"]
put tDataA["Data",i,"Title"] & tab & tDataA["Data",i,"ID"] & cr
after tResults
end repeat
delete the last char of tResults
set the text of field "MyResults" to tResults
catch e
answer "A database error occurred:" && e
end try
Is this really a massive learning curve? I have until Monday to
get this and some other purely RunRev stuff working, surely that's
enough time to do this?
Well, this should get you started. A list of things you will want
to read up on eventually:
1) SQL syntax for creating databases and tables, altering tables,
updating records, optimizing queries, etc.
2) Dealing with drivers. It is good to understand what drivers you
are distributing and why. MySQL has the revdb files in addition to
a mysql driver. altSQLite just has the revdb driver. Valentina is
a separate external (I recommend against using Valentina with revDB).
3) Performance tuning. Proper design and indexing of databas
Re: Getting Started with a Database
In about MySQL management tools, both Navicat MySQL (commercial) and YourSQL (freeware) are giving me what i expect from them without any issues. It's always a good idea to use them in ssh tunnelling / localhost port forwarding mode when you need to access a remote mySQL server aka : 1.- Establish the ssh connection from the shell() console : ssh -C -l remoteserver_username -L 5902:127.0.0.1:3306 remoteserver_ipaddress_or_domainname 2.- Add a new connection to YourSQL with : server=127.0.0.1 port=5902 userid=mysqladmin_username password=mysqladmin_userpassword In using this way, you can configure your MySQL server to accept localhost connections only instead of letting the 3306 port opened to the whole internet. Best Regards, -- Pierre Sahores www.sahores-conseil.com Le 16 févr. 06 à 04:53, Ken Ray a écrit : On 2/15/06 7:36 PM, "Charles Hartman" <[EMAIL PROTECTED]> wrote: Thanks, that's nice & new, two years newer than the one I found before. BUT it still freezes my PB totally so only a very hard reboot will bring it back. Am I weird? Some intereaction . . . Why don't you try YourSQL instead - I use both CocoaMySQL and YourSQL so perhaps one will work better than another for you: http://yoursql.ludit.it/ HTH, Ken Ray Sons of Thunder Software Web site: http://www.sonsothunder.com/ Email: [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/15/06 7:36 PM, "Charles Hartman" <[EMAIL PROTECTED]> wrote: > Thanks, that's nice & new, two years newer than the one I found > before. BUT it still freezes my PB totally so only a very hard reboot > will bring it back. Am I weird? Some intereaction . . . Why don't you try YourSQL instead - I use both CocoaMySQL and YourSQL so perhaps one will work better than another for you: http://yoursql.ludit.it/ HTH, Ken Ray Sons of Thunder Software Web site: http://www.sonsothunder.com/ Email: [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 2.7 BUG: Getting Started with a Database
Turns out, it's not a bug! Mark W helped me out today and it turns out it's not too difficult to setup 2.7 to automatically install database drivers. We'll be ammending our altSQLite auto-install stacks soon to help out, but in the meantime: For Windows users: You need to install the DLL as mentioned previously: Find the folder where Rev in installed, then be sure and copy the bundle/DLL to the folder below. /Externals/Database Drivers Next, update your "database drives.txt" file to have the last line read: altSQLite3,dbsqlite3.dll so it will appear in the standalone settings for proper inclusion into the standalone. Then copy the external and the "database drives.txt" and put them both in the folder: \Runtime\Windows\x86-32\Externals\Database Drivers and everything should work fine. I expect the same should be done for Mac users. Thank-you Mark Waddingham :-) Chipp Walters wrote: NOTE!!! Currently, standalone inclusion of 3rd party database drivers DOES NOT APPEAR TO WORK IN Rev 2.7. RunRev is aware of this problem and is working on fixing it. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Thanks, that's nice & new, two years newer than the one I found before. BUT it still freezes my PB totally so only a very hard reboot will bring it back. Am I weird? Some intereaction . . . Charles On Feb 15, 2006, at 5:42 PM, Stephen Barncard wrote: as I mentioned earlier in the week, the project is open source and this is the latest (1/24/) version. http://www.theonline.org/cocoamysql/ I just tried downloading CocoaMySQL from curiosity. When I selected one of my databases and selected a table, it froze my PowerBook absolutely solid -- after half a minute, the beachball wouldn't even spin! Is there some more modern (> 2003) version I didn't find? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On Feb 15, 2006, at 12:13 PM, Mark Wieder wrote: Is this really a massive learning curve? I have until Monday to get Yes, probably. Find yourself a good SQL tutorial online. It's not that hard to get the basics. I found this series of tutorial pages a decent start: http://sqlcourse2.com/intro2.html Charles ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
as I mentioned earlier in the week, the project is open source and this is the latest (1/24/) version. http://www.theonline.org/cocoamysql/ I just tried downloading CocoaMySQL from curiosity. When I selected one of my databases and selected a table, it froze my PowerBook absolutely solid -- after half a minute, the beachball wouldn't even spin! Is there some more modern (> 2003) version I didn't find? Charles On Feb 15, 2006, at 2:19 PM, Trevor DeVore wrote: Usually it is easier to create your tables with CocoaMySQL though, then just use libDB to connect to the database. For ___ -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
I just tried downloading CocoaMySQL from curiosity. When I selected one of my databases and selected a table, it froze my PowerBook absolutely solid -- after half a minute, the beachball wouldn't even spin! Is there some more modern (> 2003) version I didn't find? Charles On Feb 15, 2006, at 2:19 PM, Trevor DeVore wrote: Usually it is easier to create your tables with CocoaMySQL though, then just use libDB to connect to the database. For ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On Feb 15, 2006, at 7:58 AM, David Burgun wrote:
Ok, that's great, but I don't have any database to import, I want
to create a new one from scratch. Is there anyway to do this using
libDatabase (with either Version 2 or 1) ?
libDatabase has the functions necessary to execute the SQL commands
necessary to create a database. You would use libdb_executeSQL with
something like this:
get lidb_executeSQL("DatabaseIdentifier", "CREATE TABLE myobjects (ID
int(11) NOT NULL auto_increment, Name varchar(255) NOT NULL, Type char
(4) NOT NULL, Size int(11), ImageFilePathName varchar(255) NOT NULL,
PRIMARY KEY(ID))")
Usually it is easier to create your tables with CocoaMySQL though,
then just use libDB to connect to the database. For one table it
isn't a big deal but the graphic interface helps you know what
options are available when creating columns.
Ok, I understand now, thanks. One question, will libDatabase 1.x
work with the version "MySQL" that I have already installed?
Yes. libDB just sits on top of RevDB and the Valentina externals
(1.x and 2.x).
I tried that already! They like what they see as implemented as a
Card Database. An SQL database is the main feature of the app and
something that I said (maybe by mistake) would be no problem under
RunRev. The rest of the app I coded really quickly and have it
working just fine, now all they want is to see it working with an
SQL database. They will use the SQL database with other
applications, not just the one I am working on.
Okay, let's see if we can get this working then.
All my Stack needs to do is:
1. Create the Database.
I have a list of image files in a folder, the name field is the
name of the file, the Type and Size fields are determined by
looking up the name in a text file and the path is just the local
path to the image file. This operation can (and will be slow) but
this is acceptable since it will only be performed once.
You can separate creating and populating the database into two
different tasks if you would like. You can create the database with
something similar to the code I posted above or with CocoaMySQL.
You would then use libDB to populate the database. So perhaps you
could do something like this (libDB version 2 syntax):
--> REGISTER CONNECTION SETTINGS
put "mysql" into tDBA["Type"]
put "localhost" into tDBA["Host"]
put "myobjects" into tDBA["Name"]
put "root" into tDBA["Username"]
put "" into tDBA["Password"]
libdb_registerDatabase "mydb", tDBA
try
--> TO DO: CREATE LIST OF IMAGES. tImages CONTAINS VALUES
repeat for each line tImage in tImages
--> TO DO: LOOKUP IMAGE TYPE AND SIZE. tType AND tSize CONTAIN
VALUES
put tImage into tAddA["Name"]
put tTypeinto tAddA["Type"]
put tSizeinto tAddA["Size"]
put tPathToImageFolder & slash & tImage into tAddA
["ImageFilePathName"]
--> ADD TO DATABASE
put libdb_addToTable("mydb", "myobjects", tAddA, "ID") into
tAffectedRows
end repeat
catch e
answer "A database error occurred:" && e
end try
2. Retrieve from the Database.
The user enters a name, the record with this name is returned.
--> CREATE THE QUERY. THIS IS A BASIC "CONTAINS" QUERY.
local tDataA
try
put "SELECT * FROM myobjects WHERE Name LIKE '%" & tSearchString &
"%'" into tSQL
--> USE LIBDB FUNCTION FOR CONVERTING A QUERY TO AN ARRAY. FOR
BETTER PERFORMANCE, YOU CAN USE
--> LIBDB CURSOR FUNCTIONS LATER ON IF YOU WANT.
get libdb_getTableRecords("mydb", tDataA, tSQL)
--> tDataA IS NOT AN ARRAY CONTAINING ALL RETURNED RECORDS. THE
"Length" KEY CONTAINS THE NUMBER
--> OF RECORDS RETURNED.
--> POPULATE FIELD WITH RESULTS.
repeat with i = 1 to tDataA["Length"]
put tDataA["Data",i,"Title"] & tab & tDataA["Data",i,"ID"] & cr
after tResults
end repeat
delete the last char of tResults
set the text of field "MyResults" to tResults
catch e
answer "A database error occurred:" && e
end try
Is this really a massive learning curve? I have until Monday to get
this and some other purely RunRev stuff working, surely that's
enough time to do this?
Well, this should get you started. A list of things you will want to
read up on eventually:
1) SQL syntax for creating databases and tables, altering tables,
updating records, optimizing queries, etc.
2) Dealing with drivers. It is good to understand what drivers you
are distributing and why. MySQL has the revdb files in addition to a
mysql driver. altSQLite just has the revdb driver. Valentina is a
separate external (I recommend against using Valentina with revDB).
3) Performance tuning. Proper design and indexing of databases can
really affect performance in some cases. It is good to study up on
these concepts.
There are probably other things as well but that is a good start.
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
___
Re: Getting Started with a Database
David- Wednesday, February 15, 2006, 7:58:01 AM, you wrote: > All my Stack needs to do is: > 1. Create the Database. > I have a list of image files in a folder, the name field is the name > of the file, the Type and Size fields are determined by looking up > the name in a text file and the path is just the local path to the > image file. This operation can (and will be slow) but this is > acceptable since it will only be performed once. What I do is create an SQL command file and then feed that to mySQL. "DROP DATABASE IF EXISTS" && dbName "CREATE DATABASE" && dbName "USE" && dbName "CREATE TABLE" && dbName -- plus all the qualifiers -- etc. > 2. Retrieve from the Database. > The user enters a name, the record with this name is returned. revOpenDatabase ... revDataFromQuery ... > Is this really a massive learning curve? I have until Monday to get Yes, probably. Find yourself a good SQL tutorial online. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi Trevor, Thanks for taking the time out to reply. A couple of things to address here. Creating the database The recipes.rev file assumes that you have already created the recipes table in your MySQL database. That is what the recipes.sql file is for. I did a search on google on the phrase "import sql into mysql" and there were some useful results. Some people mentioned some MySQL database editors you could download. Those will have the ability to import a sql file through a menu option. In CocoaMySQL it is File->Import->CocoaMySQL dump. Ok, that's great, but I don't have any database to import, I want to create a new one from scratch. Is there anyway to do this using libDatabase (with either Version 2 or 1) ? libDatabase 2.0 The recipes.rev stack will not work with libDatabase 2.x as there were some changes to the API which made the two incompatible. libDatabase 2.x is marked as beta mainly because I haven't had time to put together example stacks, etc. If you use the recipes.rev stack with libDatabase 1.x and understand the concepts then switching to libDatabase 2.x in your project should be very easy. Ok, I understand now, thanks. One question, will libDatabase 1.x work with the version "MySQL" that I have already installed? I have now looked that three database solutions and none of them seem to work and there seems to be very little "getting-started" information supplied with them. libDatabase does work, it just doesn't have any good introduction to databases documentation/examples with it. I believe the Getting Started guide that comes with libDatabase 2.x contains enough information for someone who has a solid understanding of both Revolution and SQL databases. If you are new to databases then you may have difficulties because there isn't an "Introduction to SQL Databases and Revolution using libDatabase" article. I would love to write one someday but I don't know when that will happen. Also, I highly recommend using version 2 of the libDatabase library (available from the same page as version 1). Version 2 does not have an example stack but there is a getting started doc which describes the differences between version 1 and 2 along with code explaining the main functionality. All I want is a simple database in order to build a prototype application to take to a prospective client and try to convince them to buy into the project. I need to store and retrieve via the following fields: Name | Type | Size | ImageFilePathName I have a CD with around 200,000 objects on it that I want to enter into the database. I don't want to lay out a lot of money at this stage nor do I want to have a massive learning curve to get it working. If I get the go ahead on the project then the database will be extended, a run time license purchased and I will of course be prepared to invest a lot of time learning about it. But right now, time is of the essence and I just want to get something up and running ASAP! I don't know that you can get around a learning curve given the current state of things, even to just have the 4 fields that you desire. Given that time is of the essence and this seems to be a prototype I would bypass SQL altogether. Just use a card database to store the information (do you need all 200,000 records for the prototype?) and show proof of concept. If you get the go ahead then you can learn about SQL databases and implement one in your project. SQL is an incredibly powerful way to manage your data so it is definitely worth learning about IMO. I tried that already! They like what they see as implemented as a Card Database. An SQL database is the main feature of the app and something that I said (maybe by mistake) would be no problem under RunRev. The rest of the app I coded really quickly and have it working just fine, now all they want is to see it working with an SQL database. They will use the SQL database with other applications, not just the one I am working on. All my Stack needs to do is: 1. Create the Database. I have a list of image files in a folder, the name field is the name of the file, the Type and Size fields are determined by looking up the name in a text file and the path is just the local path to the image file. This operation can (and will be slow) but this is acceptable since it will only be performed once. 2. Retrieve from the Database. The user enters a name, the record with this name is returned. Is this really a massive learning curve? I have until Monday to get this and some other purely RunRev stuff working, surely that's enough time to do this? Thanks again All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/li
Re: 2.7 BUG: Getting Started with a Database
Hi, Thanks for this. One other thing that doesn't work correctly is when you press one of the buttons to call up RunRev's documentation. If you do this it fails with an error. Just heads-up. All the Best Dave On 14 Feb 2006, at 22:12, Chipp Walters wrote: Hi David and Scott, altSQLite3 does work fine with 2.7. Just tested it, but you have to know where to install the DLL/bundle to. Find the folder where Rev in installed, then be sure and copy the bundle/DLL to the folder below. /Externals/Database Drivers Next, update your database drives.txt file to have the last line read: altSQLite3,dbsqlite3.dll so it will appear in the standalone settings for proper inclusion into the standalone. NOTE!!! Currently, standalone inclusion of 3rd party database drivers DOES NOT APPEAR TO WORK IN Rev 2.7. RunRev is aware of this problem and is working on fixing it. So..the workaround is to manually copy the dbsqlite3.dll to your folder named: /Externals/Database Drivers inside your standalone application folder. I assume the same is true for Mac, though I haven't tested it yet. Once this is done, everything should work fine. We will be upgrading the altSQLite3 Demo stack to manage this process automatically (other than the standalone builder bug). best, Chipp ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/15/06, David Burgun <[EMAIL PROTECTED]> wrote:
>
> I have now looked that three database solutions and none of them seem
> to work and there seems to be very little "getting-started"
> information supplied with them.
>
Just confirm that you have a copy of the MySQL reference manual. I can't
remember if this is part of the 'full download', if not you can download it
here:
http://dev.mysql.com/doc/
I use the pdf version as Preview makes it extremely fast (after a slow
opening as the file is HUGE) to "find" terms.
Chapter 3 is a very straight forward 'Tutorial' which you can do through the
Terminal, although as previously posted CocoaMySQL is your friend and I
can't emphasis enough how easy this makes life.
If you are having troubles right from the start of the Tutorial then back
track to Chapter 2 which covers installation and a few possible problems
that you may encounter.
Once you have a functional installation, and confirmed that you can connect
locally, with CocoaMySQL the learning curve needed to create, add, update
and query the database that you describe will be minor.
For your initial setup of CocoaMySQL the enteries will be:
Host: localhost
User: root
Password: [yourpassword]
NOTE: the installation instruction for MySQL make it clear that after a
virgin install the root account (which is the MySQL root account NOT the OSX
root account so the password can be different) has no password but your
first action should be to allocate a password for the account.
Once connected you will have only one DB to look at, the mysql DB which you
shouldn't touch for a while until you understand what it does - but
basically it keeps a DB on all the users and DBs you create with MySQL.
>From here you are a DB Demi-god, you can use the CocoaMySQL GUI to create,
in your case:
1 x db
1 x table
4 or 5 fields (you might consider an Id field unless the Name field can be
guaranteed to be unique in all cases)
My guess would be that apart from your Id and Size field ( which would be
unsigned INTegers) your fields would be VARCHAR with sizes varying from 4
for the Type, to 256 for the ImageFilePathName (although this could be
limiting if the path names are very very long - so you might need a TEXT
field).
Initially, to make troubleshooting easy, I'd suggest you allow all fields to
be NULL.
Once you have CocoaMySQL (or Terminal) and MySQL talking to each other and
you have created your DB, the I recommend you use Rev WITHOUT Trevor's libDB
to confirm that you can use the Rev DB calls (not the DB Query Builder) to
communicate with MySQL. This should be a quick simple stack with 4 or 5
fields a button called something appropriate like 'Add Data'. In your button
you should have these calls:
-- this assumes that your db is called myTestDb, your MySQL root account
password is myTestDbPassword and your stack is called MyStack
-- this is a 9 line script so be carefull of where line breaks have occured
on mouseUp
if (the propDbRef of stack "MyStack" = "") then
set the propDbRef of stack "MyStack" to
revOpenDatabase("MySQL",,"myTestDb","root","myTestDbPassword")
end if
put "INSERT INTO myTestDB (ID,Name,Type,SizeImageFilePathName) VALUES (" &
quote & field "ID" of stack "MyStack" & quote & comma & quote & field "Name"
of stack "MyStack" & quote & comma & quote & field "Size" of stack "MyStack"
& quote & comma & quote & field "ImageFilePathName" of stack "MyStack" &
quote & ")"
revExecuteSQL the propDbRef of stack "MyStack",tMyDbQuery
on mouseUp
Use the debugger and Variable Watcher to step through the script to see what
tMyDbQuery looks like.
You should then be able to change all the data in the fields and press the
"Add Data" button at your hearts content and then confirm the data entered
your Db by using the 'Content' pane of CocoaMySQL. Note that to see the
updates you will need to deselect your Test DB and select it again to get an
updated view of the Db.
Having achieved this you can then go ahead an use Trevor's excellent libDb
knowing that MySQL works, you have a Db that has data, and Rev can
communicate with the Db. From here on any failures to add,alter or retrieve
data will be a failure in your own code - reassuring isn't it;-)
HTH
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
2.7 BUG: Getting Started with a Database
Hi David and Scott, altSQLite3 does work fine with 2.7. Just tested it, but you have to know where to install the DLL/bundle to. Find the folder where Rev in installed, then be sure and copy the bundle/DLL to the folder below. /Externals/Database Drivers Next, update your database drives.txt file to have the last line read: altSQLite3,dbsqlite3.dll so it will appear in the standalone settings for proper inclusion into the standalone. NOTE!!! Currently, standalone inclusion of 3rd party database drivers DOES NOT APPEAR TO WORK IN Rev 2.7. RunRev is aware of this problem and is working on fixing it. So..the workaround is to manually copy the dbsqlite3.dll to your folder named: /Externals/Database Drivers inside your standalone application folder. I assume the same is true for Mac, though I haven't tested it yet. Once this is done, everything should work fine. We will be upgrading the altSQLite3 Demo stack to manage this process automatically (other than the standalone builder bug). best, Chipp ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Getting Started with a Database
Hi David, The restriction is that you can't incorporate the trial key in your own application. You must buy a license. I've not tested on 2.7 as yet so I can't suggest what may be the problem there. Needless to say Chipp and co' will fix it if it is indeed a problem... Scott -Original Message- From: David Burgun [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 February 2006 3:48 AM To: [EMAIL PROTECTED]; How to use Revolution Subject: Re: Getting Started with a Database Hi, I downloaded and installed this and running the test stack: go URL "http://www.gadgetplugins.com/altsqlite/SQLite3Demo.rev"; seems to work ok, this (although there are problems running under RunRev 2.7, so I am using 2.6.1). I can't seem to find out what the restrictions are on the Demo copy?? Thanks a lot All the Best Dave On 13 Feb 2006, at 19:55, Scott Kane wrote: Hi David, Not sure if it has been mentioned or not to you, but I heartly recommend altSQLite. It's zero configuration (database can be in the same folder as your binary). it's pretty lean and is fast enough for the number of records you are looking at. Check it out at: http://www.altuit.com Scott Kane ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi David, It looks like you haven't created the recipes database in MySQL. Did you import the recipes.sql file into your MySQL database? I am really not sure what I have to do. I downloaded libDatabase_2.zip. This expanded into a folder called "libDatabase 2.0" which contains the following files and folders: libDatabase.rev Change Log.txt docs folder bmm-code.css Getting Started.pdf libDatabase Handlers.html I then downloaded: recipes.rev recipes.sql and put them in the "libDatabase 2.0" folder. I then double-clicked the "recipes.rev" file and got the message: "libdberr: unable to connect to database (Unknown database 'recipes')". I am not sure how to import recipes.sql into the MySQL database and can't seem to find any information on how to do it anywhere. A couple of things to address here. Creating the database The recipes.rev file assumes that you have already created the recipes table in your MySQL database. That is what the recipes.sql file is for. I did a search on google on the phrase "import sql into mysql" and there were some useful results. Some people mentioned some MySQL database editors you could download. Those will have the ability to import a sql file through a menu option. In CocoaMySQL it is File->Import->CocoaMySQL dump. libDatabase 2.0 The recipes.rev stack will not work with libDatabase 2.x as there were some changes to the API which made the two incompatible. libDatabase 2.x is marked as beta mainly because I haven't had time to put together example stacks, etc. If you use the recipes.rev stack with libDatabase 1.x and understand the concepts then switching to libDatabase 2.x in your project should be very easy. I have now looked that three database solutions and none of them seem to work and there seems to be very little "getting-started" information supplied with them. libDatabase does work, it just doesn't have any good introduction to databases documentation/examples with it. I believe the Getting Started guide that comes with libDatabase 2.x contains enough information for someone who has a solid understanding of both Revolution and SQL databases. If you are new to databases then you may have difficulties because there isn't an "Introduction to SQL Databases and Revolution using libDatabase" article. I would love to write one someday but I don't know when that will happen. Also, I highly recommend using version 2 of the libDatabase library (available from the same page as version 1). Version 2 does not have an example stack but there is a getting started doc which describes the differences between version 1 and 2 along with code explaining the main functionality. All I want is a simple database in order to build a prototype application to take to a prospective client and try to convince them to buy into the project. I need to store and retrieve via the following fields: Name | Type | Size | ImageFilePathName I have a CD with around 200,000 objects on it that I want to enter into the database. I don't want to lay out a lot of money at this stage nor do I want to have a massive learning curve to get it working. If I get the go ahead on the project then the database will be extended, a run time license purchased and I will of course be prepared to invest a lot of time learning about it. But right now, time is of the essence and I just want to get something up and running ASAP! I don't know that you can get around a learning curve given the current state of things, even to just have the 4 fields that you desire. Given that time is of the essence and this seems to be a prototype I would bypass SQL altogether. Just use a card database to store the information (do you need all 200,000 records for the prototype?) and show proof of concept. If you get the go ahead then you can learn about SQL databases and implement one in your project. SQL is an incredibly powerful way to manage your data so it is definitely worth learning about IMO. -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi, I downloaded and installed this and running the test stack: go URL "http://www.gadgetplugins.com/altsqlite/SQLite3Demo.rev"; seems to work ok, this (although there are problems running under RunRev 2.7, so I am using 2.6.1). I can't seem to find out what the restrictions are on the Demo copy?? Thanks a lot All the Best Dave On 13 Feb 2006, at 19:55, Scott Kane wrote: Hi David, Not sure if it has been mentioned or not to you, but I heartly recommend altSQLite. It's zero configuration (database can be in the same folder as your binary). it's pretty lean and is fast enough for the number of records you are looking at. Check it out at: http://www.altuit.com Scott Kane ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi Trevor, Thanks for taking the time to reply on this. On 13 Feb 2006, at 18:41, Trevor DeVore wrote: On Feb 13, 2006, at 5:52 AM, David Burgun wrote: Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the "recipes.rev" stack, I get an error: "libdberr: unable to connect to database (Unknown database 'recipes')". Hi David, It looks like you haven't created the recipes database in MySQL. Did you import the recipes.sql file into your MySQL database? I am really not sure what I have to do. I downloaded libDatabase_2.zip. This expanded into a folder called "libDatabase 2.0" which contains the following files and folders: libDatabase.rev Change Log.txt docs folder bmm-code.css Getting Started.pdf libDatabase Handlers.html I then downloaded: recipes.rev recipes.sql and put them in the "libDatabase 2.0" folder. I then double-clicked the "recipes.rev" file and got the message: "libdberr: unable to connect to database (Unknown database 'recipes')". I am not sure how to import recipes.sql into the MySQL database and can't seem to find any information on how to do it anywhere. I have now looked that three database solutions and none of them seem to work and there seems to be very little "getting-started" information supplied with them. Also, I highly recommend using version 2 of the libDatabase library (available from the same page as version 1). Version 2 does not have an example stack but there is a getting started doc which describes the differences between version 1 and 2 along with code explaining the main functionality. All I want is a simple database in order to build a prototype application to take to a prospective client and try to convince them to buy into the project. I need to store and retrieve via the following fields: Name | Type | Size | ImageFilePathName I have a CD with around 200,000 objects on it that I want to enter into the database. I don't want to lay out a lot of money at this stage nor do I want to have a massive learning curve to get it working. If I get the go ahead on the project then the database will be extended, a run time license purchased and I will of course be prepared to invest a lot of time learning about it. But right now, time is of the essence and I just want to get something up and running ASAP! Thanks for all your help and sorry for not replying sooner, the list was broken for me as far as sending was concerned. All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi Ruslan and all, ... We keep Ruslan on a pure caffeine drip 24 hours a day :-) :-) last 10 years it seems the most funny ever description of you and your amazing 24/7 work has been on the old Paradigma website: A user wrote: ## The amazing thing about Paradigma is their support AI, a program called RUSLAN. It is a real breakthrough for Ukranian computer science, because it seems to have passed the Turing test in almost every respect. It jokes, it pretends to be not too fluent in English, it answers questions on deep technical issues, it plans ahead and claims to write software. It has even dropped mysterious references to having a girlfriend, though some say that the database program called Valentina may be the real object of affection. The only giveaway is that it is too fast, sometimes solutions seems to be to be implemented even before the question is asked. So join us on the Valentina support list and see if you can make Ruslan give himself away. Oh yes, Valentina, the fast, scriptable Macintosh database engine with lots of APIs isn't too bad either... ### :-D Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] Best from germanksi Klaus Major [EMAIL PROTECTED] http://www.major-k.de ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/14/06 5:44 AM, "Lynn Fredricks" <[EMAIL PROTECTED]> wrote: Hi Kay, Hi Lynn, >> PS Ruslan I noted your earlier post and as I stated in my >> last after a little more trouble shooting I may need to post >> my problem. I am registered with the Valentina list and I >> must ask do you ever sleep? Your support is phenomenal - some Thank you. >> of the Rev officials could take a lesson of making more >> regular appearances on this list. Lastly though, as stated by >> Stephen, having a working 'utility client' is essential in >> getting past the chicken and the egg and so without an >> equivalent 'CocoaValentina' it is taking me a little longer >> to troubleshoot my current problem - hard to tell is it Rev, >> my code or Valentina. > Valentina Studio has been getting updates fairly regularly, so if there's an > issue there it will be solved. Right. Btw good news, Valentina Studio already works in Universal Binary format. > We keep Ruslan on a pure caffeine drip 24 hours a day :-) :-) last 10 years it seems -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Getting Started with a Database
> PS Ruslan I noted your earlier post and as I stated in my > last after a little more trouble shooting I may need to post > my problem. I am registered with the Valentina list and I > must ask do you ever sleep? Your support is phenomenal - some > of the Rev officials could take a lesson of making more > regular appearances on this list. Lastly though, as stated by > Stephen, having a working 'utility client' is essential in > getting past the chicken and the egg and so without an > equivalent 'CocoaValentina' it is taking me a little longer > to troubleshoot my current problem - hard to tell is it Rev, > my code or Valentina. > > PPS Before trouble shooting I now have Rev 2.7 to download > and test drive. > Thanks Rev team. Valentina Studio has been getting updates fairly regularly, so if there's an issue there it will be solved. We keep Ruslan on a pure caffeine drip 24 hours a day :-) Best regards, Lynn Fredricks President Paradigma Software, Inc Joining Worlds of Information Deploy True Client-Server Database Solutions Royalty Free with Valentina Developer Network http://www.paradigmasoft.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/14/06, Stephen Barncard <[EMAIL PROTECTED]> wrote: > > I agree, a working SQL client is essential to get past the 'chicken > and egg' of develop an app without data. > > I loved and used CocoaMySQL for years, but the version at the > sourceforge link will break with 10.3.4 and above and most certainly > Tiger. Just stops functioning. > I'm very pleased to say I have to disagree. I'm using: CocoaMySQL 0.5 MySQL 4.0.25 (have the new 5 download but haven't yet swapped over) OSX 10.4.4 Rev 2.6.1 (will download 2.7 as soon as I can get off this list;-) all of which has been performing rock solidly. PS Ruslan I noted your earlier post and as I stated in my last after a little more trouble shooting I may need to post my problem. I am registered with the Valentina list and I must ask do you ever sleep? Your support is phenomenal - some of the Rev officials could take a lesson of making more regular appearances on this list. Lastly though, as stated by Stephen, having a working 'utility client' is essential in getting past the chicken and the egg and so without an equivalent 'CocoaValentina' it is taking me a little longer to troubleshoot my current problem - hard to tell is it Rev, my code or Valentina. PPS Before trouble shooting I now have Rev 2.7 to download and test drive. Thanks Rev team. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
I agree, a working SQL client is essential to get past the 'chicken and egg' of develop an app without data. I loved and used CocoaMySQL for years, but the version at the sourceforge link will break with 10.3.4 and above and most certainly Tiger. Just stops functioning. use this link instead: http://www.theonline.org/cocoamysql/ The 0.6.5 version works fairly well. There's also a beta .7 version that will be eventually work with MySQL 5. These days I use NAVICAT. A bit more robust, but it's a commercial product, not donationware. sqb May I also suggest you get a copy of the donationware CocoaMySQL: http://cocoamysql.sourceforge.net/ It makes it extremely easy to determine if your MySQL is set up correctly - although if it isn't you still have to nut out what the problem is. Best of -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
May I also suggest you get a copy of the donationware CocoaMySQL: http://cocoamysql.sourceforge.net/ It makes it extremely easy to determine if your MySQL is set up correctly - although if it isn't you still have to nut out what the problem is. Best of all it makes it very easy to create/modify quick 'test' (or in use) dbs,tables,fields,records. Once you know the db exists and can be communicated with correctly getting Rev to talk to the db I think you'll find is relatively simple. HTH PS As far as cheap and easy dbs MySQL + Rev gets two thumbs up. I am currently working on Valentina 1.11 + Rev but have run into some problems which I will probably be posting about shortly - just one more line of trouble shooting to follow before I seek profesional help from the list:-). AltSQLite I can't comment on because my definition of cheap is $0 but once I get Valentina working I am hoping to give the AltSQLite Demo stack a whirl, just for the experience,but at the end of the day I can't justify the price - my dbs are all for me, if I actualy made dbs for other people I'd probably have a completely different answer. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Getting Started with a Database
Hi David, Not sure if it has been mentioned or not to you, but I heartly recommend altSQLite. It's zero configuration (database can be in the same folder as your binary). it's pretty lean and is fast enough for the number of records you are looking at. Check it out at: http://www.altuit.com Scott Kane ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On Feb 13, 2006, at 5:52 AM, David Burgun wrote: Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the "recipes.rev" stack, I get an error: "libdberr: unable to connect to database (Unknown database 'recipes')". Hi David, It looks like you haven't created the recipes database in MySQL. Did you import the recipes.sql file into your MySQL database? Also, I highly recommend using version 2 of the libDatabase library (available from the same page as version 1). Version 2 does not have an example stack but there is a getting started doc which describes the differences between version 1 and 2 along with code explaining the main functionality. -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/12/06, David Burgun <[EMAIL PROTECTED]> wrote: > > Hi, > > What is the issue number? I looked at issue 166 (http:// > www.macformat.co.uk/) but couldn't see anything about Valentina and I > can't seem to find details on the February issue. Yes, you want issue 165, the Feb issue. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi, Yes, I am running on Mac for the moment, the app will eventually be deployed on Mac and Windows. Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the "recipes.rev" stack, I get an error: "libdberr: unable to connect to database (Unknown database 'recipes')". I can't seem to find any documentation of what is supposed to happen or if I am supposed to change anything. I looked in the registerDatabase handler in the stack script and this seems to be setup ok for MySQL. Right now I'm not sure if I have the right MySQL package installed, I got my copy from: http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-standard-4.0.26- apple-darwin7.9.0-powerpc.dmg/from/pick and it seemed to install just fine. I have the following files in a folder and am running from this folder: libDatabase.rev recipes.rev recipes.sql I have stepped thru recipes.rev and it loads and calls libDatabase.rev ok. Do I need to change anything to get this to work? Thanks a lot All the Best Dave On 11 Feb 2006, at 16:18, Charles Hartman wrote: What platform? On OSX I was in a similar position recently, and I settled for MySQL (downloadable) with Blue Mango's (Trevor DeVore's) libDatabase 2.0 (ditto). This way's free. The libDatabase isn't strictly necessary (it's a wrapper around revdb functions), but it makes things a *lot* simpler and more rational. Charles On Feb 11, 2006, at 7:52 AM, David Burgun wrote: Hi All, I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database locally. b) Retrieve records based on the contents of a number for fields. c) Modify existing records in the database. The database will contain around 100,000 to 300,000 records. Thanks a lot for any help All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi, Yes, I am running on Mac for the moment, the app will eventually be deployed on Mac and Windows. Haven't had much luck in getting this to work. I downloaded and installed MySQL. I then downloaded libDatabase and sample stack called libdb_recipes. When I run up the "recipes.rev" stack, I get an error: "libdberr: unable to connect to database (Unknown database 'recipes')". I can't seem to find any documentation of what is supposed to happen or if I am supposed to change anything. I looked in the registerDatabase handler in the stack script and this seems to be setup ok for MySQL. Right now I'm not sure if I have the right MySQL package installed, I got my copy from: http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-standard-4.0.26- apple-darwin7.9.0-powerpc.dmg/from/pick and it seemed to install just fine. I have the following files in a folder and am running from this folder: libDatabase.rev recipes.rev recipes.sql I have stepped thru recipes.rev and it loads and calls libDatabase.rev ok. Do I need to change anything to get this to work? Thanks a lot All the Best Dave On 11 Feb 2006, at 16:18, Charles Hartman wrote: What platform? On OSX I was in a similar position recently, and I settled for MySQL (downloadable) with Blue Mango's (Trevor DeVore's) libDatabase 2.0 (ditto). This way's free. The libDatabase isn't strictly necessary (it's a wrapper around revdb functions), but it makes things a *lot* simpler and more rational. Charles On Feb 11, 2006, at 7:52 AM, David Burgun wrote: Hi All, I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database locally. b) Retrieve records based on the contents of a number for fields. c) Modify existing records in the database. The database will contain around 100,000 to 300,000 records. Thanks a lot for any help All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
Hi, What is the issue number? I looked at issue 166 (http:// www.macformat.co.uk/) but couldn't see anything about Valentina and I can't seem to find details on the February issue. Thanks a lot Dave On 11 Feb 2006, at 15:43, Lynn Fredricks wrote: I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database locally. b) Retrieve records based on the contents of a number for fields. c) Modify existing records in the database. The database will contain around 100,000 to 300,000 records. Are you on the Mac? If so, MacFormat has a tutorial/bundle of Rev 2.2 and Valentina 1.x XCMD. Best regards, Lynn Fredricks President Paradigma Software, Inc Joining Worlds of Information Deploy True Client-Server Database Solutions Royalty Free with Valentina Developer Network http://www.paradigmasoft.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
What platform? On OSX I was in a similar position recently, and I settled for MySQL (downloadable) with Blue Mango's (Trevor DeVore's) libDatabase 2.0 (ditto). This way's free. The libDatabase isn't strictly necessary (it's a wrapper around revdb functions), but it makes things a *lot* simpler and more rational. Charles On Feb 11, 2006, at 7:52 AM, David Burgun wrote: Hi All, I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database locally. b) Retrieve records based on the contents of a number for fields. c) Modify existing records in the database. The database will contain around 100,000 to 300,000 records. Thanks a lot for any help All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting Started with a Database
On 2/11/06 5:43 PM, "Lynn Fredricks" <[EMAIL PROTECTED]> wrote: Hi Dave, >> I have worked on Rev for a while but have not used it with a >> database application before and was wondering the easiest and >> cheapest way to get going with it. I have the following basic >> questions: >> >> What do I need to Add to RunRev to be able to: >>a) Create and Add data to a database locally. >>b) Retrieve records based on the contents of a number for fields. >>c) Modify existing records in the database. >> >> The database will contain around 100,000 to 300,000 records. > > Are you on the Mac? If so, MacFormat has a tutorial/bundle of Rev 2.2 and > Valentina 1.x XCMD. In other words, this means that you can get Valentina 1.x XCMD license for FREE if you get this issue of MacFormat magazine. Also I will recommend to use library of Trevor Devore in your application. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Getting Started with a Database
> I have worked on Rev for a while but have not used it with a > database application before and was wondering the easiest and > cheapest way to get going with it. I have the following basic > questions: > > What do I need to Add to RunRev to be able to: >a) Create and Add data to a database locally. >b) Retrieve records based on the contents of a number for fields. >c) Modify existing records in the database. > > The database will contain around 100,000 to 300,000 records. Are you on the Mac? If so, MacFormat has a tutorial/bundle of Rev 2.2 and Valentina 1.x XCMD. Best regards, Lynn Fredricks President Paradigma Software, Inc Joining Worlds of Information Deploy True Client-Server Database Solutions Royalty Free with Valentina Developer Network http://www.paradigmasoft.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Getting Started with a Database
Hi All, I have worked on Rev for a while but have not used it with a database application before and was wondering the easiest and cheapest way to get going with it. I have the following basic questions: What do I need to Add to RunRev to be able to: a) Create and Add data to a database locally. b) Retrieve records based on the contents of a number for fields. c) Modify existing records in the database. The database will contain around 100,000 to 300,000 records. Thanks a lot for any help All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
