World: r3wp
[SQLite] C library embeddable DB .
older | first |
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 |
older | first |