| # | User | Message | Date |
| 1256 | Dockimbel | Glad to hear that my driver helped you solve your issue. :-) | 21-Oct 19:21 |
| 1255 | james_nak | Doc, what a lifesaver! I just spent the last 7 hours trying to figure out what was wrong with my remote rebol-based mysql app. It stopped working after I upgraded mysql. I spent most of my time messing around with mysql until I narrowed it down to the protocol.
sql-protocol-41.r Addresses:
User Error: ERROR 1251 : Client does not support authentication protocol requested by server; consider upgrading MySQL client (When using newer long hash passwords)
and
User Error: ERROR 1043 : Bad handshake (when using older short hash passwords) Thank you for posting this. I was getting to the point of panic. | 21-Oct 18:16 |
| 1254 | GrahamC | I think the link didn't work because I discovered it was a moderated thread. | 25-Sep 18:40 |
| 1253 | Endo | when you upgrade your mysql server from 4.x to 5.x the passwords in your "mysql" table for users stays old, which hashed a different algorithm.. so you cannot connect it using username/password anymore. | 22-Sep 22:11 |
| 1252 | Endo | The problem could be this as well: http://dev.mysql.com/doc/refman/5.5/en/old-client.html | 22-Sep 22:09 |
| 1251 | GrahamC | Ok, posted | 22-Sep 9:42 |
| 1250 | Dockimbel | It looks like the MySQL driver he's using is too old for his MySQL server. He should try with the latest version for newer servers: http://softinnov.org/tmp/mysql-protocol-41.r I haven't made it official as it does not work for older servers IIRC, and I also never found the time to fully test it with more recent ones. But it should work correctly. | 22-Sep 9:39 |
| 1249 | GrahamC | I'll ask ... | 22-Sep 9:35 |
| 1248 | Gabriele | Maybe he's using an older version of the mysql driver? | 22-Sep 9:34 |
| 1247 | GrahamC | link above works for me | 22-Sep 9:32 |
| 1246 | GrahamC | mysql problem what does this error mean? Hello, I am just looking at REBOL and trying to access mysql I got this error?? =================================== connecting to: 127.0.0.1 ** User Error: ERROR 1251 : Client does not support authentication pro tocol requested by server; consider upgrading MySQL client ** Near: db: open mysql://rootass@127.0.0.1:3306/mysql ============================================== This the code I am using from rebol document Rebol[ title: "Rebol Mini-Text Database with Visual GUI" author: "http://reboltutorial.com/blog/rebol-mini-text-database/" version: 1.0.0 ] do %mysql-protocol.r probe first system/schemes db: open mysql://rootass@127.0.0.1:3306/mysql insert db { DROP TABLE IF EXISTS products; CREATE TABLE products ( name VARCHAR(100), version DECIMAL(2, 2), released DATE ); INSERT INTO products VALUES ('cheyenne', '1.0', '2007-05-31'); INSERT INTO products VALUES ('mysql', '1.1', '2007-05-01'); } insert db read %setup.sql ;-- execute a big SQL file | 22-Sep 9:31 |
| 1245 | Dockimbel | The link is not working for me, I get a "Invalid Thread specified. If you followed a valid link, please notify the administrator". | 22-Sep 9:24 |
| 1244 | GrahamC | mysql:// question at http://synapse-ehr.com/forums/showthread.php?454-mysql-problem-what-does-this-error-mean | 22-Sep 9:08 |
| 1243 | Gregg | You should get back a top-level JSON object, but nested blocks will be arrays, not objects. e.g. >> rebol-to-json [a: 1 b: 2 c: [d: 4 e: 5] f: #[object! [g: 6 h: 7]]] == {["a", 1, "b", 2, "c", ["d", 4, "e", 5], "f", {"g": 6, "h": 7}]} | 20-Oct-10 17:43 |
| 1242 | Dockimbel | amacleod: NAME-FIELDS function might help : http://softinnov.org/rebol/mysql-usage.html#sect11. (it works on a single record only, so you'll need to loop through the recordset anyway) | 20-Oct-10 16:15 |
| 1241 | Andreas | There might well be. | 20-Oct-10 13:50 |
| 1240 | amacleod | Thanks, I thought there might be some Mysql command to insert column names with the data... THanks for your help. | 20-Oct-10 13:49 |
| 1239 | Andreas | Which should be easy, if you have the right functions available :) | 20-Oct-10 13:48 |
| 1238 | Andreas | Yes. | 20-Oct-10 13:48 |
| 1237 | amacleod | ok, so there is no easy way to do it...I justs need to loop through each rebol block and insert the field name before the data and then make objeet? | 20-Oct-10 13:47 |
| 1236 | Andreas | Precisely. | 20-Oct-10 13:46 |
| 1235 | amacleod | If a query gives me a rebol block of blocks and I send it through json.r I don't get a json object. Should I work on converting the query to a rebol object first? | 20-Oct-10 13:45 |
| 1234 | amacleod | I used json.r. New to json.... I'm going to want an json object right? | 20-Oct-10 13:44 |
| 1233 | Andreas | Also note that the above approach with CONCAT/GROUP_CONCAT does not help you with JSON-specific encoding. So changes to you'll in fact create wrong JSON are rather high. | 20-Oct-10 13:42 |
| 1232 | Andreas | Either you transfer a very large string which you build up within MySQL. Or you transfer a very large result set and build up the string in REBOL. | 20-Oct-10 13:41 |
| 1231 | Andreas | Makes no difference. | 20-Oct-10 13:40 |
| 1230 | amacleod | Might that be a burden on hte server for very large queries? | 20-Oct-10 13:39 |
| 1229 | Andreas | http://www.json.org/json.r will help you with the encoding. | 20-Oct-10 13:39 |
| 1228 | Andreas | In any case, I'd probably just do plain queries and construct the JSON from the resultset. | 20-Oct-10 13:39 |
| 1227 | Andreas | Ok. | 20-Oct-10 13:38 |
| 1226 | amacleod | I believe its 5.1.30 | 20-Oct-10 13:38 |
| 1225 | Andreas | You are using MySQL 4.1+? | 20-Oct-10 13:37 |
| 1224 | amacleod | Anyone know if that is supported with mysql-protocol? | 20-Oct-10 13:37 |
| 1223 | amacleod | What is the SOP for building json objects from MySQL queries? I saw this but I could not get it to work: SELECT CONCAT("[", GROUP_CONCAT( CONCAT("{username:'",username,"'"), CONCAT(",email:'",email),"'}") ) ,"]") AS json FROM users; | 20-Oct-10 13:36 |
| 1222 | amacleod | great! | 27-Aug-10 18:48 |
| 1221 | caelum | amacleod, Progress: After a lot of messing around I got that script working. So now I can access my databases using Rebol. NICE! | 27-Aug-10 2:33 |
| 1220 | caelum | ChristianE, I could not find the SKIP-NETWORKING config entry anywhere on cpanel, but after reading some tech docs from my ISP I conclude they have it set to only allow database access via Unix sockets, so I guess I will have to live with that. | 27-Aug-10 2:32 |
| 1219 | amacleod | Caelum, instead of 'read' use 'load' when your remote client accesses teh cgi script. That will give you your data back in rebol blocks intead of text. | 26-Aug-10 19:51 |
| 1218 | ChristianE | If the SKIP-NETWORKING config entry is enabled, MySQL won’t listen for TCP/IP connections at all. That's a security setting. All interaction with MySQL must then be made via Unix sockets. Whereas the mysql-driver only supports TCP connections. I don't no about CPanel, but look out for some CPanel setting like "skip networking" or alike. | 25-Aug-10 19:19 |
| 1217 | caelum | Thanks amacleod I'll give that a try. ChristianE, I don't see any MySQL settings like that on my cpanel, which I am familiar with. I don't know if my ISP allows me to access such things. I've never seen that kind of information about MySQL in cpanel. How would I check? I am also looking for a virtual server where I can set everything myself in order to use Rebol to access databases and create HTML. If possible I want to eliminate PHP and use Rebol as my standard web interface program, but until I can get Rebol reading/writing to my databases I am stuck. | 25-Aug-10 19:02 |
| 1216 | ChristianE | Have you checked whether MySQL is configured properly to accept tcp-requests instead of only socket-based connections? | 25-Aug-10 6:19 |
| 1215 | amacleod | Place this file in your cgi-bin and have your remote client 'read' the url to that file. Don't forget to place mysql-protocol.r somewhere on the server an 'do' it. you could 'encript' the output with encloak using a simple key if some security of the data is needed. Just decloak at the remote client with same key. | 25-Aug-10 3:26 |
| 1214 | amacleod | Here is a simple example but basically you just create a script that reads from the DB locally and prints. Your remote app reads the printout when it reads from the page: #!/user/cgi-bin/REBOL -cs REBOL [Title: "Get Roster"] do %mysql-protocol.r db_ip: mysql://user:password@localhost:3306/bighouse db: open db_ip insert db "SELECT * FROM roster" dat: copy db close db print dat | 25-Aug-10 3:21 |
| 1213 | caelum | I pinged the server just fine. Here is the code: REBOL [] #include do %mysql-protocol.r results: read rejoin [mysql://mysqluser:mypassword@mysite.com:22/mydatabase ["SELECT * FROM tablename"] The MySQL server is on a hosted machine. In cpanel I added my IP address to the 'Remote MySQL' Remote Database Access Hosts list. I think you are right that I will need to access the database from the cgi because the hosting company will not allow direct access, even though its suppossedly allowed in cpanel. Thanks for your help. Are there any examples of accessing a MySQL database via CGI in Rebol? I just googled and found nothing. | 25-Aug-10 3:04 |
| 1212 | amacleod | Is the Mysal server on your local machine? or on a hosted machine? Sometimes the host company will not allow you to directly acess the server from remote locations. You would need to access it via CGI. | 25-Aug-10 1:57 |
| 1211 | amacleod | Sounds like you are not connecting to the server...try pinging it first. Check the port. Shows us the code you aer using. | 25-Aug-10 1:55 |
| 1210 | caelum | Hi MySQL Group, I program in C, Fortran, Cobol, Superbase4, PHP, MySQL and some other languages but I'm fairly new to Rebol. I am attempting to connect to a remote MySQL database by following the intstructions here http://reboltutorial.com/blog/mysql/. I have downloaded the mysql-protocol.r file and run it in my Rebol program but I keep getting this error 'Access Error: Network timeout'. What does that mean? How do I fix it? Any help appreciated. | 24-Aug-10 22:35 |
| 1209 | Henrik | I usually build a server script to access the database via procedures needed for the app. They then communicate via JSON. Works pretty well and eliminates the need for client side SQL, and it works with anything that can POST to a webserver. | 25-May-10 6:50 |
| 1208 | amacleod | I think I will need to convert my app over to a cgi based access for mysql as I may want to access them from non-rebol based clients (smart phones). Does anyone know what is the standard method for say iphones to access data from servers? CGI? or is there other prefered method? | 24-May-10 21:38 |
| 1207 | amacleod | I'm using my own server for now until bandwidth becomes an issue. | 24-May-10 21:31 |
| 1206 | amacleod | that makes no sense!!! I wrote all over my own message | 24-May-10 21:31 |
| 1205 | amacleod | 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. | 24-May-10 21:29 |
| 1204 | TomBon | 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. | 24-May-10 21:26 |
| 1203 | TomBon | 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. | 24-May-10 21:26 |
| 1202 | Graham | A web provider only provides access to mysql from a script ... and you will have a static ip for your web host. | 24-May-10 21:13 |
| 1201 | Graham | Eh?? | 24-May-10 21:13 |
| 1200 | amacleod | 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? | 24-May-10 21:06 |
| 1199 | Dockimbel | what you work => what would work | 4-Mar-10 19:06 |
| 1198 | Dockimbel | 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). | 4-Mar-10 19:04 |
| 1197 | Robert | 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? | 4-Mar-10 18:54 |
| 1196 | Will | Understanding and control of MySQL query optimizer http://assets.en.oreilly.com/1/event/21/Understanding%20and%20Control%20of%20MySQL%20Query%20Optimizer_%20Traditional%20and%20Novel%20Tools%20and%20Techniques%20Presentation.pdf | 28-Sep-09 3:30 |
| 1195 | Graham | As for waiting for Qtask to decide on their licensing ... well, enuff said. | 5-Jul-09 23:07 |
| 1194 | Graham | to communicate with sphinx. | 5-Jul-09 23:06 |
| 1193 | Graham | I don't use mysql .. but Firebird. And I'm waiting for the sphinx integration into firebird before I try doc's mysql driver. | 5-Jul-09 23:06 |
| 1192 | Will | from the changelog, " Fixed parsing bug with \\. Now expression like "'\\', 'wo;rd'" will be parsed correctly." | 5-Jul-09 22:00 |
| 1191 | Will | here is the latest http://softinnov.org/tmp/mysql-protocol-41.r give it a try | 5-Jul-09 21:57 |
| 1190 | Will | IIRC previous version had a problem with escaping correctly {'} in some circumstances, that may be a cause of truncation. | 5-Jul-09 21:54 |
| 1189 | Will | Graham: no, do you? how is your experience with it? | 5-Jul-09 21:40 |
| 1188 | Will | are you using latest 1.3beta versionof the driver? previus version may have a problem and truncate.. | 5-Jul-09 21:39 |
| 1187 | amacleod | 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. | 5-Jul-09 16:00 |
| 1186 | amacleod | I check it out thanks, Doc. | 5-Jul-09 15:59 |
| 1185 | Dockimbel | 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. | 5-Jul-09 11:13 |
| 1184 | Graham | Will did you not try the mysql driver for sphinx?? | 5-Jul-09 10:28 |
| 1183 | Will | Maarten: is there any news about your Sphinx stuff? Reichart "promised" to release it soon, that was some time ago 8) | 5-Jul-09 9:19 |
| 1182 | Will | 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 | 5-Jul-09 9:13 |
| 1181 | Graham | try wireshark to do a tcp trace to make sure all the packets are getting thru | 5-Jul-09 3:35 |
| 1180 | Graham | can you use any other formats? Does mysql have text blobs ? | 5-Jul-09 3:25 |
| 1179 | amacleod | 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? | 5-Jul-09 1:54 |
| 1178 | amacleod | 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? | 5-Jul-09 1:46 |
| 1177 | amacleod | I know..a little off topic..moving to core | 8-Jun-09 0:52 |
| 1176 | amacleod | Rebol must get the zone from the computer but why is it different? | 8-Jun-09 0:34 |
| 1175 | amacleod | I tried again and they are now synced...atleast to the minute... | 8-Jun-09 0:32 |
| 1174 | amacleod | 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 | 8-Jun-09 0:31 |
| 1173 | amacleod | ok, but what is rebol reading to get the time? | 8-Jun-09 0:29 |
| 1172 | Graham | daylight saving? | 8-Jun-09 0:28 |
| 1171 | amacleod | 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 | 8-Jun-09 0:27 |
| 1170 | amacleod | insure | 7-Jun-09 20:58 |
| 1169 | amacleod | 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? | 7-Jun-09 20:58 |
| 1168 | amacleod | right...duh! | 7-Jun-09 19:07 |
| 1167 | Janko | load "[... ]" | 7-Jun-09 18:03 |
| 1166 | Janko | hm.. I think you use load to get rebol data back from string | 7-Jun-09 18:03 |
| 1165 | amacleod | 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? | 7-Jun-09 17:42 |
| 1164 | amacleod | I'm using 'mold/only' saving to mysql and 'to-block' to re-block it... is there a cleaner way like an 'unmold'? | 7-Jun-09 17:39 |
| 1163 | Janko | yes you need to deserialize it after retrieval. | 7-Jun-09 17:24 |
| 1162 | amacleod | yeah, my app crashes I need to convert back to block... | 7-Jun-09 17:10 |
| 1161 | amacleod | 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 | 7-Jun-09 17:08 |
| 1160 | Janko | 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? | 7-Jun-09 17:04 |
| 1159 | amacleod | text has no issues in sqlite | 7-Jun-09 17:03 |
| 1158 | amacleod | I've tried text and varchar | 7-Jun-09 17:03 |
| 1157 | Janko | maybe sqlite molds it automagically ? | 7-Jun-09 17:03 |
| 1156 | Janko | do you "mold" it? what kind of field do you try to store it in? | 7-Jun-09 17:03 |
| 1155 | amacleod | for example: [["edfefwf" 3.4.5]["gdegerg" 4.5.6]] | 7-Jun-09 17:02 |
| 1154 | Janko | ups.. wrong channel | 7-Jun-09 17:00 |
| 1153 | Janko | no, where can I find it? | 7-Jun-09 17:00 |
| 1152 | Janko | you mean molded nested block - text? | 7-Jun-09 16:59 |
| 1151 | amacleod | Is there any reason mysql will not accept a nested block in a text field? I have no problem with sqlite storing the same data... | 7-Jun-09 16:40 |
| 1150 | amacleod | Nice, Thanks. | 29-May-09 16:36 |
| 1149 | Sunanda | One table will be much easier to manage. Two thoughts: If you use Views to create "virtual tables" for each user, then you can (fairly) easily change the underlying structure without disrupting the application too much should you need to for performance reasons. If your data does grow large, then partitioning my help performance -- ie having one table split across multiple drives according to data values (such as user name): http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html | 29-May-09 15:36 |
| 1148 | amacleod | No, not really...
One table would be much easier and I do not think the db would get so large that I would see major performance problems. (I always underestimate the speed of these db's.) Thanks for the advice, Sunanda. | 29-May-09 15:22 |
| 1147 | Sunanda | Then it'd be normal to have one large table.
But (and I iguess this is your question): are there worthwhile (perhaps essential) performance improvements by denormalising? Perhaps partitioning different users on different drives or servers.
Sadly, normalisation theory is silent on that subject. Can you experiment with some generated fullsize data and see? | 29-May-09 15:18 |
| 1146 | amacleod | I guess fixed fields | 29-May-09 15:15 |
| 1145 | amacleod | Each table will be the exact same stucture | 29-May-09 15:14 |
| 1144 | Sunanda | Is the users' data freeformat, or fixed fields? ie do they each have the same data fields (but with different values), or can they define whatever data they want to store? | 29-May-09 15:14 |
| 1143 | amacleod | Need some advice on db structure.
I'm not sure which would be better for this senario: I want to store user generated data which could consist of thousands of rows. But I also will want to be able to search across each users data. I could create a seperate table for each user and join tables when searching through all user data or I could make one large database with a user field to seperate out that user's data when needed. There could be many hundred users. What is SOP in such a case? | 29-May-09 15:11 |
| 1142 | Dockimbel | Thanks :-) | 25-May-09 12:33 |
| 1141 | TomBon | yes, will use the prepared statement. it is also more elegant. with escaping I need to handle all fields to be save. btw. many thx to provide such a cool, free and very important driver! | 25-May-09 10:20 |
| 1140 | Dockimbel | There's also an alternative approach, the SQL-ESCAPE encoding function of MySQL driver is exported in the global context, so you can use it when forming SQL queries directly : send-sql db join "UPDATE table SET field=" sql-escape string The prepared statement approach is recommended, because the driver will care about that for you automatically (so less risks that you forget to encode one value, opening a hole for SQL injection attacks). | 25-May-09 10:11 |
| 1139 | TomBon | ahh...thx doc. I formed the insert classical without question marks. | 25-May-09 10:02 |
| 1138 | Dockimbel | Hi TomBon, when using prepared statements, special characters are encoded in passed values. send-sql db ["UPDATE table SET field=?" string] ; string value will be encoded here | 25-May-09 9:56 |
| 1137 | TomBon | hi doc, is there any trick or encoding to prevent inserting errors due to strings containing special characters like ' or / etc? | 25-May-09 9:45 |
| 1136 | RobertS | . | 22-May-09 15:55 |
| 1135 | Graham | wow ... two for the price of one! | 14-May-09 21:04 |
| 1134 | Dockimbel | I think so. | 14-May-09 20:37 |
| 1133 | Graham | is doc's mysql protocol the binary one they talk about? | 14-May-09 20:12 |
| 1132 | Maarten | Interesting indeed. I'll pick this up with Reichart; we are all in favour, it merely is a matter of time (pressure). The libs are nice, but I am sure others can help improving them. | 14-May-09 14:00 |
| 1131 | Graham | Here's an interesting conversation ! http://www.sphx.org/forum/view.html?id=1210 | 14-May-09 11:55 |
| 1130 | Graham | That was a year ago ... | 14-May-09 11:53 |
| 1129 | Will | Maarten has one that's waiting Reichart approval to get released 8) | 14-May-09 11:18 |
| 1128 | Janko | I will put it on rebol.org | 14-May-09 9:51 |
| 1127 | Graham | This is interesting http://sphinxsearch.com/news/37.html .. you can now connect to the sphinx searchd daemon using the mysql binary protocol ... so doc's mysql driver can also now connect to sphinx?? | 14-May-09 9:13 |
| 1126 | Graham | Can you put it on rebol.org in the library. | 14-May-09 9:04 |
| 1125 | Janko | it's not much though - but I can share without problem if anyone needs | 14-May-09 8:56 |
| 1124 | Janko | I have made a primitive client libs to the SOLR search engine, if that helps anyone | 14-May-09 8:55 |
| 1123 | Graham | There is this API document being worked on http://sphinxclient.codeplex.com/SourceControl/ListDownloadableCommits.aspx | 14-May-09 8:42 |
| 1122 | Graham | Has anyone released a sphinx Rebol client api implementation? | 14-May-09 7:28 |
| 1121 | amacleod | Thanks anyway... | 10-May-09 14:11 |
| 1120 | Dockimbel | I'm just understanding now what you're trying to do. READ-NET is not what you want to use, it's for downloading files! You have to write your own progress bar function. About the total size of result set, AFAIK, MySQL server doesn't send that information, it just marks the last record of a result set. | 9-May-09 8:33 |
| 1119 | amacleod | Doc, I played around with read-net but no luck.
Would not read-net need to know total size of query result to work?
Does the server send this info first? also, read-net wants a URL. Where am I pointing it to? Is this the same as the db port i'm using? | 9-May-09 6:55 |
| 1118 | Dockimbel | Thanks for the additional info. The main change in 1.2.0 is the new READ syntax, and it's documented here : http://softinnov.org/rebol/mysql-usage.html#sect2.2. | 29-Apr-09 22:02 |
| 1117 | amacleod | I'm hosting a large number of text docs broken up by sections in a mysql db. Once all the material is on line the changes (and thus downloads) wil be smal for the most part. But in the mean time large amounts of material are still to be uploaded to the db and when a client finds this new material it will download it and any changes to previous material. The material contains a lot of image data too so it could add up. Right now I have about 40 megs of data and I have about 10X more to upload. If its too tuff for me I will just display some animated gif but I would prefer something more tangible.. I'll look into your suggestion, Thanks Doc... BTW I tried the latest mysql-protocol and it broke my app. I have not had a chance to look into it but I think you changed some syntax for selects?? I'm using Version: 1.1.2 at the moment. | 29-Apr-09 20:33 |
| 1116 | Dockimbel | No, there's no such callback. But you can easily add one in my driver by inserting a call to "read-net" in the FOREVER loop inside READ-ROWS function. Can you describe briefly the situation where you need to get large query results and display a progress bar (just curious)? | 29-Apr-09 20:07 |
| 1115 | amacleod | for large query results is there a way to show a progress bar as an indicator of the download progress? Is there some type of callback method like "read-net"? | 29-Apr-09 19:11 |
| 1114 | Dockimbel | Good to know! Thanks. | 21-Apr-09 21:53 |
| 1113 | Will | I use your driver with 5.1.x no problem 8-) | 21-Apr-09 21:15 |
| 1112 | Maarten | Yeah, but you're driver has the source. Also, in the ancient times before COmmand 2.x and your mysql:// I did a library interface, it's still on rebol.org | 18-Apr-09 12:59 |
| 1111 | Dockimbel | Btw, I've never tested my driver with a 5.1.x server. | 17-Apr-09 20:22 |
| 1110 | Dockimbel | Don't know, I think it doesn't support anything above 3.x but I can't find the full /Command feature list on rebol.com to confirm. | 17-Apr-09 20:20 |
| 1109 | BrianH | Does the /Command client support MySQL 5.1? | 17-Apr-09 20:08 |
| 1108 | Dockimbel | You should try with the official command line mysql client. If you notice a different behaviour than the mysql:// driver, please report it here. | 17-Apr-09 19:56 |
| 1107 | BrianH | The DDL in question is create table statements where some obscure semantic rule is violated. By obscure, I mean it took me a day to track down the error in the MySQL manuals. | 17-Apr-09 19:54 |
| 1106 | BrianH | I've run into situations where MySQL will fail to do DDL without throwing an error, at least not one the mysql:// driver notices. Haven't tested with the /Command driver or qcmysql:// though. | 17-Apr-09 19:49 |
| 1105 | Dockimbel | insert db [create-db "test2"] works flawlessly here....You've probably connected to the server with a user that didn't had enough rights for creating databases, but it's hard to figure out from a "does not seem to work" issue description. I start to better understand Carl's willings for filtered communication channels that improve the signal to noise ratio in order to save some valuable working time... | 17-Apr-09 19:45 |
| 1104 | amacleod | I got it! | 17-Apr-09 18:06 |
| 1103 | amacleod | I still can't create db but never mind as I'm going with tables...Thanks again | 17-Apr-09 17:55 |
| 1102 | Oldes | I think there is no limit on number of tables. A database in MySQL is implemented as a directory containing files that correspond to tables in the database. | 17-Apr-09 17:52 |
| 1101 | amacleod | Oldes | 17-Apr-09 17:52 |
| 1100 | amacleod | Thanks olds...I think that will making everything simpler for me too. | 17-Apr-09 17:52 |
| 1099 | Oldes | I don't know details, but I think one database should be enough | 17-Apr-09 17:51 |
| 1098 | Oldes | forget the first one:) | 17-Apr-09 17:50 |
| 1097 | Oldes | insert db "CREATE DATABASE test2" | 17-Apr-09 17:50 |
| 1096 | Oldes | insert db "SELECT * FROM user" | 17-Apr-09 17:49 |
| 1095 | amacleod | Anyone know SOP for this situation: I have hundreds of users (not yet really) )and I need to store several tables of user data for each. Should I create a seperate database for each user or is it better to use a naming scheme for the tables and store all of them in one database? or is it just personal preference? | 17-Apr-09 17:46 |
| 1094 | amacleod | Is there a limit to the number of tables in a database? | 17-Apr-09 17:41 |
| 1093 | amacleod | Can you create a database remotely? Anyone know the syntax? I tried: insert db [create-db "test2"] with db=port but does not seem to work | 17-Apr-09 17:22 |
| 1092 | DideC | Ok, it works now. My bad, I put the last protocol in a folder but I where still loading the old one from another folder ! | 1-Apr-09 7:52 |
| 1091 | Dockimbel | MySQL config file (my.cnf) can be in one of these places : - /etc/ - $HOME/ - MySQL data folder | 30-Mar-09 14:17 |
| 1090 | Dockimbel | v1.2.1 is supposed to work with both old and new passwords. | 30-Mar-09 14:14 |
| 1089 | DideC | Does protocol v1.2.1 works with new password method ? If so, maybe I just need to update the user password int he db ?* | 30-Mar-09 13:51 |
| 1088 | DideC | (I just look at the variable in phpmyadmin. | 30-Mar-09 13:48 |
| 1087 | DideC | Client version is the last one. | 30-Mar-09 13:48 |
| 1086 | DideC | OK, old-password is off in the server variable. Do you know where is the config file where this variables are sets (Ubuntu) ? | 30-Mar-09 13:47 |
| 1085 | Dockimbel | Just installed 5.0.77 community server on Windows, no problem to log in using default password mode with mysql protocol v1.2.1. | 30-Mar-09 12:46 |
| 1084 | Dockimbel | Btw, you should check if your code is not using an older version of %mysql-protocol.r (just in case you're reusing old source files). | 30-Mar-09 12:24 |
| 1083 | Dockimbel | "Start mysqld with the --old-passwords option. " seems the simpliest way to workaround that. | 30-Mar-09 12:22 |
| 1082 | Dockimbel | I'm using 5.0.18 and don't have such issues. Anyway to find a fix, have a look here : http://dev.mysql.com/doc/refman/5.1/en/old-client.html | 30-Mar-09 12:21 |
| 1081 | DideC | It's MySQL - 5.0.51a Do you know how to do that ? | 30-Mar-09 11:46 |
| 1080 | Pekr | there are two types of authentication schemes ... IIRC, onwards from 4.1 or 4.0.1 mysql switched to stronger authentication. So - if you upgraded or used older DBs, you have to explicitly set old auth method ... | 30-Mar-09 11:31 |
| 1079 | DideC | I have a new mysql server but I can't connect to it with %mysql-protocol v1.2.1 : >> open mysql://user:traiteur@localhost/testjmg connecting to: localhost ** User Error: ERROR 1251 : Client does not support authentication protocol requested by server; consider upgrading MySQL client ** Near: open mysql://user:traiteur@localhost/testjmg I know I have to change something in the mysql server configuration, but does anyone can point me to what it is ? | 30-Mar-09 11:16 |
| 1078 | Davide | > My guess is also that Oracl, SQL Server and perhaps PostGreSQL are smarter with their table optimziers and query rewriters Postgres is about 2 times faster than MySQL in this query, but the execution time grow alot as num of records increase. So I really don't know how good is compared to MySQL. Oracle, I would try, but I have no time :-P > Also, change the count(*) to count(1) Thanks, good one. The real tables will be more large (5 M record or more), so small optimizations would be not sufficient I'm tryng a different approach, using one simple stored function: create function running_total (cod VARCHAR(50), adder DECIMAL) RETURNS DECIMAL BEGIN IF @last_cod <> cod THEN BEGIN SET @running_total = 0; SET @last_cod = cod; SET @num_row = 0; END; END IF; SET @running_total = @running_total + adder; SET @num_row = @num_row + 1; RETURN @running_total; END and using as select: SET @last_cod = ''; SET @running_total = 0; SET @num_row = 0; SELECT cod , date, running_total(cod , amount), @num_row FROM a ORDER BY cod, date; This approach seems really fast : processing and inserting 100'000 records took less than 1 sec. instead of 281,73 sec. with SQL join | 2-Mar-09 18:49 |
| 1077 | BrianH | Also, change the count(*) to count(1), so MySQL doesn't push the full contents of the join through the count processor. | 2-Mar-09 17:16 |
| 1076 | Maarten | Davide, first: NULL value are evil (as are duplicate rows).My guess the cost is the fact that your query probably runs a fulll table scan as it needs to sum all of the rows... So table partitioning will help a lot. My guess is also that Oracl, SQL Server and perhaps PostGreSQL are smarter with their table optimziers and query rewriters. HTH | 2-Mar-09 14:28 |
| 1075 | Davide | > is there any reason why you join A on A? If I have these records: cod date amount A 2009/03/01 10 A 2009/03/03 30 A 2009/03/04 20 A 2009/03/07 5 B 2009/03/02 17 B 2009/03/10 5 That query give me the sum of previous amounts for every date/cod: cod date amount NumRow A 2009/03/01 10 1 A 2009/03/03 40 2 A 2009/03/04 60 3 A 2009/03/07 65 4 B 2009/03/02 17 1 B 2009/03/10 22 2 I don't know if there's a better method without using join > also.. have you tried to EXPLAIN the query? Yes, explain returns that the correct indices are used. Not very informative. | 2-Mar-09 13:12 |
| 1074 | Oldes | is there any reason why you join A on A? also.. have you tried to EXPLAIN the query? http://dev.mysql.com/doc/refman/5.0/en/explain.html | 2-Mar-09 10:57 |
| 1073 | Davide | Is there a MySQL guru around ? I need to optimize this query: SELECT A.cod, A.date , SUM(B.amount) AS amount, COUNT( * ) AS numrow FROM A INNER JOIN A AS B ON A.cod=B.cod AND B.date <= A.date WHERE A.cod IS NOT NULL GROUP BY A.cod, A.date This return "running sums" (partial sum for every date and every cod). Both cod and date are indexed. In a table of about 100'000 records it takes 104 sec to complete while in SQL server 2005 (the same query, on the same data, on the same index ) it takes 3 sec ! I've tried to use MyIsam, InnoDB, MEMORY storage, and used BOTH btree and hash index. I've tried to FORCE Index for Join and Group too. Any suggest ? | 2-Mar-09 0:48 |
| 1072 | amacleod | I got it....
I have to convert it back to binary. ("to-binary")
I assumed that if I was giving it a binary file it would remain in binary just as sqlite treated it....The field attributes state "binary". Thanks for the help, Will! | 14-Jan-09 2:32 |
| 1071 | Will | ehat -> what | 14-Jan-09 0:47 |
| 1070 | Will | btw, I suggest not to store images in the db, store it somewhere on your hardrive and put in the db a pointer to the file, if you really need it and do not find ehat's wrong, ping me in the weekend and I can test that here, althougt I use other binary data with mysql-protocol with no problem, not sure if it apply but check also encodings for mysql storage, etc | 14-Jan-09 0:46 |
| 1069 | Will | can you diff.. | 14-Jan-09 0:41 |
| 1068 | Will | http://en.wikipedia.org/wiki/Diff | 14-Jan-09 0:41 |
| 1067 | amacleod | diff? | 14-Jan-09 0:32 |
| 1066 | Will | ca you diff the binary data of the image before you send it to db and after retriving it? also once the data is inserted thru mysql-protocol can you retrive the image from the db with another client and see if it works? | 13-Jan-09 23:06 |
| 1065 | amacleod | I'm trying to upload a binary (image) file to a mysql DB. When I retrieve it teh binary data seems to have changed and I can not display the image. I was able to do it with sqlite with no problem. I'm using the mediumblob field type for the image data... Any ideas what I might be doing wrong? | 13-Jan-09 6:05 |
| 1064 | ? | I have installed mySQL and Oracle as part of my studies for improving TretbaseDB. I'm curious from others that use mySQL with REBOL as to what they dislike about the interoperablility or what they like most about it. | 23-Dec-08 18:43 |
| 1063 | ManuM | . . | 23-Dec-08 15:18 |
| 1062 | Dockimbel | Thanks for the report, I'll fix that in the next beta release. There's also other fixes from Will pending. | 18-Dec-08 9:43 |
| 1061 | Gabriele | (mysql-protocol-41.r) | 18-Dec-08 9:39 |
| 1060 | Gabriele | read-packet: func [port [port!] /local packet-len pl status tmp][ | 18-Dec-08 9:39 |
| 1059 | Gabriele | should be: | 18-Dec-08 9:39 |
| 1058 | Gabriele | read-packet: func [port [port!] /local packet-len pl status][ | 18-Dec-08 9:39 |
| 1057 | Gabriele | Doc, the read-packet function in mysql-protocol.r is missing one word in the /local list. Line 538: | 18-Dec-08 9:39 |
| 1056 | Graham | I think that someone had setup a password ... so I purged mysql, deleted my.cnf and reinstalled. That worked. | 13-Dec-08 21:54 |
| 1055 | Dockimbel | What does read dns://127.0.0.1 give you? It may be related to a mismatch in the localhost name mapping, so you have to add access rights for root@... (or root@127.0.0.1) in MySQL to workaround that issue. | 13-Dec-08 21:19 |
| 1054 | Graham | I thought root was automatically created with no password?? | 12-Dec-08 22:45 |
| 1053 | Graham | get "Access denied for user 'root'@'localhost' (using password: No ) | 12-Dec-08 22:45 |
| 1052 | Graham | just installed mysql on ubuntu 8.1 but can't login ... | 12-Dec-08 22:44 |
| 1051 | Will | use /debug it will print query to the console without sending it to the server so you can play and understand how it works | 3-Dec-08 21:30 |
| 1050 | Will | and I will be glad to answer any questions and add feature requests 8) | 3-Dec-08 21:29 |
| 1049 | Will | sorry it is still rought and there is no docs, thought some comments in the code exists, I use it in production so, solid it must be. | 3-Dec-08 21:29 |
| 1048 | AdrianS | thanks - is there a page somewhere describing it in more detail? | 3-Dec-08 21:25 |
| 1047 | Will | .db/get/debug 'node 'id 1 ; "SELECT `id` FROM `node` WHERE id=1.0 LIMIT 0,1" | 3-Dec-08 21:21 |
| 1046 | Will | ;without wrapper:
do http://softinnov.org/tmp/mysql-protocol-41.r
db: open mysql://localhost/db1
nodes: send-sql/named {SELECT `id` `name` `data` FROM `node`}
node: send-sql/named {SELECT `id` `name` `data` FROM `node` WHERE `id`='1'} ;with wrapper: do http://softinnov.org/tmp/mysql-protocol-41.r do http://reboot.ch/rebol/mysql-wrapper.txt .db/databases: [ db1 mysql://localhost/db1 db2 mysql://localhost/db2 ] .db/use 'db1 nodes: .db/get/all 'node [id name data] none node: .db/get 'node [id name data] [{`id`=?} 1] ;if you follow the rule to name your primary-key "id", ;you can use this shorter version: node: .db/get 'node [id name data] 1 ;/debug is your friend, use it to see the generated query | 3-Dec-08 21:19 |
| 1045 | Will | it is just a utilities wrapper that works on top of the mysql-protocol.r, it makes queriing mysql more rebolish | 3-Dec-08 21:03 |
| 1044 | AdrianS | Will, what does the wrapper do compared to the MySQL driver? | 3-Dec-08 20:50 |
| 1043 | Will | here is updated wrapper, http://reboot.ch/rebol/mysql-wrapper.txt | 3-Dec-08 20:37 |
| 1042 | Gabriele | http://softinnov.org/tmp/mysql-protocol-41.r | 3-Dec-08 18:51 |
| 1041 | Will | Thanks Dock! 8) | 3-Dec-08 16:28 |
| 1040 | Dockimbel | The change I did on [Fri 21:21] version on the way SQL requests with multiples statements are sent to the server, might not be a good idea for sending big SQL batch files to the server. The previous method (slicing SQL requests and sending them one by one to the server) wasn't that bad (could allow streaming the reading of a big SQL file from disk). Maybe it should be good to let the user choose how the driver should send multiple SQL queries. | 3-Dec-08 15:47 |
| 1039 | Dockimbel | Bugfix revision for MySQL driver 1.3 beta at http://softinnov.org/tmp/mysql-protocol-41.r Changes: - Fixed a regression bug appearing when trying to open a connection without a database name. - Fixed "port not open" error after automatic reconnection. | 3-Dec-08 15:34 |
| 1038 | Dockimbel | I might drop out the SQL requests splitting code (and also the delimiter option) from the driver as now everything is sent as-is to the server. It might still be useful for big SQL files, not sure what the best strategy should be in such case (send file as one big packet, or split it and send each request one by one) ? | 28-Nov-08 20:28 |
| 1037 | Dockimbel | Improved version of MySQL driver 1.3 beta released at http://softinnov.org/tmp/mysql-protocol-41.r Changes: - Improved automatic flushing of unread data. Now you can forgot the second COPY on sproc calls (should be robust, but needs testing). - Multiple SQL requests are now sent as one packet by default. No more need to change the db/locals/delimiter value for 4.1+ servers. | 28-Nov-08 20:21 |
| 1036 | Dockimbel | After analyzing the report you sent to me about issue with sproc. MySQL has a odd behaviour, it seems to always return 2 result sets for a sproc even when you're expecting only one (the second will then be empty). So, after calling a sproc you have to call COPY twice (or once after a SEND-SQL) to flush the remaining data. I'm looking in the driver to see if I can automate this flushing process. | 28-Nov-08 17:54 |
| 1035 | Dockimbel | I used to reverse-engineer, but since 5.0(?) MySQL AB documents the protocol with sometimes (intentional?) blocking errors. | 27-Nov-08 18:01 |
| 1034 | Oldes | found it http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol | 27-Nov-08 16:38 |
| 1033 | Oldes | I've send more info into private in R3-alpha... anyway.. I wonder where it's possible to find some mysql protocol spec. Do you just do reverse engineering? | 27-Nov-08 16:22 |
| 1032 | Oldes | But there must be a bug anyway .... the first one shows that.. next sql query after the procedure call returns none. | 27-Nov-08 15:28 |
| 1031 | Oldes | I thought I'm, but the version was older.. now it's working fine:) | 27-Nov-08 15:13 |
| 1030 | Dockimbel | Calling stored procedures is not supported in driver versions < 1.3. | 27-Nov-08 12:54 |
| 1029 | Dockimbel | Oldes: are you sure you're using the 1.3 beta mysql:// driver ? You can find it here : http://softinnov.org/tmp/mysql-protocol-41.r | 27-Nov-08 12:53 |
| 1028 | Gabriele | the cheyenne error is probably because you need the new version of mysql:// that Doc posted a few days ago | 27-Nov-08 5:03 |
| 1027 | Oldes | It looks, that there is something wrong with MySQL procedures:
using mysql.r
mysql> CREATE PROCEDURE myproc() SELECT 'it works!';
mysql> call myproc();
+-----------+
| it works! |
+-----------+
| it works! |
+-----------+
1 row(s) in set
mysql> call myproc();
mysql> On the second run it returns nothing. using it in cheyenne gives error: Error Code : 800 Description : user error ! ERROR 1312 : PROCEDURE webcore.myproc can't return a result set in the given context Near : [do-sql 'webcore "call myproc();" txt 3195] Where : none | 27-Nov-08 1:49 |
| 1026 | Dockimbel | Enjoy ! :-) | 15-Nov-08 20:21 |
| 1025 | Dockimbel | Here's an example showing the new possibilities combined (multiple queries support, setting custom delimiter and multiple results support) : db: open mysql://root@localhost/mysql db/locals/delimiter: "*;*" insert db "show tables; show databases" copy db ; <= returns tables block! copy db ; <= returns databases block! copy db ; <= returns none! | 15-Nov-08 20:20 |
| 1024 | Dockimbel | It now passes all my non-regression tests, but I've done several deep changes, so I'll consider it beta until the end of the year before declaring it the new official version. | 15-Nov-08 20:16 |
| 1023 | Dockimbel | New version 1.3 of new MySQL driver released as beta. (same URL). Changes: - Fixed the multiple result sets end-of-stream issue. Now an extra COPY will return NONE, marking the end of the data stream. - Fixed error message parsing for protocol 4.1. - Added SQL request delimiter property to port/locals/delimiter (default: #";") | 15-Nov-08 20:14 |
| 1022 | Gabriele | Maarten, you're working too much :) Nenad: thanks! If I have some time, I'll have a look too, though I will just be making guesses. :) | 13-Nov-08 9:52 |
| 1021 | Dockimbel | Thanks for the link, that confirms that's possible to detect the last result set. I'm keep getting "more results"' status even for the last set, but now I think that it's caused by a bug in my code. I'll look at it this week end (too busy until there). | 12-Nov-08 18:56 |
| 1020 | Maarten | I'm here. I think there is a C API call for the number of result sets. Primitive, but this is how to do it: http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html | 12-Nov-08 16:51 |
| 1019 | Gabriele | (he can read the mail address listed here on altme from his ipod touch) | 12-Nov-08 14:08 |
| 1018 | Gabriele | BTW, Maarten told me that he knows for sure that you can get the number of result sets in advance, if he doesn't show up here (he can't be much in front of a computer these days), maybe you could email him to get more info. | 12-Nov-08 14:07 |
| 1017 | Gabriele | this is going to be very useful :-) | 12-Nov-08 14:06 |
| 1016 | Gabriele | the above new version seems to work fine for simple tests, apart from the issues Nenad has already listed. | 12-Nov-08 14:05 |
| 1015 | Will | Thank you! 8-)) | 12-Nov-08 0:52 |
| 1014 | Dockimbel | Thank Gabriele for keep pushing me. ;-) | 11-Nov-08 15:01 |
| 1013 | Pekr | good news! | 11-Nov-08 14:56 |
| 1012 | Dockimbel | It should be considered as a early beta, so test it well before using. | 11-Nov-08 14:51 |
| 1011 | Dockimbel | Keep in mind that if you're using SEND-SQL, it already does a implicit COPY. | 11-Nov-08 14:50 |
| 1010 | Dockimbel | I've just upload a new experimental 1.3 version of MySQL driver supporting mutiple queries, stored procedures and multiple result sets. Reading mutiple results is done by calling COPY for each result. Download at http://softinnov.org/tmp/mysql-protocol-41.r | 11-Nov-08 14:47 |
| 1009 | Alan | . | 14-Sep-08 7:04 |
| 1008 | james_nak | Thanks Will. | 5-Aug-08 20:31 |
| 1007 | Will | James: sorry for the delay, still not found time for docs but her it is "as is.." /debug is your friend, get started, load Dock driver , then load http://reboot.ch/rebol/mysql-wrapper.txt then:
;set a list of connections:
.db/databases: [
;local
mydb1.local mysql://user:password@127.0.0.1/mydb1
mydb2.local mysql://user:password@127.0.0.1/mydb2 ;online mydb1 mysql://user:password@127.0.0.1:3307/mydb1 mydb2 mysql://user:password@127.0.0.1:3307/mydb2 ] ;use a db (if not open will open it automatically): .db/use 'mydb1 | 5-Aug-08 6:18 |
| 1006 | Dockimbel | Version 1.2.1 re-released. There was a small error in the 'name-fields function preventing it from working. Thanks to Will for reporting it. | 14-Jul-08 12:29 |
| 1005 | Dockimbel | For a long time, I was reluctant to change the date zero behaviour (error throwing), because this "feature" of MySQL look, to me, like very bad design. But recently, I hit the problem too when I inserted badly formed dates in a table and wasn't able to read the records anymore with my driver. | 14-Jul-08 12:19 |
| 1004 | Will | Thank you Dock! | 14-Jul-08 2:40 |
| 1003 | Graham | Thanks for fixing the date zero error. | 13-Jul-08 19:46 |
| 1002 | Dockimbel | MySQL driver v1.2.1 released. See more at http://softinnov.org | 13-Jul-08 19:04 |
| 1001 | Graham | ok, worked it out insert db "select `middle name` from patientrecord" | 12-Jul-08 22:58 |
| 1000 | Graham | docs say \_ is a space >> insert db "select middle\_name from patientrecord" ** User Error: ERROR 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ve rsion for th... ** Near: insert db "select middle\_name from patientrecord" | 12-Jul-08 22:55 |
| 999 | Graham | Why would anyone put a space in a field name?? | 12-Jul-08 22:53 |
| 998 | Graham | ummm.. how do you do a select on a field where the field name has a space in it? | 12-Jul-08 22:50 |
| 997 | Graham | ok, this works round it insert db "select cast( birthdate as char) from patientrecord" | 12-Jul-08 22:42 |
| 996 | Graham | looks like some of the patient records have 0000-00-00 as the date of birth in them. | 12-Jul-08 22:39 |
| 995 | Graham | Getting this ... >> insert db "select * from patientrecord" == none >> result: copy db ** Script Error: Invalid argument: 0000-00-00 ** Where: convert-types ** Near: change at row 3 to >> | 12-Jul-08 22:36 |
| 994 | Graham | Never used mysql before .. and just downloaded Nenad's driver. | 12-Jul-08 22:36 |
| 993 | Reichart | Qtask might do this in the future... | 11-Jul-08 17:27 |
| 992 | Gabriele | Why wouldn't Qtask want to talk to Postgres too if they had chosen it? | 8-Jul-08 8:58 |
| 991 | james_nak | Thanks. | 7-Jul-08 22:58 |
| 990 | Will | James, thanks for your interest, I' ll upload it in a couple days 8) | 7-Jul-08 22:28 |
| 989 | Graham | With two open source databases to choose from of approximately similar functionality and stability, it is hard to understand why one would choose the one that has the restrictive license ... I can only imagine it is a mind share thing. | 7-Jul-08 21:19 |
| 988 | Maarten | I agree, your viewpoint wasn't economics.... | 7-Jul-08 20:58 |
| 987 | Graham | because of a limited viewpoint | 7-Jul-08 20:49 |
| 986 | Maarten | Why is the world flat? | 7-Jul-08 17:23 |
| 985 | Graham | Why didn't qtask use postgresql instead?? | 7-Jul-08 9:36 |
| 984 | Gabriele | well, not all of qtask, but again i don't really know. i know they talked to mysql and all is fine. i'm not implying they paid or are paying money, since i don't know. my point is that Qtask has permission from MySQL to do what they do, while you may not if you were to use the same code. Is that more clear? | 7-Jul-08 9:35 |
| 983 | Graham | He's often mentioned that they are considering open sourcing qtask in which again the license was not needed! | 7-Jul-08 9:30 |
| 982 | Gabriele | i don't think you can buy it right now, and the focus has shifted to the SaaS model, but otherwise there are no major tech obstacles iirc. ask reichart for more details, i'm not really up to date on the marketing/sales stuff :) | 7-Jul-08 9:29 |
| 981 | Graham | Has that happened yet? | 7-Jul-08 9:26 |
| 980 | Gabriele | Qtask? no, it does, because you can also put qtask on your own server. | 7-Jul-08 9:21 |
| 979 | Graham | So, looks like you didn't need a license | 7-Jul-08 6:54 |
| 978 | BrianH | They took that clause out of the regular GPL3 during the review process, after many protested it. | 7-Jul-08 3:33 |
| 977 | BrianH | No, that's the Affero GPL. | 7-Jul-08 3:31 |
| 976 | Gabriele | graham, i'm not entirely sure, in principle the GPL2 is as you say, however i'm not sure if MySQL has a different interpretation here. iirc the GPL3 states that being a server for users is the same as releasing the software. | 6-Jul-08 10:03 |
| 975 | Graham | Gabriele, I thought you only needed a license if you are releasing your software .... | 5-Jul-08 22:35 |
| 974 | james_nak | Will, that would be sweet. | 3-Jul-08 23:43 |
| 973 | Will | I have a mysql wrapper that I use in production but haven't released because it need cleaning and docs, but if there is interest I could release for testing as is. id does things like: print .db/get/all/sort/debug [mailing/m mailingLog/ml] [ml.dc m.email ml.url] [{ml._mailing=m.id}] [m.email asc ml.dc desc] SELECT `ml`.`dc`,`m`.`email`,`ml`.`url` FROM `mailing` `m`,`mailingLog` `ml` WHERE ml._mailing=m.id ORDER BY `m`.`email`,`ml`.`dc` DESC print .db/set/debug 'mailing 12 reduce['active false] UPDATE `mailing` SET `active`=0 WHERE id=12.0 print .db/get/all/flat/debug '_node_tree [_node _media] [{_tree=? AND _issue=?} 5443 22] SELECT `_node`,`_media` FROM `_node_tree` WHERE _tree='5443' AND _issue='22' .. | 3-Jul-08 10:09 |
| 972 | Gabriele | about escaping, Nenad's driver has such functions already, so i don't see that as an advantage for the native driver. Qtask has a native driver too (for speed reason with large record sets), but remember that when you use the mysql c library either your app has to be GPL or you need a license from MySQL (Qtask has a license). | 3-Jul-08 9:39 |
| 971 | Pekr | Isn't REBOL fast enough for most operations in regards to MySQL? Wouldn't it be sufficient to write such escaping fun in REBOL? | 3-Jul-08 6:44 |
| 970 | Pekr | Guys, what do you think about Tim Johnson's ml remark? Could we help him somehow? ----------------------------------- I've been using mysql-protocol (Mysql Scheme) and cgi for many years now. I really like it, but I think that /command would bring some advantages, if it can directly access the "C" API for MySQL. Example: Using the mysql scheme on a tcp/ip connection, I have to code the escaping of special characters for insert and updates and code the unescaping of special characters for retrieval. Using the C API from other scripting languages, the mysql_real_escape_string() function handles the escaping _appropriate_ to the version, and queries are similarly unescaped. | 3-Jul-08 6:43 |
| 969 | Will | Please 8P | 2-Jul-08 14:18 |
| 968 | Maarten | Will: I'll have to ask Reichart. | 2-Jul-08 9:11 |
| 967 | Will | here is a short and concise presentation about sphinx http://www.scribd.com/doc/2670976/Sphinx-High-Performance-Full-Text-Search-for-MySQL-Presentation | 2-Jul-08 8:23 |
| 966 | Will | bad question, but it would be cool to program stored procedures in rebol | 2-Jul-08 2:22 |
| 965 | Will | would there be any advantage having rebol as an external language plugin compared to Dock sheme? http://forge.mysql.com/wiki/ProjectPage_External_Language_Stored_Procedures | 1-Jul-08 13:46 |
| 964 | Will | Maarten: that is great news! Do you plan on releasing it for the rest of us? | 1-Jul-08 13:45 |
| 963 | Maarten | (i.e. the search client protocol that can talk to Sphinx). You can also compile a client in mysql and then use sql for your queries. | 28-Jun-08 7:31 |
| 962 | Maarten | Will, I have, and for Qtask I have even implemented the search protocol in REBOL. It's fast. | 28-Jun-08 7:30 |
| 961 | james_nak | You rock Doc. Thanks. That was an answer several years in the making! | 27-Jun-08 23:43 |
| 960 | Dockimbel | Yes if the server is just restarted, no problem, the driver will reconnect. | 27-Jun-08 19:36 |
| 959 | Will | ok but your driver should reconnect automagically 8-) | 27-Jun-08 19:35 |
| 958 | Dockimbel | you can also use a simple : port: attempt [ open mysql://... ] | 27-Jun-08 19:34 |
| 957 | Dockimbel | mysql-alive?: func [/host ip /port n /local p][ either attempt [ p: open/direct/no-wait join tcp:// [ either host [ip][127.0.0.1] #":" either port [n][3306] ] ][ close p yes ][ no ] ] | 27-Jun-08 19:31 |