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 a file database. There is no running process or anything, it's literally just a regular file on your disk. MySQL is a full fledged database server, something that has to be run independently. SQLite is best suited for when applications need a small database to store settings or data.
You could do it with SQLite, but SQLite isn't really meant to be used concurrently (ie, by multiple users accessing it at once). So unless it's some dinky internal site that will only be accessed by a couple people, I wouldn't recommend it.
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.
Technically, you can use WordPress with SQLite. If you don’t have much traffic it is an option.
It's trivially easy to install a copy of MySQL and a webserver onto any machine, so while you could use SQLite, it would be a lot more difficult than simply grabbing a copy of MySql and installing it.
WordPress does not support anything but MySQL out-of-the-box, but it is possible for a database-plugin to replace that support with just about anything, if it really wanted to.
If you want to test this locally or something, just grab a copy of XAMPP and install WordPress on that. Easy.