Can sqlite be used for a low traffic web application?

Question

I always thought and used SQLite as a client-side storage tool.

But I am developing a low traffic web application with simple storage and query requirements.

Is it reasonable (and / or generally common) to use SQLite on a web application server, where I used to use MySQL?

Thanks in advance for any thoughts on this.

UPDATE:

Thanks for answers.

1) Yes, it will remain low traffic because it is intended for a small, predefined group of users.

2) I would use ORM and no special SQLite functions, so switching to MySQL, as you say, should not be a big problem if it became necessary.

3) @stealthyninja: Could you say that 100 attachments / updates per day will qualify as very rare?

Answer 1

@ mp11: read The appropriate use for SQLite , this should give you an idea of ​​whether SQLite is suitable for your project ... but yes, if you are going to embed / update very rarely, then SQLite can be a lot faster to query.