SQLite as a MySQL replacement with PHP?

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

Most Liked Posts
  1. brandon6684, Jun 21, 2007

    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)?
     
    share
    + Quote Reply
  2. Super Macho Man, Jun 22, 2007

    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
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page