filling a db on CD, what happens?
Kay C Lan
lan.kc.macmail at gmail.com
Fri Feb 8 23:04:56 EST 2008
On Feb 7, 2008 2:02 PM, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> In general case Databases (w.g. SqlLite or Valentina) will not allow you
> this on CD. You will get exception/error on the first attempt to do
> INSERT/UPDATE/DELETE ... CREATE/ALTER TABLE
But what about a case where ALL you want to do is SELECT.
Lets say you have a 'Tour of the Museum of Fine Art', a DB with a couple of
entries for title,artist,year,description,style,image (image being a high
resolution .jpg). Because of the images the whole lot comes to a couple of
GBs so you put it on a DVD. The intention is only to 'view'. Is it possible
to save the User the need to clog their HD by leaving the DB on DVD.
What about a Hybrid.
If the above is possible, then what about an approach where your Rev front
end is stored on the Users HD and creates a small DB. The small DB has two
entries, notes and a pointer to the read only DVD DB. In this way a user
could enter their own notes about each painting in the museum, these notes
would be written to the small DB and be remembered, and modifiable as
NOTE. I appreciate that this is not the 'normal/fastest' way you'd handle
this in a DB. I'm simply interested in whether this will work.
More information about the Use-livecode