Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Roger Binns
[EMAIL PROTECTED] wrote: > In all of the desktop apps that I write, I omit the File->Save > option altogether. Incidentally, this is excellent from a usability point of view. It seems rather ludicrous in this day and age that users of other applications have to know the difference between persist

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread John Stanton
If you maintain a log of each transaction, perhaps in SQL or some similar form, then you can create the inverse of that to undo or run it again to redo. Each transaction can have its own registration ID. I should anticipate that you would use some form of circular buffer to make the process s

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Trevor Talbot
Ran wants the transaction journal to be a permanent transaction log, with the ability to explicitly run a rollback operation on it (after the transaction was committed). Unlimited undo support using only the transaction control statements. To answer the question, no, there's no support for that.

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Ran
I am not sure what that means. I am looking for undo feature the way it is implemented for example in a drawing application or in a word processor. When the user makes a mistake or change his mind, he can undo several steps and try again. On 11/19/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Ran
What exactly do you mean by "own log of each transaction"? As I explained, I have a complex database with many tables and triggers. It will not be simple to implement undo the way it is explained in the wiki, and I suspect it will cost much in performance (but maybe I am wrong here...). If journal

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Jay Sprenkle
On 11/19/06, Ran <[EMAIL PROTECTED]> wrote: I think I didn't explain my question well enough. I know all what you wrote about transactions. The undo functionality I am looking for is over _several_ transactions. Does nested transactions do what you want? --

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread John Stanton
Ran wrote: I think I didn't explain my question well enough. I know all what you wrote about transactions. The undo functionality I am looking for is over _several_ transactions. I just wonder if it is possible to twist sqlite to keep the journals created during transactions (so to store them

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Ran
I think I didn't explain my question well enough. I know all what you wrote about transactions. The undo functionality I am looking for is over _several_ transactions. I just wonder if it is possible to twist sqlite to keep the journals created during transactions (so to store them just before th

Re: [sqlite] Design of application using embedded database

2006-11-19 Thread Jay Sprenkle
On 11/18/06, Ran <[EMAIL PROTECTED]> wrote: The way the undo-redo is described in the wiki involves triggers to insert the information of the change in each table to other table which logs the changes. This will have a price in performance. It also complicates things when triggers are already use

Re: [sqlite] Design of application using embedded database

2006-11-18 Thread Ran
The way the undo-redo is described in the wiki involves triggers to insert the information of the change in each table to other table which logs the changes. This will have a price in performance. It also complicates things when triggers are already used for other things. So I wonder if journals

Re: [sqlite] Design of application using embedded database

2006-11-18 Thread claudio benghi
> > Upon loading a saved file into the application the database on filesystem is > > loaded into an ADO.Net DataSet. This is used by the application until the > user > > saves to disk again when all of the changes to the DataSet are saved back to > > the database on disk. > > > > In all of the des

Re: [sqlite] Design of application using embedded database

2006-11-18 Thread jon
[EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] wrote: > > Hi, > > I would like a bit of advice before starting to make changes to my > > application. > > > > I've written a program in C# for personnel departments and at present all of > > the data is stored in memory until the user saves and then i

Re: [sqlite] Design of application using embedded database

2006-11-17 Thread drh
[EMAIL PROTECTED] wrote: > Hi, > I would like a bit of advice before starting to make changes to my > application. > > I've written a program in C# for personnel departments and at present all of > the data is stored in memory until the user saves and then it is written to > disk as an XML file. >

[sqlite] Design of application using embedded database

2006-11-17 Thread jon
Hi, I would like a bit of advice before starting to make changes to my application. I've written a program in C# for personnel departments and at present all of the data is stored in memory until the user saves and then it is written to disk as an XML file. I'd like to switch to an embedded SQLit