Which one should I use? I'm currently using PDO_SQLITE. My site is thomasmottl.com, in case you were wondering. I'm currently working on adding more features to my CMS before I add more posts.
This question isn't really related to PDO. It's SQLite VS MySQL. Google that and you'll find lots of answers. But generally, for a CMS, I suppose you should pick MySQL.