SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Wolf_22's Avatar
    Join Date
    Jul 2005
    0 Post(s)
    0 Thread(s)

    Question SQLite: Pros / Cons

    I have an image gallery script that I'm working on and plan on implementing some interactivity with it. Nothing major, just some rating system stuff of sorts.

    So instead of going into a full-bore approach with it and using MySQL, I would think that SQLite would be a better alternative (at least, for now, anyway).

    I would like to know your thoughts on this. Pros? Cons?

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Washington, DC
    4 Post(s)
    0 Thread(s)
    Pros: lite, simple, easy to package
    Cons: less of a real database engine than INNODB. Lack of referential integrity. Beware concurrency issues. Beware scalability issues. Dragons.

    Now, if you have a proper database abstraction going on in the app, you should be able to build it in SQLite and make MySql an option with relative ease.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts