CODEWITHSUNDEEP
phppdosqlite
stalxed
stalxed

Reputation: 1263

Option readonly of SQLite in PDO

I know that the readonly option does not exist in the PDO.

I have a database, accessible only in read mode(chmod for file read only). I need only perform SELECT and SELECT COUNT queries.

Is it safe to such use?

I am afraid that SQLite at some point want to write some logs, logs, etc. And then I'll have to catch this type of situation. It is not easy in a large application.

Or performing SELECT and SELECT COUNT queries excluded any attempt to change the file?

Upvotes: 0

Views: 768

Answers (1)

alariva
alariva

Reputation: 2139

If you have readonly access to your DB, those types of queries (select) wont bring you trouble, unless you try to insert, update, delete, or alter the schema.

Just consider that sqlite fits specially well for small projects rather than large ones. For large projects sqlite is considered not a good practice.

Upvotes: 1

Related Questions