Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

brandon6684

Guest
Original poster
Dec 30, 2002
538
0
Right now my favored web development is with PHP and MySQL, but I've thought about going a bit more light weight on my web servers. I've already switched from Apache to lighttpd, but now I'd like to go after the database with a lightweight solution, and SQLite looks like a nice little database.

Does anyone here have any experiance with SQLite in this area?

Where there any "must have" features that were missing compared to MySQL?

Did is scale okay(at least as well as MySQL)?
 
It can be done, but the documentation/help on the internet is not that good, and much of it is outdated. PHP support for SQLite3 is through PDO and is somewhat buggy. The tools used to manage it are also not as mature as e.g. phpMyAdmin. However, I do recall reading somewhere that it is a very fast db.

http://www.sqlite.org/omitted.html
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.