[REBOL] Find Speed/Database Re:(3)
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
> 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".
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-