r3wp [groups: 83 posts: 189283]
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r3wp

[MySQL]

Dockimbel
11-Jun-2006
[741x4]
Doing the following test works for me (v5 server) :
1) Load the REBOL mysql console : do %mysql.r
2) Connect to the server
3) Command: show tables
4) result ok
5) Stop/Start the server
6) Command: show tables
7) result ok (the driver has reconnected transparently)
Erratum: replace the step : do %mysql.r by :
do %mysql-protocol.r
do %mysql-client.r
mysql
JaimeVargas
12-Jun-2006
[745]
Doc, any news on when will you go v1.0 with the postgress driver?
Ingo
12-Jun-2006
[746]
Great Doc!
I didn't believe you'd ever call a version worthy of 1.0 ;-)
Dockimbel
12-Jun-2006
[747]
It takes, at least, 4 for years of beta-testing to become 1.0 ;-))
Henrik
12-Jun-2006
[748]
and intense bugfixing sessions 4 days before releasing 1.0 :-)
Dockimbel
12-Jun-2006
[749]
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...?
Graham
12-Jun-2006
[750]
was it oldes who made some fixes for the postgres driver?
Dockimbel
12-Jun-2006
[751]
If anyone got useful patches to postgres driver, please publish them 
here.
Graham
13-Jun-2006
[752x2]
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:(
Oldes
13-Jun-2006
[754x2]
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
Pekr
13-Jun-2006
[756]
why do you presume R3 will contain async networking?
Oldes
13-Jun-2006
[757]
or multitasking (I hope)
Henrik
13-Jun-2006
[758]
what would be the point of R3 if it didn't contain threading?
Rebolek
13-Jun-2006
[759]
to entertain community somehow so we do not complain to much? ;o)
Dockimbel
24-Jun-2006
[760x2]
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.
Henrik
24-Jun-2006
[762]
docKimble, I just thought of something: what if, for MySQL, a time 
out is not the same as reconnecting to a restarted server?
Dockimbel
24-Jun-2006
[763]
I don't understand your question. Could you explain a little more 
?
Henrik
24-Jun-2006
[764x3]
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.
Dockimbel
24-Jun-2006
[767]
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.
Henrik
24-Jun-2006
[768]
ah :-)
Dockimbel
24-Jun-2006
[769x2]
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.
Henrik
24-Jun-2006
[771]
ok
Dockimbel
24-Jun-2006
[772x2]
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.
Henrik
24-Jun-2006
[774]
maybe I'll do some tests when I get time :-)
Dockimbel
24-Jun-2006
[775]
Thanks, that would help me know if this feature works as expected.
Joe
22-Aug-2006
[776x2]
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
Gabriele
22-Aug-2006
[778x2]
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... :(
Joe
22-Aug-2006
[780]
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
Gabriele
22-Aug-2006
[781]
it's not very readable indeed. but i was going for speed ;)
Will
31-Aug-2006
[782]
Mysql Performance Tuning Best Practices:

http://video.google.com/videoplay?docid=2524524540025172110&q=google+engedu
Joe
12-Sep-2006
[783x3]
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;
Gabriele
12-Sep-2006
[786x2]
you need multiple inserts, one for each query.
the mysql program does this automatically when you give it a file 
(using ; as separator)
Dockimbel
12-Sep-2006
[788]
You can do script it easily: foreach line parse file ";" [insert 
db line]
Gabriele
12-Sep-2006
[789]
he has to adjust for the variables he's using though.
Joe
12-Sep-2006
[790]
yes, this works :  i change first ? for "?1" and second for "?2" 
and have some replace before the insert