World: r3wp

do you "mold" it? what kind of field do you try to store it in?

maybe sqlite molds it automagically ?

I've tried text and varchar

text has no issues in sqlite

SQL command is a string so IMHO you have to mold it and enquote it 
as normal text and then there should be no problems .. what kind 
of errors does it throw?

I molded it and it inserted into mysql but now I need to see if after 
selecting it that it behaves properly in my app....
thanks for the help

yeah, my app crashes I need to convert back to block...

yes you need to deserialize it after retrieval.

I'm using 'mold/only' saving to mysql and
'to-block'  to re-block it...
is there a cleaner way like an 'unmold'?

Also, i have some datestamp issues.
rebol attaches the zone code to now when getting the date/time

but when using mysql timestamp I do not get a time zone attached 
and its screwing me up.
Is there a way to add time zone to datestamp in mysql?

hm.. I think you use load to get rebol data back from string

load "[... ]"

right...duh!

From what I have been able to read about timestamps and mysql I might 
as well insert the client's time...
But then I would need to issure clietn's clocks are correct....
What is SOP for this situation?

insure

Quick question about computer time,,,
Eastern Time is GMT-5 which my computer clock is set to...
why does rebol give me time with -4:00?
7-Jun-2009/20:24:01-4:00

daylight saving?

ok, but what is rebol reading to get the time?

I just did an update to my server time and my other computer..

I used time.nist.gove for the server and time.windows.com for the 
other computer and they were two minutes apart

I tried again and they are now synced...atleast to the minute...

Rebol must get the zone from the computer but why is it different?

I know..a little off topic..moving to core

Any reason why my data in a 'text' column is getting truncated at 
9999 characters? I tried 'longtext' but there was no change..

I thought 'text' holds up to 4 gigs from what I read...


I saw something about longtext being limited by the way a client 
handles packets..could this be a problem with MySQL protocol?

I tried to insert a longer string using phpMyAdmin and it inserted 
fine...no truncation.
I guess its mysqlprotocol.r problem.

Anyone else encounter this? Any work arounds?

can you use any other formats?  Does mysql have text blobs ?

try wireshark to do a tcp trace to make sure all the packets are 
getting thru

I have no problem inserting much bigger data to text fields using 
Dock's driver, thought I can't suggest anything else then wiresharking 
for debugging

Maarten: is there any news about your Sphinx stuff? Reichart "promised" 
to release it soon, that was some time ago 8)

Will did you not try the mysql driver for sphinx??

Amacleod: There's no internal limit at 10000 bytes in mysql driver 
(single packet default limit is 1MB). Are you using prepared statements? 
If not, are you sure that your data is correctly encoded? Anyway, 
try using TRACE mode : trace/net on. Look at the sent packets size 
to see if there's a truncation in the mysql driver.

I check it out thanks, Doc.

I'm sending much larger blobs (image files) and it works just text 
is giving the problem but I'll need to look further. Thanks all.

are you using latest 1.3beta versionof the driver? previus version 
may have a problem and truncate..

Graham: no, do you? how is your experience with it?

IIRC previous version had a problem with escaping correctly {'} in 
some circumstances, that may be a cause of truncation.

here is the latest http://softinnov.org/tmp/mysql-protocol-41.rgive 
it a try

from the changelog, " Fixed parsing bug with \\. Now expression like 
"'\\', 'wo;rd'" will be parsed correctly."

I don't use mysql .. but Firebird.  And I'm waiting for the sphinx 
integration into firebird before I try doc's mysql driver.

to communicate with sphinx.

As for waiting for Qtask to decide on their licensing ... well, enuff 
said.

Understanding and control of MySQL query optimizer http://assets.en.oreilly.com/1/event/21/Understandingand Control of MySQL Query Optimizer_ Traditional and Novel Tools and Techniques Presentation.pdf

Has anyone tried to get Doc's mysql stuff to run with R3 yet?


@Doc: Do you think it can be ported/adapted to work with R3 without 
to much effort?

At least, the whole networking support needs probably to be fully 
rewritten for R3. Beyond that I'm not sure what you work or not out 
of the box with R3. String encoding and Unicode might require some 
additional code. MD5 support is also required btw, if you want to 
use passwords with 4.1+ MySQL servers (for 3.x support, you would 
need to rewrite the whole current driver encryption code).

what you work => what would work

I signed up with a web provider but they do not seem to allow remote 
direct access to the mysql db unless you specify the ip that first...which 
is no good if you have an app used by many people in any number of 
locations....


Is this standard procedure? I had the same problem with another provider.

What is the way around this? CGI?

Eh??

A web provider only provides access to mysql from a script ... and 
you will have a static ip for your web host.

amacleod, CGI, yes or use rebservice if you allowed to start a port 
and forward the sql request to doc's mysql sheme as localhost 

or switch to a virtual server with linode or slicehost for full control.

amacleod, CGI, yes or use rebservice if you allowed to start a port 
and forward the sql request to doc's mysql sheme as localhost 

or switch to a virtual server with linode or slicehost for full control.

I'm serving the db from my own p for this host as there is server 
for now as bandwidth is not an issue yet. I signed unlimited bandwidth, 
storage, email accounts, mysql db's etc. for a few bucks a month. 

I was just testing mysql for possible use down the road.


When the time comes i will probably go the "linode" route as iwould 
want to use Cheyenne too and no provider is going to let you run 
that.