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

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