World: r3wp

Erratum: replace the step : do %mysql.r by :

do %mysql-protocol.r
do %mysql-client.r
mysql

Doc, any news on when will you go v1.0 with the postgress driver?

Great Doc!
I didn't believe you'd ever call a version worthy of 1.0 ;-)

It takes, at least, 4 for years of beta-testing to become 1.0 ;-))

and intense bugfixing sessions 4 days before releasing 1.0 :-)

Postgresql: Don't know, I may work on it this summer for a customer, 
so I may release new versions. I didn't had much feedback on this 
product, maybe too few users in the REBOL community...?

was it oldes who made some fixes for the postgres driver?

If anyone got useful patches to postgres driver, please publish them 
here.

posted by oldes 24 November

I like async internally, and anyway I remember I had problems with 
the non-asyns async - I think sometimes it was not able detect if 
the client closed connection or something like that, and i have my 
async version of postgres I'm using. I want new build of Core with 
async and rebocodes so much:(

we will have to wait for A3:( but I still use the old alfa version 
of Rebol/Core with this script: http://oldes.multimedia.cz/rss/projects/a-pgsql/latest/a-pgsql.r

A3 = R3

why do you presume R3 will contain async networking?

or multitasking (I hope)

what would be the point of R3 if it didn't contain threading?

to entertain community somehow so we do not complain to much? ;o)

If some of you still have troubles connecting to a v4+ MySQL server 
with the last driver v1.0.6, please give a try to a new beta version 
(1.0.7) found here : http://softinnov.org/tmp/mysql-protocol.r

If you've set up your MySQL server using a PHP tool like phpMyAdmin, 
your users are probably created with the OLD_PASSWORD mode, even 
if you're using v5+ servers (it's a PHP issue). My driver v1.0.7 
should allow you to connect flawlessly to such configured server. 
Please try it and give me some feedback.

docKimble, I just thought of something: what if, for MySQL, a time 
out is not the same as reconnecting to a restarted server?

I don't understand your question. Could you explain a little more 
?

if you restart mysql, there are no prior connections to handle for 
mysql. if your connection times out, I wonder if mysql then does 
something different to create the connection again.

that wasn't clear enough...

If you restart mysql, there are no prior connections to handle for 
mysql, thus the test above works every time. If your connection times 
out, I wonder if mysql then does something different to create the 
connection again and then sometimes fails.

I would be easier to understand if you replace the word "mysql", 
by either "client" or "server". ;-) But, anyway, I think I got the 
picture.

ah :-)

If your server goes down, your remaining client connections will 
timeout and generate an error value.

When a new request is sent through a timeout-ed connection, my driver 
will close the port and try to reconnect to the server. It tries 
3 time and if it fails, generates an error.

ok

If the server is up again at the time of the reconnection, it should 
be ok.

I never tested such case deeply, so they might be some bugs/issue 
that I didn't saw.

maybe I'll do some tests when I get time :-)

Thanks, that would help me know if this feature works as expected.

I am using mysql-wrapper.r . In function db-last-insert-id there 
should be one less "first" command to get the result. I think this 
is a bug, pls confirm

does anybody have an example using db-cached-query ? thanks

if the behavior of the mysql-protocol has changed lately, then yes. 
when i wrote that, it needed that "first". (i used that function 
a lot so I know it worked)

i used db-cached-query for vid LISTs, gives a huge speedup without 
using too much memory. (i had a custom list style though that was 
optimized for this). i don't have a simple example at hand... :(

Yes, gabriele , it's not a bug. I got confused by the three first 
, I think a clear way to code it would be "first first copy db" to 
indicate first value of the first row

it's not very readable indeed. but i was going for speed ;)

Mysql Performance Tuning Best Practices:

http://video.google.com/videoplay?docid=2524524540025172110&q=google+engedu

I have some sql that works fine using mysql db < file but fails with 
syntax error when using insert db reduce [query var1 var2]

the query file below. Any ideas ?

LOCK TABLE category WRITE;
SELECT @myRight := rgt FROM category WHERE name =?;
UPDATE category SET rgt = rgt + 2 
WHERE rgt > @myRight;
UPDATE category SET lft = lft + 2 
WHERE lft > @myRight;
INSERT INTO category(name, lft, rgt) 
VALUES(?, @myRight + 1, @myRight + 2);
UNLOCK TABLES;

you need multiple inserts, one for each query.

the mysql program does this automatically when you give it a file 
(using ; as separator)

You can do script it easily: foreach line parse file ";" [insert 
db line]

he has to adjust for the variables he's using though.

yes, this works :  i change first ? for "?1" and second for "?2" 
and have some replace before the insert

BTW, parse has to be parse/all . Also I get some  ERROR 1065: Query 
was empty .- maybe empty line at the end

I need to work with tree, category, subcategory, etc.. does anybody 
have something ready willing to share?) thx!