REBOL and MySql
[1/8] from: jr::brainbyte::com at: 3-Dec-2000 17:25
Anyone have any success interfacing with REBOL to MySql?
If so, let me know.
Thanks,
Jeff
[2/8] from: sqlab:gmx at: 4-Dec-2000 10:41
I have almost finished a interface to Cache4.0.
I used the sqlproxy of Galt Barber as a starting point.
AR
> Anyone have any success interfacing with REBOL to MySql?
>
> If so, let me know.
>
> Thanks,
>
> Jeff
> --
--
Sent through GMX FreeMail - http://www.gmx.net
[3/8] from: ticksoft:freesiteuk at: 4-Dec-2000 13:15
Hi,
>Anyone have any success interfacing with REBOL to MySql?
I don't think you can connect directly to MySQL with
REBOL, I think you have to use ODBC. Which is the why
I am currently learning PHP to rewrite my site.
==
All the best,
--
Malcolm Campbell
[malcolm--freesiteuk--com]
FreesiteUK - http://www.freesiteuk.com
The UK based searchable web directory of free internet services.
_____________________________________________________________
Win a Sony Playstation 2 with FreesiteUK and dooyoo! Enter by visiting:
http://www.freesiteuk.com/index.cgi?244724062;INFO (UK residents only)
[4/8] from: petr:krenzelok:trz:cz at: 4-Dec-2000 22:35
----- Original Message -----
From: Malcolm Campbell <[ticksoft--freesiteuk--co--uk]>
To: <[rebol-list--rebol--com]>
Sent: Monday, December 04, 2000 10:15 PM
Subject: [REBOL] Re: REBOL and MySql
> Hi,
>
> >Anyone have any success interfacing with REBOL to MySql?
>
> I don't think you can connect directly to MySQL with
> REBOL, I think you have to use ODBC. Which is the why
> I am currently learning PHP to rewrite my site.
what about socket communication, possible?
-pekr-
[5/8] from: dlhawley:home at: 4-Dec-2000 13:54
Previously, you (Petr Krenzelok) wrote:
> ----- Original Message -----
> From: Malcolm Campbell <[ticksoft--freesiteuk--co--uk]>
<<quoted lines omitted: 9>>
> > I am currently learning PHP to rewrite my site.
> what about socket communication, possible?
It should be fairly straight forward, but perhaps a bit inefficient to interface MySQL
using the mysql program - perhaps via litle-bell.r (a telnet client).
--
David L. Hawley D.L. Hawley and Associates 1.503.274.2242
Software Engineer [David--L--Hawley--computer--org]
[6/8] from: mike:yaunish:home at: 4-Dec-2000 20:04
At 10:35 PM 04/12/00 +0100, you wrote:
Here is a copy of a message form a while ago that may help.
From: Jamey Cribbs <[cribbsj--oakwood--org]>
To: [list--rebol--com]
Subject: [REBOL] A word to all novice port programmers
Date: Thu, 19 Oct 2000 15:41:48 -0400
X-Mailer: KMail [version 1.0.29]
X-archive-position: 43
X-original-sender: [cribbsj--oakwood--org]
Reply-to: [rebol-list--rebol--com]
This message goes out to all you who, like me, are novices when it comes to
using ports to communicate between your Rebol script and other programs.
I am in the process of learning Rebol. I have been writing some small
applications that use text files to store any data needed.
Because Core does not allow you to run system commands and because I do not
yet
have much experience using ports to communicate, I thought that I would
have to
wait until I purchased Command or someone wrote a script that connected
Core to
MySQL (or the like) via ports.
Then I found MDBMS (www.hinttech.com). This is a very small, simple DBMS
written by a guy named Marty Bochane. Basically, you start it up on a Linux
box, then you can communicate to it interactively using telnet.
But, wait, it gets better. MDBMS has a little utility called FOP (Fast
Opendatabase Protocol). FOP allows you to open a port (default 2224) to your
MDBMS database and interact with it via simple ASCII strings terminated by
newlines.
Using FOP, I was able to very easily open up a port while in Rebol, send sql
queries to my MDBMS database, and receive the result set. It was so cool!
Here I was, a guy who knows VERY little about port programming, basically
building a client/server app in less than 30 minutes.
I know that this will be very mundane, basic stuff to the people on this list
that have a lot of port programming experience. But, if you are a novice like
me, this might be a way to get your feet wet in this subject. I know I am
already learning a lot.
I guess this is also a testament to Rebol's incredible knack for making things
easy to do. The ability you have to easily open, read from, and write to ports
is incredible!
Anyway, just thought I would pass this info along.
--
Jamey Cribbs
>----- Original Message -----
>From: Malcolm Campbell <[ticksoft--freesiteuk--co--uk]>
<<quoted lines omitted: 28>>
>[rebol-request--rebol--com] with "unsubscribe" in the
>subject, without the quotes.
Mike Yaunish
[mike--yaunish--home--com]
[7/8] from: fsievert:uos at: 5-Dec-2000 9:11
On Mon, 4 Dec 2000, David Hawley wrote:
> > > I don't think you can connect directly to MySQL with
> > > REBOL, I think you have to use ODBC. Which is the why
> > > I am currently learning PHP to rewrite my site.
> >
> > what about socket communication, possible?
>
> It should be fairly straight forward, but perhaps a bit inefficient to interface MySQL
using the mysql program - perhaps via litle-bell.r (a telnet client).
I've written a java server, which provides the connection to the database
for REBOL. The package is called "dbridge" and it has two parts:
- dbridge.r
Provides the dridge:// protocol. You can connect to a database using
something like:
open dbridge://user:passe/server/database
- dbridge.class
The Java side uses jdbc-drivers to connect to the database. It is works at
least with postgres and mysql. I am using both.
If you want this package, send me an email, but I don't have the time to
give any support for it.
CU,
Frank
[8/8] from: listbot:scj at: 5-Dec-2000 6:14
Hello Frank,
I have been trying to get MySQL working and your script would be a
welcome addition! Could you please send me the dbridge scripts you
mentioned. Thanks so much!
Regards,
Sean C. Johnson
<mailto:[sean--scj--net]>
FS> I've written a java server, which provides the connection to the database
FS> for REBOL. The package is called "dbridge" and it has two parts:
FS> - dbridge.r
FS> Provides the dridge:// protocol. You can connect to a database using
FS> something like:
FS> open dbridge://user:passe/server/database
FS> - dbridge.class
FS> The Java side uses jdbc-drivers to connect to the database. It is works at
FS> least with postgres and mysql. I am using both.
FS> If you want this package, send me an email, but I don't have the time to
FS> give any support for it.
FS> CU,
FS> Frank
--
Best regards,
ListBot mailto:[ListBot--scj--net]
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted