i'm just curious. so i ask this particular question about SQLite. I haven't use this type of database extensively. but care to explain what is the basic different between SQLite and Mysql ?
The reason behind all of this is i just want to know whether it possible to use it to store wordpress data and act as a database ?
SQLite is an in-process or desktop class database. MySQL is a server class database. I'm a little notorious here for promoting server-class engines over desktop or in-process -class engines for web sites, because no matter how well you do at your in-process database engine you are going to have concurrency problems when a whole bunch of people try to access your site at the same time.
However, I think in this case you might do just fine with SQLite, as long as you are very careful about what plug-ins you install. The reason is that you're likely only going to have one person updating your wordpress blog, and probably in-frequently at that. So as long as you're careful about using plug-ins that don't get to write to the database for every visitor, sqlite should do fine.