SQLite Database Question

[zlloyd0 0]

I have a database that I have created using SQLite on my Mac, and I need to add a  constraint of sorts that makes it so that only someone who logs in can alter the data, but for everyone else it is read only....

Can someone PLEASE provide me an example (including actual code used) on how this could be accomplished??

Thanks in advance!!

Park_Files.db

[jchd 1,822]

Albeit your question isn't AutoIt-related, here's how I see it.

Place the DB in a directory and give RW access to only one user, others users just being granted Read access. Yet there is one (big) catch: the RO users can't have temporary files created. Note that seemingly RO queries may have to create temporary tables.

A client-server DB engine would probably be a better choice.

[Joboy2k 8]

i use a virtual box on my Mac that has windows 10 installed. i use SSH from the windows 10 into the Macs IP to access my SQL database via autoit. If you set up users on the SSH and mess around with their permissions im sure you could get it to work but never needed to make it readonly for certain people so let us know how you do it if you get it working.

[Skysnake 94]

SQLite is primarily intended as an embedded or single user database.  I am with @jchd on this.  Go for a relational database. 

If you DO manage to find a solution I would very much like to hear about it.

Skysnake

[jchd 1,822]

SQLite is natively "multi-user" (as in multi-thread and/or multi-process) and is a pretty good relational DBMS. What it isn't naively is a client-server engine and its use over a network is not recommended.

[Skysnake 94]

Dear @jchd thank you for clarifying that.  That was what I intended to say, in line with the topic under discussion.