SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Wolf_22's Avatar
    Join Date
    Jul 2005
    Posts
    1,700
    Mentioned
    0 Post(s)
    Tagged
    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
    Location
    Washington, DC
    Posts
    10,576
    Mentioned
    4 Post(s)
    Tagged
    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.


Bookmarks

Posting Permissions

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