Find Speed/Database
[1/8] from: news::ted::husted::com at: 1-Aug-2000 15:25
[Petr--Krenzelok--trz--cz]!
> so where's a link to MySQL and PostGresSQL socket connectivity
[giesse--writeme--com]
> BTW, if you write a MySQL protocol handler, I could find a good use
for it... :-)
[tim--johnsons-web--com]
> It would be great to connect rebol to MySql, but then I don't know if
MySql runs on as many platform as does rebol/core
If Command had MySQL support out of the box, I could put it to work on
paying projects the day it ships. (I get paid, Carl gets paid.)
Without MySQL support, REBOL is still a hobby (sigh), leaving me
stranded in the JSP/PHP zones.
-- Ted Husted, Husted dot Com, Fairport NY USA.
-- Custom Software ~ Technical Services.
-- Tel 716 425-0252; Fax 716 223-2506.
-- http://www.husted.com/
[2/8] from: petr:krenzelok:trz:cz at: 2-Aug-2000 6:14
[news--ted--husted--com] wrote:
> [Petr--Krenzelok--trz--cz]!
> > so where's a link to MySQL and PostGresSQL socket connectivity
<<quoted lines omitted: 8>>
> Without MySQL support, REBOL is still a hobby (sigh), leaving me
> stranded in the JSP/PHP zones.
I can see two fundamental problems here -
- how fast is ODBC connectivity in comparison to native one?
- we don't know /Command pricing yet, but sadly - I still think shell
access and library calls at least belong to /Core, or at least should be
free. ODBC should cost some little money and native drivers (e.g. Oracle,
DB2 components) could cost much higher. Let's see what pricing policy will
RTcome with, but being it one way or another - your PHP "native" connection
to MySQL will be always free ...
If REBOL/Command is priced more than 50-100 in the tool level, It will be
time to try to write socket connection protocols for /Core (if MySQL,
PostGresSQL etc. allow this) or simply stay with PHP for e.g., as I can't
imagine I tell my boss we should pay for something, just because I like it,
if all I need is ASP, PHP level thingy ...
Regards,
-pekr-
[3/8] from: robert:muench:robertmuench at: 2-Aug-2000 0:55
> -----Original Message-----
> From: [news--ted--husted--com] [mailto:[news--ted--husted--com]]
<<quoted lines omitted: 5>>
> paid.) Without MySQL support, REBOL is still a hobby (sigh), leaving
> me stranded in the JSP/PHP zones.
Hi, where is the problem? I'm using MySQL (via ODBC) and it works
perfectly (at least for what I did test). Robert
[4/8] from: robert:muench:robertmuench at: 2-Aug-2000 0:59
> -----Original Message-----
> From: [Petr--Krenzelok--trz--cz] [mailto:[Petr--Krenzelok--trz--cz]]
> Sent: Wednesday, August 02, 2000 6:15 AM
> To: [list--rebol--com]
> Subject: [REBOL] Find Speed/Database Re:(2)
> - how fast is ODBC connectivity in comparison to native one?
Hi, what I have seen so far it's not that bad. ODBC is mainly a
translation layer, so quite thin. It might be a bigger problem, that
you can't use all available features.
> - we don't know /Command pricing yet, but sadly - I still
> think shell access and library calls at least belong to /Core, or at
> least should be free.
I agree here! Shell access is the essential piece to use Rebol in
replace for Perl etc. in normal system admin tasks etc.
> ODBC should cost some little money and native drivers
> (e.g. Oracle, DB2 components) could cost much higher. Let's see what
> pricing policy will RTcome with, but being it one way or another -
> your PHP "native" connection to MySQL will be always free ...
I would like to see a way to add our own DB support. Why should RT do
all the work, we can help them. There are a lot of people needing the
same stuff here, so pooling our efforts to get what we need should be
possible. RT should concentrate on the "core" stuff. I don't know
their business-model (hey, perhaps Carl is wealthy enough, and he sees
the RT team like a football team to have fun with ;-)) but I would pay
some $$ (note the number of signs ;-)) to use Rebol in a commercial
environment.
> If REBOL/Command is priced more than 50-100 in the tool
> level, It will be time to try to write socket connection protocols
for
> /Core (if MySQL, PostGresSQL etc. allow this) or simply stay with
PHP
> for e.g., as I can't imagine I tell my boss we should pay for
> something, just because I like it, if all I need is ASP, PHP level
> thingy ...
Well, I agree that this might become a problem. Perhaps RT can
enlighten us a bit about their business model. This information is
quite useful for us too, as I have to tell the people in the field,
how things will proceed, what the company does, that the product
development will be continued etc. This thing isn't only about
technology. Robert
[5/8] from: kracik:mbox:dkm:cz at: 2-Aug-2000 10:50
Hi,
I looked at MySQL a bit. All languages except Java connect to MySQL
with a C library. Java (as well as REBOL) can't do this in a portable
way, so there's a JDBC driver written in Java which connects with a TCP
socket (and a binary protocol). It's available with source (LGPL
licensed) at http://www.worldserver.com/mm.mysql/
The code that's required to connect and issue a SQL command is quite
small and I think it should not be too hard to rewrite in REBOL.
Bigger problem is interpreting record sets in binary and converting
them to some useful REBOL "structures".
--
Michal Kracik
[news--ted--husted--com] wrote:
[6/8] from: petr:krenzelok:trz:cz at: 2-Aug-2000 13:08
[kracik--mbox--dkm--cz] wrote:
> Hi,
> I looked at MySQL a bit. All languages except Java connect to MySQL
<<quoted lines omitted: 6>>
> Bigger problem is interpreting record sets in binary and converting
> them to some useful REBOL "structures".
I looked at mysql.org page yesterday too, but found out only following:
there are two ways of how to configure mysql database for connections:
- you can use unix sockets (connection thru files - faster one)
- connection thru TCP/IP
Now let's expect you can't afford buying /Command version and so connect thru
some native library or /ODBC, so you are left with /Core and TCP/IP
connection or Unix sockets as described above.
So - is let's say TCP/IP connection described anywhere? It has to use some
kind of text based protocol. The question is what form MySQL returns record
set in and how time-consuming parsing/decoding would be.
Maybe even connection thru sockets would not be so difficult to achieve?
Regards,
-pekr-
[7/8] from: kracik:mbox:dkm:cz at: 2-Aug-2000 14:39
Hi,
that's what I tried to explain, maybe not very clearly:
MySQL uses a binary protocol, not text based, probably for speed.
That protocol is AFAIK not documented anywhere, but you can see it in
the source code for MySQL C library (messy), or the source code for
the Java JDBC "driver" (cleaner and simpler).
The mentioned C library can choose faster Unix domain sockets if the
client is on the same machine as the server, or slower TCP sockets if
it's on different; Java JDBC driver always uses TCP sockets.
So I wasn't suggesting using MySQL JDBC or ODBC driver, but writing
REBOL only "driver" that communicates with TCP, with knowledge about
the protocol gained from that Java source code.
Hope it's clearer now...
--
S pozdravem
Michal Kracik
[Petr--Krenzelok--trz--cz] wrote:
[8/8] from: news:ted:husted at: 2-Aug-2000 10:35
On 8/2/2000 at 12:55 AM [robert--muench--robertmuench--de] wrote:
> Hi, where is the problem? I'm using MySQL (via ODBC) and it works
perfectly (at least for what I did test). Robert
I'll give it a try, seems like such a kludge though.
Problem is that I have the Command beta, but I missed the link to the
documentation, so I haven't a clue as to how to use the new features.
-Ted.
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted