Re: [sqlite] best way to use sqlite as application's format

2012-02-23 Thread Gour
On Wed, 22 Feb 2012 20:52:54 -0500 Richard Hipp wrote: > Here is a write-up > from 2005 in which I describe a technique I used to implement > unlimited-depth undo/redo in a application that used SQLite as its > file format. There

Re: [sqlite] best way to use sqlite as application's format

2012-02-23 Thread Gour
On Wed, 22 Feb 2012 23:04:55 +0100 Petite Abeille wrote: > Are you actually trying to solve a concrete problem? Yes. > Or creating one out of thin air instead? No. > http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+Computer+Science.aspx Thank you. It

Re: [sqlite] best way to use sqlite as application's format

2012-02-23 Thread Gour
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 22 Feb 2012 17:10:39 -0800 Roger Binns wrote: > Just start using SQLite and see what happens. Good one. We'll try to (artificially) populate our sqlite database and then play with it. > You

Re: [sqlite] best way to use sqlite as application's format

2012-02-22 Thread Richard Hipp
On Wed, Feb 22, 2012 at 8:10 PM, Roger Binns wrote: > > The second is to ensure you have an undo mechanism, as this will affect > your schema and triggers. One thing I worked on didn't even have a 'save' > menu item. Every action you did resulted in a database change.

Re: [sqlite] best way to use sqlite as application's format

2012-02-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/02/12 13:35, Gour wrote: > d) something else? Just start using SQLite and see what happens. You don't have to use an ORM. And if you don't use one, you'll eventually see if you need one and what functionality it needs. I do have two other

Re: [sqlite] best way to use sqlite as application's format

2012-02-22 Thread Petite Abeille
On Feb 22, 2012, at 10:35 PM, Gour wrote: > Otoh, here we come to the well-known "object-relational impedance > mismatch" problem and wonder how to resolve it, iow.: Are you actually trying to solve a concrete problem? Or creating one out of thin air instead?