SQLite as a MySQL replacement with PHP?

Discussion in 'Web Design and Development' started by brandon6684, Jun 21, 2007.

  1. brandon6684 Guest

    Joined:
    Dec 30, 2002
    #1
    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)?
     
  2. Super Macho Man macrumors 6502a

    Super Macho Man

    Joined:
    Jul 24, 2006
    Location:
    Hollywood, CA
    #2
    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
     

Share This Page