World: r3wp
[!RebDB] REBOL Pseudo-Relational Database
older | first |
onetom 16-Apr-2011 [266x3] | and now i get |
SQL> select * asd asd has an open log file | |
commit asd doesn't help | |
nve 7-Jun-2011 [269] | Is there a protocol version of RedDB ? In order to use it under Cheyenne with database enhancement. |
Ashley 8-Jun-2011 [270] | No, but it wouldn't be that hard to write a protocol wrapper replacement for the SQL function. |
Dockimbel 8-Jun-2011 [271] | Cheyenne is able to run RSP and CGI scripts concurrently on several processes at the same time. AFAIK, RebDB does not do any locking on write access, it would be unsafe to use in the general case with Cheyenne. SQLite would be more resilient, but keep in mind that as it is locking the whole DB on each write access, it is not scalable. |
ddharing 8-Jun-2011 [272] | The new(er) WAL (Write Ahead Logging) transaction mode reduces locking and increases concurrency -- http://sqlite.org/wal.html. |
nve 11-Jun-2011 [273x2] | Seems that the SQL interpreter (SQL.r) do not support multi lines : |
SQL> create table c2 [ ** Syntax Error: Missing ] at end-of-script ** Near: (line 1) create table c2 [ | |
Ashley 15-Jun-2011 [275:last] | Correct, it's just an 'ask loop (hence no semi-colon for command termination). |
older | first |