Ion Silvestru <[EMAIL PROTECTED]> wrote: > Hi, > > Is there a possibility to open a SQLite database read-only so that > database file will not be locked? This request is for updating > reasons, to overwrite the database file with a newer version, while > users have opened the database only for read. >
No, not really. If a database were opened read-only without a read-lock and it was trying to read while another database was writing, then the reader might see partially updated information, which is incorrect. That said, you can play games with the user-defined I/O layer to make it do anything you want. But on your own head be it..... -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------