filling a db on CD, what happens?

Kay C Lan lan.kc.macmail at gmail.com
Fri Feb 8 22:04:56 CST 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
> do
> 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
required.

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.

Thanks



More information about the use-livecode mailing list