Getting Started with a Database

[David Burgun]

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