mySQL driver for /Core
[1/21] from: g:santilli:tiscalinet:it at: 11-Feb-2001 11:35
Hello Petr!
On 11-Feb-01, you wrote:
PK> I've just read some article about PostGressSQL. In its latest
PK> version, PostGressSQL seems to have very strong capabilities,
PK> and some ppl.call it "public" Oracle. It's not probably that
PK> fast as mySQL, but it provides you with transactions.
Postgres seems to be a mixture of a relational and an OO dbms. It
has a very nice documentation... I've been looking into the
protocol, and it wouldn't be very hard to do in REBOL (probably
easier than MySQL, which protocol is almost undocumented AFAIK).
I don't know if I'll find some time to work on it, but I'll let
you know if I will; I'd like to help Nenad on the MySQL driver and
on the Win95Skin too, but I'm unfortunately fighting with VB these
days (have to fix and update a program written by someone else ---
and he/she doesn't seem to be that good as a programmer... :| )
Regards,
Gabriele.
--
Gabriele Santilli <[giesse--writeme--com]> - Amigan - REBOL programmer
Amiga Group Italia sez. L'Aquila -- http://www.amyresource.it/AGI/
[2/21] from: dockimbel::free::fr at: 10-Feb-2001 16:50
Hi guys !
Great day today ! :)
The first public release of my driver for mySQL databases is available on my
rebsite. (Testpanel/Ecotope/Dockimbel) Please read the html doc and scripts
headers before using it. Remember that's in beta stage, so don't expect it
to be perfect ! ;)
Let me know what you think about it and please, send me all bugs reports.
Best regards,
DocKimbel.
[3/21] from: gjones05:mail:orion at: 10-Feb-2001 10:22
Hi, DocKimbel,
This is great! I'm going to be trying this "puppy" (excuse the idiom.) out
as soon as possible on my Windows 98 and MySQL 3.23.24-beta-win test bed.
--Scott
[4/21] from: petr:krenzelok:trz:cz at: 10-Feb-2001 19:27
----- Original Message -----
From: GS Jones <[gjones05--mail--orion--org]>
To: <[rebol-list--rebol--com]>
Sent: Saturday, February 10, 2001 5:22 PM
Subject: [REBOL] Re: mySQL driver for /Core
> Hi, DocKimbel,
>
> This is great! I'm going to be trying this "puppy" (excuse the idiom.)
out
> as soon as possible on my Windows 98 and MySQL 3.23.24-beta-win test bed.
Now it will be interesting to see the speed comparison between PHP Apache
module and CGI script based mySQL protocol. Could anyone test it, please? I
am just curious, nothing more :-)
Well, time to search some very old archive of Rebol/Apache core probably :-)
Cheers,
-pekr-
[5/21] from: dlmayer:telocity at: 10-Feb-2001 14:57
Doc Kimbel...
What is the url of your rebsite? I'm interested.
...Doug
----- Original Message -----
From: Nenad Rakocevic <[dockimbel--free--fr]>
To: <[rebol-list--rebol--com]>
Sent: Saturday, February 10, 2001 7:50 AM
Subject: [REBOL] [ANN] mySQL driver for /Core
Hi guys !
Great day today ! :)
The first public release of my driver for mySQL databases is available on my
rebsite. (Testpanel/Ecotope/Dockimbel) Please read the html doc and scripts
headers before using it. Remember that's in beta stage, so don't expect it
to be perfect ! ;)
Let me know what you think about it and please, send me all bugs reports.
Best regards,
DocKimbel.
[6/21] from: al:bri:xtra at: 11-Feb-2001 9:36
> What is the url of your rebsite? I'm interested.
DocKimbel RebSite is at:
http://rebol.dhs.org/index.r
Andrew Martin
ICQ: 26227169 http://members.nbci.com/AndrewMartin/
[7/21] from: gjones05:mail:orion at: 10-Feb-2001 15:04
From: "Douglas Mayer"
> Doc Kimbel...
>
> What is the url of your rebsite? I'm interested.
>
> ...Doug
Hi, Douglas,
The download is most easily obtained through the /View experiemental "demo"
desktop through the path laid out by DocKimbel below. If you don't have
REBOL/View, then download
http://rebol.dhs.org/mysql-083.rip
and "un"-rip this compressed "rip" ball at the REBOL/Core prompt by typing:
do %/path/to/rip/mysql-083.rip
You will be asked to write a directory with three files if security hasn't
been deactivated.
Hope that does the trick.
--Scott
[8/21] from: larry:ecotope at: 10-Feb-2001 13:18
Hi Doug,
Doc Kimbels rebsite is at http://rebol.dhs.org/index.r
-Larry
[9/21] from: ralph:abooks at: 10-Feb-2001 17:00
It works in CORE!!!!!!!!!!!!!!
This is Heaven!
Thanks, DocKimbel!!! You've come up with something REBOL's need all along!
I love ya, man!
--Ralph Roberts
author of REBOL FOR DUMMIES
[10/21] from: gchiu:compkarori at: 11-Feb-2001 12:00
> It works in CORE!!!!!!!!!!!!!!
>
> This is Heaven!
>
> Thanks, DocKimbel!!! You've come up with something
> REBOL's need all along!
So, what does one do if your ISP doesn't support mySQL?
--
Graham Chiu
[11/21] from: ralph:abooks at: 10-Feb-2001 20:30
>> It works in CORE!!!!!!!!!!!!!!
>>
<<quoted lines omitted: 6>>
>Graham Chiu
>--
I would change ISPs. If they don't have MySQL, they've probably cheaped out
on other stuff as well<g>. And MySQL is free!
--Ralph
[12/21] from: petr:krenzelok:trz:cz at: 11-Feb-2001 5:34
----- Original Message -----
From: Ralph Roberts <[ralph--abooks--com]>
To: <[rebol-list--rebol--com]>
Sent: Sunday, February 11, 2001 2:30 AM
Subject: [REBOL] Re: [ANN] mySQL driver for /Core
> >
> >> It works in CORE!!!!!!!!!!!!!!
<<quoted lines omitted: 10>>
> >--
> I would change ISPs. If they don't have MySQL, they've probably cheaped
out
> on other stuff as well<g>. And MySQL is free!
I've just read some article about PostGressSQL. In its latest version,
PostGressSQL seems to have very strong capabilities, and some ppl.call it
public
Oracle. It's not probably that fast as mySQL, but it provides you
with transactions.
As for Linux databases, it would be good to have mySQL and PostGress at
least. Maybe we could ask RT to re-generate /Apache, basing it upon latest
/Core. Then your mySQL handler would be already pre-loaded, and the Apache
based solution should be also faster ...
I know there are some plans for Apache module for the future, I just hope RT
makes two versions then - first one - /Core based, with DocKimbel's
protocol, second one - based upon some /Command modules - at least /Library
, or maybe even /ODBC (although it's not too common under Linux imo), and I
would even welcome working library wrappers for some databases. The solution
would cost some money of course, and would be for those, who require better
performance.
Having some of following protocols would be interesting too. It just seems
to me the world is accepting XML based solution for info interchange more
and more ..
http://www.w3.org/2000/03/29-XML-protocol-matrix.html
Cheers,
-pekr-
[13/21] from: gjones05:mail:orion at: 10-Feb-2001 22:42
From: "Petr Krenzelok"
> Now it will be interesting to see the speed comparison between PHP Apache
> module and CGI script based mySQL protocol. Could anyone test it, please?
I
> am just curious, nothing more :-)
>
> Well, time to search some very old archive of Rebol/Apache core probably
:-)
> Cheers,
> -pekr-
Hi, Petr and all,
I hadn't realized how rusty my SQL skills had grown until I began tinkering
with MySQL.
First, let me say that working with MySQL through DocKimbel's protocol and
REBOL has been a pleasure. When I compared what I had to do under PHP, it
was a dream come true.
I have a 500 mhz de-Celeron with 128 MB RAM. I am running Windows 98,
Apache 1.3.14 running on localhost (still considered beta on Windows), MySQL
3.23.24 running as mysqld on localhost (still considered beta on Windows),
PHP 4.0.4 running as a module under Apache, REBOL 0.10.38.3.1 and 2.3.0.3.1
I didn't have any readily accessible large database available for my first
day of testing. So I converted what I consider a fairly small 905 record
database that had two text fields into a single table in a MySQL database.
I didn't configure an index for this first run. I created a SELECT on this
table looking for a phrase in the second field with wildcards at either end.
Since the database was so small, I looped my testing for 100 loops so that I
could get some times.
Under REBOL/View from the command prompt, with an open connection, the 100
loop cycle ran about 6-7 seconds. Running it with a new connection for each
iteration, the total time was about 8-9 seconds. Running a similar script
as a cgi script (this time under REBOL 2.3.0.3.1), the 100 loop iteration
took about 8 seconds when a new connection was made with each iteration.
When the connection was left open, it took 2 seconds. A php script
(assuming a did it correctly) took about 3 seconds with a connection that
was left open.
Let me reiterate that I am no expert in SQL, REBOL, PHP, or database
testing, but I am very impressed with the performance of MySQL used through
REBOL and DocKimbel's wonderful scheme. But when I consider usability, the
REBOL-way was vastly superior to PHP. Now, whether there would be an
additional performance boast with mod_rebol or FastCGI and REBOL, I don't
know. I would assume so. But the performance is already pretty good, at
least in my opinion.
Great job, DocKimbel!!!!
--Scott
[14/21] from: gchiu:compkarori at: 11-Feb-2001 17:53
> I would change ISPs. If they don't have MySQL, they've
> probably cheaped out
> on other stuff as well<g>. And MySQL is free!
I've been with them for 6 years. US$25/month. They offer
mSql but at the next level. Guess it's time for a change.
Anyone got any suggestions?
--
Graham Chiu
[15/21] from: terry:depotcity at: 10-Feb-2001 22:58
Been experimenting with the mySQL driver... works GREAT!
Noticed one thing. The line...
db: open mysql://[root--127--0--0--1]/mysql
...took much less time to connect than...
db: open mysql://[root--localhost]/mysql
Running Win2000 server.
Terry Brownell
[16/21] from: fsievert:uos at: 11-Feb-2001 11:49
Hi!
You can use DBridge to connect to postgess. DBridge uses a java-Server to
connect to the database (using jdbc). So you can connect to any
jdbc-compatible database. You can find it at:
http://proton.cl-ki.uni-osnabrueck.de/dbridge/
I also wrote a _simple_ REBOL dialect to simplify SQL with Rebol. Maybe
DocKimbel likes to integrate it to the mysql-Protocol, too? It
automatically replaces newlines etc. by their escaped characters.
Oh, by the way: Great job, Doc!
CU,
Frank
[17/21] from: norsepower:uswest at: 12-Feb-2001 18:17
www.site5.com
500MB hard disk space
27GB bandwidth
mySQL
$30/month
I've been running /Core using this service for CGI. Very good customer
service.
I can't wait to try the mySQL driver on their server!
-Ryan
[18/21] from: ptretter:norcom2000 at: 14-Feb-2001 14:07
They should advertise the REBOL use services. What is the matter with these
ISP's.
Paul Tretter
[19/21] from: javier:aviles:eds at: 10-Apr-2001 10:17
Hi Rebol Gurus,
How can I download the mySQL driver developed by Dockimbel....
Thanks
Javier H. Avilés Avila.
> EDS NMxSC
* [javier--aviles--eds--com]
TEL. 29-09-42 Ext. 56361
[20/21] from: alan_otterstad:mikronvinyl at: 10-Apr-2001 8:36
I hope this is the correct link...I copied it from a previous message. If
it isn't then I'm sure someone else will reply with the right one.
Alan
>From DocKimbel
Hi all,
New flat, new car, new job, new PC, and finally....new mySQL driver
release! :)
With so much new things at the same time, it wasn't easy to find some free
time
to release this update! You can download it, as usually, on my reb-site at
:
http://rebol.dhs.org/index.r (requires Rebol/View)
Direct archive download at :
http://rebol.dhs.org/mysql-085.rip
"Aviles,
Javier" To: "['rebol-list--rebol--com']"
<javier.avile <[rebol-list--rebol--com]>
[s--eds--com]> cc:
Sent by: Subject: [REBOL] Re: [ANN] mySQL driver for
rebol-bounce@ /Core
rebol.com
04/10/2001
08:17 AM
Please
respond to
rebol-list
Hi Rebol Gurus,
How can I download the mySQL driver developed by Dockimbel....
Thanks
Javier H. Avilés Avila.
> EDS NMxSC
* [javier--aviles--eds--com]
TEL. 29-09-42 Ext. 56361
[21/21] from: kracik:mbox:dkm:cz at: 10-Apr-2001 17:42
Hi,
use this sequence, otherwise the rip file can be downloaded as text
and not binary.
>> write/binary %mysql-085.rip read/binary http://rebol.dhs.org/mysql-085.rip
>> do %mysql-085.rip
--
Michal Kracik
Aviles, Javier
wrote:
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted