previosly mentioned LMDB was based on work of Martin Hedenfalk http://www.bzero.se/ldapd/ original implementation needs be touched to be complilable under Windows, but it is worth to look at it. Append only DB
Endo
Cannot connect to MySQL 5x with Rebol/Command's official MySQL driver? I get "Client does not support authentication protocol" even I use "update user set Password=OLD_PASSWORD('password') WHERE User='username'; " which should work. So the only way is to use http://softinnov.org/tmp/mysql-protocol-41.r ?
DocKimbel
IIRC, the statically linked libmysql in the SDK is a 3.x version. You can use that MySQL driver version or you can write a binding to a newer libmysql client library...as you wish. ;-)
GiuseppeC
Hi, is this the place to talk about R3 ODBC ?
Gregg
Seems as good as any to me.
sqlab
Is there a newer version than 1.2.1 of the mysql-driver of Softinnov available? I tried to connect to MariaDB and got an error message >> read mysql://localhost/mysql/test ** User Error: ERROR 1251 : Client does not support authentication protocol requested by server; consider upgrading MariaDB client ** Near: read mysql://localhost/mysql/test
the second one I really don't remember what it does.. :
- either find port/locals/capabilities 'protocol-41 [ - insert-query port data - ][ + ; either find port/locals/capabilities 'protocol-41 [ + ; insert-query port data + ; ][ insert-all-queries port data - ] + ; ]
Endo
Is there any way to insert a NULL using parametrized query?
insert mysql "create temporary table t (a int)" insert mysql "insert into t values (NULL)" ; this works insert mysql ["insert into t values (?)" none] ; this doesn't ** Script Error: ODBC error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
GiuseppeC
Hi Doc, is the mysql protocol R3 compatible ?
Endo
Protocol source is very clear, it looks like it might compatible with R3 or at least it can be with a little effort. I'll get his to-sql function from the protocol source and use it to generate SQL of my parametrized query.
DocKimbel
@Giuseppe I never tried, usually low-level port-related code is AFAIK, not compatible between Rebol2 and 3.
That said, I guess it could be ported without much efforts by someone knowledgeable in R3's port coding.
I need help with %mysql-protocol.r v1.3.0. I use it nicely with a mysql 5.5.49. But I tried to use it with a mysql 5.5.53 server (on a different machine), and I get an error at the opening of the port! :