World: r3wp

[New group to replace the old one that was somehow causing AltME 
resync problems]
Previous postings are here:
    http://www.rebol.org/aga-display-posts.r?post=r3wp439x1

Is there an R3 SQLite extension out there? I know Robert was working 
on one, but I don't know if it was for public release or how far 
he got with it.

he never released it .. I think he said he had to do some rewriting.

But there is an ODBC extension .. can't you use that?

Possibly. Thanks Graham.

Yes, we have one working.

I need to re-factor the code a bit as we have a commercial extension 
that is currently included in the main source-code. So I need to 
seperate these, to release the public part.

Extension is working without any problems so far.

Excellent. Thanks Robert. I may bother you more about it soon. ;-)

Yes, please :-). My todo-list is always getting longer faster than 
I can get rid of it.

hm .. it seems SQLite doesn't support prepared statements for date 
modifyers

example: http://paste.factorcode.org/paste?id=2318It looks now 
it's REBOL (binding) issue (although doesn't seem logycal to me). 
I tried in python and someone tried in C and it did work.

The problems happens where it gets converted back to rebol values. 
If I use /direct it works

Note that:

	SQL [ {select date(?)} now]

works.

It works for now with sql/direct (which I normally use anyway). I 
noticed error when I needed to do this:
SQL [ "select datetime("now", ?)" "-3 hour" ]

I haven't tried [ "-3:00:00 ]

(without the ")

Using the SQLite driver from Ashley, connect %any-folder/sqlite.db 
does not work, whereas connect %/c/any-folder/sqlite.db or (in any-folder) 
connect %sqlite.db works. I could swear that the first one with relative 
path worked until yesterday :-)

I would be very grateful if anyone can give me a hint what's going 
wrong here. Thanks.

And is the former path accessible under rebol?

It should work just fine Awi. Are you sure your current path didn't 
change before trying to access the relative path?

I just tried it again, still the same
>> connect %djangodb/gis.db
** User Error: SQLite out of memory
** Near: make error! reform ["SQLite" error]
>> exists? %djangodb/gis.db
== true
>> cd djangodb

== %/c/Users/awi/Documents/Biz/SMS Reservation system/VehiLocGIS/djangodb/
>> connect %gis.db
== 33491104
>> disconnect
== none
>> cd ..

== %/c/Users/awi/Documents/Biz/SMS Reservation system/VehiLocGIS/

>> connect %/c/Users/awi/Documents/Biz/SMS Reservation system/VehiLocGIS/djangodb/gis.db
== 33491104
>> disconnect
== none

Awi, do you have the same version of dll/so and sqlite db?

>> connect/create %djangodb/test.db
** User Error: SQLite out of memory
** Near: make error! reform ["SQLite" error]
>> connect/create %test.db
== 7473312
>> disconnect
== none

Creating new db in subfolder also does not work

Yes, the db and the dll should be in the same version since the db 
was created using the same dll.

Did you happen to update SQLite?

Is the database very large?

Sorry for the late reply. The answer is no for both.

Recent SQLite versions use memory differently, but it isn't that, 
then