AltME: Databases

Messages

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...
Definitely a work in progress, but has saved me some time.
Kaj
Did you port WITH from Red/System? ;-)
Chris
No, just an old QM function : )
Kaj
Ah, I remember now
Chris
Erk, fixed a couple other dependencies, d'oh!

Endo
Very nice work Chris.  It would be nice to have that for MS-SQL too.
Chris
By the looks of it (I've not used MS SQL) it wouldn't be too different. Same for Sqlite. Just a matter of hacking http://reb4.me/r/mysql-schema to include the most appropriate datatypes.
Of course, that's only for the 'create statement. I imagine detecting differences in schemas between SQL dialects might be more nuanced. But then I haven't got that far with any dialect of SQL, so...

Last message posted 348 weeks ago.