Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

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