Re: [sqlite] Atomic DELETE index optimisation?

2017-12-19 Thread Subsk79
On Dec 17, 2017, at 3:53 PM, Dinu Marina Is there any way to fix/improve this in userland? I think the thread already has a viable solution but still if userland fix is an option: would a soft-delete based design work for you? https://dba.stackexchange.com/questions/125431/hard-delete-vs-soft

Re: [sqlite] Most wanted features of SQLite ?

2009-09-18 Thread Subsk79
StepSqlite brings powerful Stored Procedure support with full power of PL/SQL syntax to SQLite. It is a 'compiler' as opposed to a mere 'wrapper' so it generates much more efficient code than any wrapper could ever achieve - for instance, it pre-compiles all SQL in your code right when the