AltME: Databases

Messages

GrahamC
dll compiled means use from R2?
Kaj
It's an R3 extension. You could load it in R2, but you'd have to program the interface to the extension yourself

Gregg
Is anyone using Doc's MySql protocol (v4.1 1.3.0) with MySql 5.5.24-cll, protocol v10?
I have a client migrating to a new host. We've been using 1.2.1 against mysql 5.0.95, but 5.5 triggers the client auth error. Moving to Doc's 4.1 version solved that, but a simple test query returns an empty block.
Can't rule out a data migration error yet, as things just moved and getting connected was the frist step. Just curious if someone is known to have this combo working.
Nevermind. I was able to test another query which works, so all is well there. Thanks Doc, once again!
The failing query was a data migration issue, just FYI.
Janko
I just upgraded local ubutu and I made the rebol work with ia32-libs again, now rebol mysql client is givin me auth error
Janko
Gregg: what did you say you did to make it work? what did you move to 4.1 the mysql server or something else?
DocKimbel
Janko: if you're using a newer MySQL version, you need my 4.1 driver.
Janko
aha, I hoped he meant that :) , but I only found 1.2.1 on your website
I am looking at this page http://softinnov.org/rebol/mysql.shtml (google doesn't find me any ohter, I think)
DocKimbel
It's not an official release yet...I wish I had time to finish it...:-/
IIRC, it was missing some minor feature support from the protocol and good new test cases...
Janko
well if it works for what I need it it's ok with me (I just use mysql for user db so it's rather simple). I found mention of it here now http://rebolweek.blogspot.com/2008_12_01_archive.html is this the latest version you have?
DocKimbel
Yes, the link from the blog entry is the right one too.
Janko
thanks! I will try it ... otherwise I will reinstall mysq 5.1
DocKimbel
Ah right (reading the blog article reminded me a few things), the multiple results reading + stored proc needed more tests.
james_nak
I've been relying on 4.1 for a long time now. No problems so far. Thanks Doc.
DocKimbel
You're welcome.

Gabriele
I've also been using it for a very long time. Sadly, not a lot testing with multiple result sets as we don't use this on production, so i can't use multiple result sets. :( it did work correctly with simple tests.

Chris
Thought I'd share this in case anyone found it useful (or had any suggestions/criticisms).  First part is a description in REBOL of a database schema (sample here: http://reb4.me/r/schema-sample ), second part is a function that generates the MySQL code to create the database/tables. I'd like to add functions to analyse database schemas against my REBOL schema and create 'ALTER' statements as necessary.  All in good time...

Last message posted 118 weeks ago.