I'm familiar with the process of setting up Postgresql. And I'm also thinking of using SQLite for some of my websites for I don't need that much functionality that Postgresql offers. And I also want to avoid having a database demond working all the time in the background even when there's no need -- no requests to my database.
I think that SQLite will suit me better on some of my small websites. My questions are:
1) Is it worth it to use on relatively small websites?
2) On such websites, does it consume less resources of a server?
3) When in general is it recommended or ok to use SQLite in regards to websites or web services?