r3wp [groups: 83 posts: 189283]
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r3wp

[SQLite] C library embeddable DB .

Janko
8-Jul-2011
[15x2]
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 ")
Awi
24-Aug-2011
[17x2]
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.
GrahamC
24-Aug-2011
[19]
And is the former path accessible under rebol?
Gregg
24-Aug-2011
[20]
It should work just fine Awi. Are you sure your current path didn't 
change before trying to access the relative path?
Awi
6-Sep-2011
[21]
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
Janko
8-Sep-2011
[22]
Awi, do you have the same version of dll/so and sqlite db?
Awi
9-Sep-2011
[23x3]
>> 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.
Kaj
9-Sep-2011
[26x2]
Did you happen to update SQLite?
Is the database very large?
Awi
3-Oct-2011
[28]
Sorry for the late reply. The answer is no for both.
Kaj
3-Oct-2011
[29:last]
Recent SQLite versions use memory differently, but it isn't that, 
then