AltME groups: search

I will provide the basic ones for Red: TCP, UDP, DNS, HTTP(S), SSL, 
SSH/SFTP, SMTP. Also, I would like to have a few more for remote 
or local storage builtin: Dropbox, MySQL, Postgresql. 


You are welcome to contribute other ones to that list (IMAP, SMTP, 
MongoDB, CouchDB would be nice additions).

there is no other option to SQLite, other embedded databases are 
either not free, or don't use SQL syntax (e.g. mySQL)

MySQL doesn't use SQL syntax?

Kaj - last I checked it was long time ago. It did not use SQL syntax, 
and was not even free IIRC. But I don't follow mySQL for many years 
now ...

Curious too about time frames for file access, network protocols, 
2D drawing API, sound, etc.  Are those things on the horizon yet? 
 Looking forward to when you can port higher level things like mysql 
dialect, games demos, etc.

:-)


File and network I/O: should be done for Christmas (maybe alpha state 
for networking). I will provide then HTTP client/server support shortly 
after. Expect more network protocols to come in Q1/Q2 2013. 2D/sound 
will be part of the work on GUI, so will happen later in 2013. Mysql 
support through networking: I will very much like to have that, as 
Postgresql support too. Expect them before summer 2013 (or maybe 
before for MySQL, if I need it for a killer Red demo). ;-)

What I see as a first possible step is have a kind of Red website 
hosting where websites can be hosted using Red (cheyenne server) 
and a database behind it (MySQL or SQLite) and a possibility for 
digital payments (such a module could be additionally payed and kept 
'closed' source). This could obviously generate a modest cashflow.
There would be needed books etc.

BrianH:I don't believe a single second for R3 becoming even beta. 
Three or so years ago I wrote, what makes a good beta for me. So 
here it comes - give me a console, not a crap. Give me smtp, ftp 
etc schemes, without an excuse. Give us odbc, mysql, postgress, give 
us CALL. So - no matter how much advanced R3 is to R2, in a sence 
of a complete package, it is still pre-alpha ...

There is as I read this a different issue. Dock want Red to be as 
complete as posible, Kaj wants it to officially useable. Kaj really 
needs UTF-8 (and or Latin-1) character support, for getting this, 
I guess this has to do with the Syllable operating system amongst 
others.

I would like Red to support time and random functions as natives 
and (Gregg is one of your mezz funcs REJOIN ? I want that too) be 
able to connect to a MySQL database so I can dump PHP for some webdevelopment.

Besdies that we all love to see a VID (like) solution for display 
and creating apps. 

We have to be patient agreed 100% amongst everybody? Where the roadmap 
mentions all things to progress Red, above things are not on that 
list. I want Red to have enough to make it useable in production 
and after that expand, imho that is the way to really attrackt more 
funding/enthousiast programmers and make sure current support does 
not fade/ loose interest.

Very much so and connecting it to my MySQL database as well! But 
that is not yet possible at this time. I do not see a use for a form 
if I cannot save information from it.

R2 has all these possibilities, on rebol.org are various examples 
of scripts. For Red we might train our patience muscle of finance 
Nenad in the 'right' direction.

Hi, I have added two scripts today on rebol.org. one is how I plan 
using the mysql driver from Nenad, the other one is reproducing the 
php script on http://www.alistapart.com/articles/succeed/to get 
well formed URL/URI 's and get rid of the ?id=99&stuff='idea' kind 
of links. 

It is not yet really finished for I haven't tested/thought about 
how this works with requesting the indexfile in subdirectories. Also 
if there are ideas how to store and reproduce articles from a database 
using one two or more keywords feel free to put them up.

What was the dual mysql license?

GPL 2 with copyright assignment, vs commercial. Even their client 
library was GPL, so applications that used MySQL had to be GPL'd 
too, or pay the price. Or they could use a third-party client lib 
like Doc's.

Nick: in your business_programming.html page, I think your missing 
a % character in following code line:

    do mysql-107.rip

Graham: Thanks. That makes sense out of something someone else told 
me. I thought the information was contradicting what you guys said 
earlier, it just means I misunderstood the order of things. The modiffer 
after the slash is closer to making a new command than it is an agrument 
than I had envisioned. The fact that random is part of both made 
me think they could be done together. Thank you for catching that 
I did not know that detail.


 Next part of myscrip enters something into a database. The server 
 will have an mySQL database installed. It is possible that alternative 
 could be used, but knowing for sure I have at no extra charge this 
 options means I am starting with this option.


 So I found a MySQL Driver for REBOL from here: http://softinnov.org/rebol/mysql.shtml


 I am following the instructions that came with the download. Is there 
 anything I should know. Maybe it is not the driver people use because 
 there are better ones. Maybe the author kills kittens on the weekend 
 and it is consider bad form to use it. Maybe it is harder than it 
 looks. Basically, please just tell me if there is general info about 
 it I should know that is not obvious. Thanks.


Hey, someone else is asking questions? i thought this was all about 
me! :-) :-)

It's pretty much the only driver used for mysql

And now for something completely different. I have a php based form 
I want to make into a REBOL cgi program. It is to upload some fields 
into an article-base in my mysql database. Where action is article.php 
in the php version I changed this to article.r for the REBOL version. 
I have now the article form shown and when I fill in some fields 
(but not all) and send the form I get the cgi object ( I use safe-cgi-data-read) 
but the contents of the formfields is now empty? Any clues what may 
be the case please?

Thanks for the welcome back message.
 

 I left off asking about the mySQL driver. So I want to insert into 
 a database a random number the code already generated and associate 
 it with an email address that was provided by a CGI form. Have yet 
 to create this in the real world but for now let us assume I will 
 call the database "customers". The people who process the credit 
 card and collect the email address advised me that the address will 
 be labelled "trnEmailAddress".


 After finding the mySQL driver Here is what I figured out using placeholders 
 for things like password, etc. Would appreicate knowing if this is 
 correct.

; Loads MySQL driver
do %mysql-driver/mysql-protocol.r
; Opens connection to MySQL server
db: open mysql://[[user][:pass]@]host[:port]/database


; Send query to database server. Enters random number from above. 
customers is probably the name of the database I will create

insert db ["INSERT INTO customers VALUES (?,?)" "trnEmailAddress" 
"token"]



 Next I need to insert an existing PDF file (an e-book) into a directory 
 created by the script. The directory will be named after a random 
 number that was earlier generated by the script. I am astounded that 
 I can not find the command to copy a file. So the variable assigned 
 to this random number is called "token".

 So I have the following.

make-dir %token/


 How do I copy a file into this new directory? Also, is that the corecct 
 way to make a directory?

guys ,i explained my mini project in database and game room ...they 
suggest me this room ! plz help me . my project is about one crossword 
which should show on web page !  i created html form and cgi file 
... when user enter value and press submitt it should save in database 
! my problem is i can not save value from form into database(MYSQL)... 
i am using mysql driver...i can make connectivity and retrieve data 
but i ca not save values ! plz guide me ,i do not have experience 
in REBOL... :(

Yes, it's in Qtask source. I used a script to translate the TZ database 
to REBOL, then made a REBOL function to convert between timezones.


Note, if you are using MySQL, you can have it handle timezone conversions 
too.

Thanks Gabriele, I found by googling that mysql can have timezone 
database installed and has the functions to handle it then. http://stackoverflow.com/questions/805538/in-mysql-caculating-offset-for-a-time-zone
(the second answer, with a link of how to install if anyone else 
will be looking)

so they think its better to keep it. 

so if you use MSSQL use sp_databases, or sp_tables; for mysql use 
SHOW TABLES etc..

or select * from INFORMATION_SCHEMA.tables for many of them (works 
on MSSQL 2005+, mysql, postgre, not sure about sqlite)

I want to change some data in a mysql database from a REBOL (2) program 
using DocKimbel's mysql-portocol.r When I use a .r script from my 
website I can connect to the database. I figured that when I ran 
a script from a console I would be able to quickly test my script 
but somehow I am stopped because the script cannot connect. This 
is the error:
** Access Error: Cannot connect to mysql-01.yourname.nl
** Where: open-proto
** Near:
Any ideas?

Arnold, make sure you GRANT privileges to the mysql user before I 
could see it remotely. Make sure you use the '%' parameter or you 
won't see past the localhost. See mysql reference manual for help. 
Also make sure you open the port (3306)

You mysql server maybe configured to accept connections only from 
127.0.0.1?

and, try to connect from a remote PC using mysql command-line tool.

I have the database on my host/provider's site, maybe that is only 
accepting requests by scripts on it's own local address. Could be.

The % parameter? I have http://softinnov.org/rebol/mysql-usage.html#sect12.
for my documentation.

% means "accept connection from any IP". It is not related to softinnov's 
mysql driver. If you use phpmyadmin or similar tool to configure 
your mysql, you should see it on GRANT options. You can find more 
info on Mysql Administration documents.

Where does open-proto come from in the mysql-protocol.r in the mysql 
driver from softinnov? Word has no value in the version I am using. 
Strange. No complaints when using the script from a location on my 
webspace, trouble when used to connect from my local machine to the 
web MySQL.

I still think that it is because your mysql server does not accept 
connections except localhost.

Did you try to connect your database using mysql command-line tools? 
or MySQL Workbench from a remote PC?

What version of mySQL are you using?

MySQL 5.0.45, Protocol version 10.

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.

I just upgraded local ubutu and I made the rebol work with ia32-libs 
again, now rebol mysql client is givin me auth error

Gregg: what did you say you did to make it work? what did you move 
to 4.1 the mysql server or something else?

Janko: if you're using a newer MySQL version, you need my 4.1 driver.

I am looking at this page http://softinnov.org/rebol/mysql.shtml
(google doesn't find me any ohter, I think)

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.htmlis this the 
latest version you have?

http://softinnov.org/tmp/mysql-protocol-41.r

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...

do http://reb4.me/r/schema
do http://reb4.me/r/mysql-schema
print schema-create load-schema http://reb4.me/r/schema-sample

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...

guys , i have one project (crossword )which uses mysql database! 
i want use mysql driver ,i know how  we can create table and make 
connectivity with database !  crossword should show on web page ,and 
when user put characters in each field ,then press button ,it will 
chek with database and if it is correct ,user can continue otherwise 
shows error message ....i created crossword table with cgi and is 
working on web ,i have created database as well,now my problem is 
i do not know how can i fetch data and comparing with database? is 
there anybody for helping my mini project????

REBOL []
do %mysql-protocol.r 
db: open mysql://[root-:-localhost]/test
insert db {create table data (
    name            varchar(100),
    address         text
  )} 
insert db {INSERT into data VALUES 
    ('raj', 'pune'),
    ('ekta', 'delhi'),
    ('ankur', 'mumbai')
    
}
insert db "SELECT * from data"
results: copy db
probe results
close db

do %data.r
Script: "Untitled" (none)
Script: "MySQL Protocol" (12-Jul-2008)
MySQL protocol loaded
connecting to: localhost
[
    ["raj" "pune"]
    ["ekta" "delhi"]
    ["ankur" "mumbai"]
]

you have to mix them something like  

#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe" 
-cs
REBOL [Title: "Table"]
do %mysql-protocol.r 
db: open mysql://[root-:-localhost]/test
insert db {create table data (
    name            varchar(100),
    address         text
  )} 
insert db {INSERT into data VALUES 
    ('raj', 'pune'),
    ('ekta', 'delhi'),
    ('ankur', 'mumbai')
    
}
insert db "SELECT * from data"
results: copy db
print "content-type: text/html^/"
print [<HTML><BODY><TABLE  bgcolor="black" border="1">
{
<tr bgcolor="white">

<td style="width:30px; height:30px;"><input name="one-one" type="text" 
size="1">} 
print results/name 
print {</td>}


etc

command for comparing values in mysql database ????

select * from table where answer = useranswer
select * form table1, table2 where table1.field = table2.field

Do you have google? Any MySQL tutorial out there holds the answer 
to your question.

Or want to compare from wihin your REBOL script? It is either [ left 
= right][do-something][do-else-thing].

i exactly meant that how we can use Mysql queries(checking two values 
in two different table) in Rebol script !!!!!

so you have put the users answer also in a mySQL table?

read both tablerows from the tables into different variables and 
compare the subfields of the returned rows result1/fielda result2/fielda

#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe" 
-cs
REBOL [Title: "Table"]
do %mysql-protocol.r 
db: open mysql://[root-:-localhost]/test
insert db { DROP TABLE IF EXISTS data1;
create table data1 (
    oneone        varchar(1),
    onetwo        varchar(1),  
    onethree      varchar(1),       
    twoone        varchar(1),
    twothree      varchar(1),
    threeone      varchar(1),
    threetwo      varchar(1),
    threethree    varchar(1)
  )} 

print "content-type: text/html^/"
print [<HTML><BODY>]
print [<form><input type="submit" value=" submit !" />]
print [<TABLE  bgcolor="black" border="1">]
print {<tr bgcolor="white">

<td style="width:30px; height:30px;"><input name="oneone" type="text" 
size="1">}
insert db ["insert into data1 (oneone) values (?)" ]
results: copy db
print {</td>}

>> do %compare.cgi
Script: "Untitled" (none)
Script: "MySQL Protocol" (12-Jul-2008)
MySQL protocol loaded
connecting to: localhost
** Script Error: Invalid path value: oneone
** Where: map-rebol-values
** Near: result/oneone
>>

You first check that the value is acceptable for what can be expected. 
This is to prevent SQL injections and other malicious input from 
hackers/innocent users and monkeys using your application. Than you 
insert a SQL command to insert or update  the mysql database just 
like you did when you did with your select statement before.

 mijnquery: "INSERT INTO cms_artikel (titel, tagregel, sectie, toegevoegd, 
 artikel_tekst) VALUES ('"

 mijnquery: append mijnquery rejoin [titel "', '" tagregel "', '" 
 desectie "', '" toegevoegd "', '" artikel-tekst "')"]
 insert db mijnquery

 The names after INTO are the fieldnames of the table cms_artikel 
 the ones after VALUES are the REBOL variables that get replaced by 
 their values

if so, you have to add your mysql connection parameters to your script., 
open a mysql port and do an sql insert to your table.

a quick update on elasticsearch.

Currently I have reached 2TB datasize (~85M documents) on a single 
node.

Queries now starting to slow down but the system is very stable even 
under

heavy load. While queries in average took between 50-250ms against 
a 

dataset around 1TB the same queries are now in a range between 900-1500 
ms.

The average allocated java heap is around 9GB which is nearly 100% 
of the
max heap size by a 15 shards and 0 replicas setting.

elasticsearch looks like a very good candidate for handling big data 
with 

a need for 'near realtime' analysis. Classical RDBMS like mysql and 
postgresql

where grilled at around 150-500GB. Another tested candidate was MongoDB

which was great too but since it stores all metadata and fields uncompressed

the waste of diskspace was ridiculous high. Furthermore query execution 
times 
differs unexpectable without any known reason by factor 3.

Tokyo Cabinet started fine but around 1TB I have noticed file integrity 
problems

which leads into endless restoring/repairing procedures. Adding sharding 
logic

by coding an additional layer wasn't very motivating but could solve 
this issue.

Within the next six months the datasize should reached the 100TB 
mark. 

Would be interesting to see how elasticsearch will scale and how 
many
nodes are nessesary to handle this efficiently.

Was there ever a mysql driver for R3? I saw some examples in the 
"import" docs but the link is not working.

According to the mysql ref, yes. Thanks for the tip.

Pekr: "BrianH:I don't believe a single second for R3 becoming even 
beta. Three or so years ago I wrote, what makes a good beta for me. 
So here it comes - give me a console, not a crap. Give me smtp, ftp 
etc schemes, without an excuse. Give us odbc, mysql, postgress, give 
us CALL. So - no matter how much advanced R3 is to R2, in a sence 
of a complete package, it is still pre-alpha ..."

Hi, i'm at the beginning of a project in which i need access to a 
remote MySQL db. 

I tried Softinnov's MySQL driver, but that seems to be outdated (MySQL 
complains about client protocol).
Does anyone know an up-to-date MySQL driver for Rebol (2 or 3)?

@arie, what version of the MySQL driver are you using?

Arie, try with http://softinnov.org/tmp/mysql-protocol-41.r

I'm definitely using v5.5.31 on windows with R2 v2.7.8.  (just checked).


 pretty sure Quarter Master uses Doc's drivers (which is what is setup 
 for mysql right now), though I may be wrong.

unless it also has the letters mysql  ;-)

basically the scripts interface to the mysql db via custom rebol 
values

I made a function for this to interface MySQL:

keyed: func [keys [block!] values [block!] /local out] [
  out: copy []
  if not any [empty? keys empty? values] [
    repeat i length? keys [
      insert tail out reduce [

        keys/:i either block? first values [values/1/:i][values/:i]
      ]
    ]
  ]
  out
]

Yes, we were caught by SourceForge's move from MySQL 3 to MySQL 4. 
After a month they just cut off the old functionality, so now we're 
forced to migrate in a hurry

However, the parts of the site that are not in MySQL are still functional

I need to prepare some installation instructions for our polish partner. 
I will do some scripts to access mySQL on their server, using rebol, 
but I will not have access to the site. So I want to be well prepared, 
so they don't get annoyed after writing them tens of times "try that, 
try this" etc. :-)

They use Debian. I have Fedora at home. What would I like to ask 
is - where to put rebol interpreter on Debian? Where to put things 
like user.r or mysql-protocol.r or whatever other script I produce 
to them? The path is almost always trouble for me. I e.g. start console 
and I have to define set-net once again, as it does not use my user.r 
settings etc. Any insights?

has latest beta core available shell access? I will not probably 
able to solve mySQL 4.0.1 charset conversions using mySQL commands, 
so I will use 'iconv utility .... need to convert by using externall 
tool, so I need shell access for that ...

Sunanda, thanks. I have in fact done that before. I think what was 
really happening was that the files were not chmoded correctly. All 
is well now including mysql through Rebol (which I thought was going 
be very difficult to fix). Again thanks.

What I have found to be a problem is accessing MySQL accounts from 
client based rebol scripts. They seem to only allow server based 
access.

mysql: some hosts only allow socket access and not tcp access to 
mysql (because that's the default config for some distros.) but, 
that's something that they can enable without problems.

I have a rebol view app that I use to acces a MySQL database. I had 
it working  and then ,y ISP decided to add security and no longer 
allow MySQL access unless its a script on the server. Ofcourse they 
did not inform me and it took some time to track down the problem..

But  yes: load-balancer -> webserver(*) -> FastCGI(*) -> MySQL

I don't understand it a bit. I can understand webserver, fastcgi, 
mysql part, but what is that load-balancer part? Client side?

I want to access a mysql db via a cgi interface directly with a rebol 
client.


I have a cgi script  that accesses the db and prints the results 
which I can read with the client but is this the best method? Is 
there a way to send the data directly to the client as rebol blocks 
or do I need to essestialy parse a cgi built web page as I am doing?

I know I can use mysql-protocol to access mysql directly but that 
is not hat I mean as sometimes that is not possible/allowed by some 
isp's.

The ISP owns the mysql db .. and opens up some tables for you to 
use.  So, no, it's not possible unless you run your own Vm like as 
on Amazon or linode or slicehost or whatever.

The advantage over Vanilla is that changes can be rolled back using 
the mysql database ...

is there anything close to ruby rails wrt automatically defing MySQL 
CRUD operations ? I find rails really cool, something Rebol could 
easily do !!

in MySQL I for example use: "SET character_set_client = cp1250"

What's the current status of the postgresql driver   ?   Should one 
use mysql instead?

As for PostGress, IIRC the driver was in better state than the one 
of mySQL? It even used continual parsing. Doc said later on even 
mySQL driver will be rewritten that way, and maybe it already is, 
dunno.

Graham, Dock's Mysql driver run on eavy tasks without a hitch 8)

I'm just not sure that Mysql's license will eventually catch doc's 
work as well.

Doc,   PgSQL does not have same 'send-sql' and /flat options.   Is 
there a reason they can not parallel the mySQL use?

No particular reason, this driver wasn't much used by me or others, 
so I haven't work on it  as much as on the MySQL one. For SEND-SQL 
support with options, it should be quite easy to add IIRC (just a 
matter of copy/pasting some code from MySQL driver).

I am trying some of the code from mySQL and get a PgSQL error "** 
Script Error: Invalid argument: TABLE
** Where: forever
** Near: to integer! trim pos"

Thanks Doc.  I can work around that TABLE message using the pgAdmin. 
 The Send-SQL and /FLAT protocol updates work exactly the same as 
on MySQL for me.

not only that - it could be properly supported by sort/collation 
kind of functionality, as other environments do (mySQL). Rebol even 
does not use its system/locale in its own calendar ;-)

Jaime - e.g. what I need is quite simple - having app on Windows, 
I need to submit my data to mySQL data in Poland, so it needs to 
be translated to another charset .... (but IIRC it can be done on 
server, so I will hopefully manage it without rebol supporting unicode 
for now )

hmm, just looking at sources of mySQL and I can find pthreads are 
there, so they might use photothreads? Carl once wanted me to remind 
him of that. So Jaime, if you know libevent is considered for even 
loop, you might once again point Carl to http://www.sics.se/~adam/pt/
, but maybe he has already decided how to do such things properly 
for REBOL 3.0 :-)

OSX is not good for high performance serving, such as running MySQL. 
It's notoriously slow at creating threads. This doesn't affect desktop 
performance however.

After buying Sleepycat, Oracle tried to buy mySQL - it starts to 
be worryig :-)

http://news.com.com/Oracle+tried+to+buy+open-source+MySQL/2100-7344_3-6040197.html?tag=nefd.lede

mySQL AB buys company of one of Firebird authors - Jim Starkey .... 
Netfrastructure ... never heard about their "revolutionary" products 
... sounds like collaborative environment?


http://netfrastructure.com/main.nfs?a=netfraweb&l=;PAPERS;PAPER_NO='7'&t=drlWhitePapers


Jim was author of nextgen Firebird generation - called Vulcano or 
so ...

Hope it gets faster to 1.0.x then the mysql driver ;-)

Marteen: I'll add a small Database abstraction layer for RSP: so 
I'll include both mysql and pgsql drivers once this feature added.

Doc: I know, but I also read the RubyOnRails book where they measured 
all this. A database scales better, and for low usage the performance 
hit you tahe is little. Files/memory is faster but collapses pretty 
soon, MySQL runs with constant overhead (and little enough, I might 
add). It is more a question of balancing performance with different 
load scenarios.