*** 232,237 **** --- 232,240 ---- *:SELECT ... FOR UPDATE OF ... is not supported. This is understandable considering the mechanics of SQLite in that row locking is redundant as the entire database is locked when updating any bit of it. However, it would be good if a future version of SQLite supports it for SQL interchageability reasons if nothing else. The only functionality required is to ensure a "RESERVED" lock is placed on the database if not already there. + *:DELETE from table ORDER BY column LIMIT x,y is not supported. I worked around + it by using a second query and deleting, eg: SELECT timestamp from table LIMIT x,1; DELETE from table where timestamp < ..... + =========== REMARK ===========
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|