Hi Sky,
The read-only mode for opening the database is simply you telling the sqlite engine that you do not intend to write to this database
and so it doesn't try to acquire write-locks on it during the life of that connection, and your connection cannot make changes to it
in any way (even if the user maybe invokes a query that tries to change data). It is a safety measure and sometimes a speed increase
or concurrency helping method, but this is not preventing anyone else or any other program or access method from writing to the
database, it is only a restriction for a single connection under your control.
Access to SQLite DBs depend on exactly the access to the file, whomever can access the file can read/alter/delete it. To lock a db
so that nobody else can alter it you have to encrypt the file itself for which one official solution is the SEE extension which
works very well, as Kees mentioned in a previous post.
SQLite does not do Data/User-level access control on top of a normal connection as others stated, nor pretends to. PostGRES/MySQL
etc. are viable alternatives for this, especially since you mention copying the file between server/client, might a client-server
based engine would work better for you?
A brilliant easy-to-install MySQL installation (bundled with an PHP+Apache web service which you can ignore) that almost mimics a
stand-alone DB engine and can be used for all of Linux/WIndows/Mac can be found from the friends of Apache folks, called XAMPP.
https://www.apachefriends.org/index.html
On 2014/07/17 14:17, Sky Meena wrote:
thank you.. how can i use sqlite_db_readonly function..
On Thu, Jul 17, 2014 at 5:40 PM, Sky Meena <sky.me...@gmail.com> wrote:
i will explain.. i created a sqlite db.. now i should tranfer it also
transfered.. while opening a db it should ask password.. for that while
creating db i should enable some password or read only mode..
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
