SQLite can be used in following conditions
* Embedded applications : Does not require expansion like mobile applications or games
* Disk assess replacement : Application that require to write or read files to disk directly
* Testing : When testing business application logic
When not to use SQLite
* Multi-user applications : Where multiple client needs to access and use same database
* Applications requiring high write volumes : It enables you to use only one single write operation to take place at any given time