[REBOL] Re: REBOL and database stuff
From: greggirwin:mindspring at: 30-Mar-2003 10:41
Hi Mat,
MB>> Has anyone done anything like that? Or perhaps you've just done a fair
MB>> bit of database manipulation with REBOL/Command and MySQL and you
MB>> wouldn't mind tossing me the script to take a 'butchers' at as we say
MB>> in my parts.
Have you looked at DocKimbel's MySQL interface. People seem to like
that a lot, though I've done nothing more than read the docs on it
myself.
>> The next example inserts multiple REBOL values into an SQL statement:
>>
>> fname: "Johnny"
>> lname: "Johnson"
>> title: "President"
>> phone: "(707) 555-1212"insert db-port [{
>> INSERT INTO table1 (First, LastName, Title, Phone)
>> values (?, ?, ?, ?)
>> } fname lname title phone
>> ]
Here's an example for Doc's MySQL:
author: "Elan"
title: "Rebol Official Guide"
insert db ["insert into mybooks values (?,?)" author title]
MB> Unfortunately one doesn't appear to be able to substitute 'table1' for
MB> an ? there, so you can't formate a specific table request.
What about using COMPOSE, or REPLACE with a template query string, to
create your SQL statement? Not sure why it might have choked on the
one you created.
MB> Maybe I should have just slapped all my data into one big table rather
MB> than having many. A little counter-intuitive to me though.
You mentioend having 5,000 fields in your first message. What the heck
do you have in there!? ;) Can you provide an idea of what fields are
important, how many records it needs to handle, and how you need it to
work (e.g. do you get lots of updates from somewhere, mostly filtering
to send groups of emails, etc.)
What would you want in a native REBOL database?
-- Gregg
