I am looking to migrate my project data from MySQL to SQLite because I want it more portable and so on and so forth.

I however want some inside information on SQLite and how it runs. I have been looking at some of the SQLite documentation and I must be honest I have been lazy about it.

At the moment I would like to know about how much data I can actually store in an SQLite database, and also how it handles different datatypes and finally does it have any built-in injection safeguards?

Also, I would like to know which version to use as a PHP/Python developer. I understand you need to access SQLite3 through something called PDO. In short is there an easy to follow tutorial or document on PHP and SQLite like this one