Re: [sqlite] Triggers to enforce table permissions

2013-12-06 Thread Joshua Grauman
Nevermind, I found the recursive_triggers PRAGMA... Thanks! Josh Hello all, I'm trying to create simple permissions for a table to prevent unwanted modification of certain table rows. I'm brand new to Triggers, but I almost have what I want working. Imagine I have a table t1 with some data,

[sqlite] Triggers to enforce table permissions

2013-12-06 Thread Joshua Grauman
Hello all, I'm trying to create simple permissions for a table to prevent unwanted modification of certain table rows. I'm brand new to Triggers, but I almost have what I want working. Imagine I have a table t1 with some data, and a permission integer. I have two triggers that prevent modifica

Re: [sqlite] Concrete example of corruption

2013-12-06 Thread Yuriy Kaminskiy
Richard Hipp wrote: > Please try the changes in the branch at > http://www.sqlite.org/src/info/8759a8e4d8 and let me know if they > adequately cover your concerns. Let's suppose user just did cp -b somewhere/else/db opened.db There *are* still file named opened.db, but it points to *different* f

Re: [sqlite] Concrete example of corruption

2013-12-06 Thread Richard Hipp
Please try the changes in the branch at http://www.sqlite.org/src/info/8759a8e4d8 and let me know if they adequately cover your concerns. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Concrete example of corruption

2013-12-06 Thread L. Wood
> Simon Slavin wrote: > If you can't trust your users not to > move data files out of place I was not talking about data files but regular documents (package folders). Moving regular documents has nothing to do with trust. It's a fact of everyday reality. > Stephen Chrzanowski wrote: > Even wi

Re: [sqlite] Concrete example of corruption

2013-12-06 Thread Tim Streater
On 06 Dec 2013 at 03:31, Stephen Chrzanowski wrote: > On a personal note, I still cannot fathom why anyone would WANT to do file > management while working on an active document. Moving a document while > its being worked on contradicts everything I understand. I find being *unable* to do tha

[sqlite] Functions affecting table structure ?

2013-12-06 Thread Raheel Gupta
Hi, I am trying to add some additional data with the table structure stored in SQLite. Everything seems to be working fine but when I do an alter query it seems to drop the table. I have made changes in the following functions to handle the addition of the data: sqlite3AlterFinishAddColumn() , sq

Re: [sqlite] Concrete example of corruption

2013-12-06 Thread Yuriy Kaminskiy
Warren Young wrote: > On 12/5/2013 20:31, Stephen Chrzanowski wrote: [...] >> File handling is NOT SQLites responsibility > > I'm not sure about that. SQLite, at least at one time, was billed as a > competitor for fopen() rather than for Oracle. But fopen(3) have no locking *at all*. And lower-l