Results 1 to 2 of 2
Thread: SQLite: Pros / Cons
Dec 11, 2008, 21:17 #1
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?
Dec 12, 2008, 14:34 #2
- 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.