Can SQLite be used when a program was written with mySQL?

i'm copying a series of examples from Robin Nixon's Learning PHP, javascript and MySql

http://www.amazon.com/Learning-MySQL-JavaScript-Step-Step/dp/0596157134/ref=pd_sim_b_3

which ultimatly unite to form a basic social networking site. All of these examples are written 开发者_StackOverflow社区in php, javscript and mySql. At some point I would like to use SQLite instead of mySql. My question is, will i be able to finish the site in mysql and then simply began using SQLite, or will other steps be be needed, such as rewriting the whole thing?

First, unless you are using an abstraction layer, you will need to switch to a different API for using the completely different database.

Next, you are probably using some MySQL specific functions that will need to be worked around.

Finally, work around anything not implemented in SQLite.

I'd really be curious to know why you want want to do this anyway. Do you understand that SQLite databases really aren't meant for a lot of concurrent connections, and aren't generally considered appropriate for websites of any decently sized scale?