MySQL vs SQLite For Production Website?

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Mark Phillips
Date:  
To: Main PLUG discussion list
Subject: MySQL vs SQLite For Production Website?
I am working on a small project using the django framework. I have a choice
of backends - mysql, postgress, sqlite. The web site will have low traffic,
and 90% of the assets are scanned images (pdf, tiff, jpeg), so they will be
stored in a file system and not in the database. The framework/database are
for tags and search terms (ocr from pdfs) and user login credentials.

I am inclined to use the sqlite backend so the site uses fewer resources
and to make backups easier. However, I have never used sqlite in a
production environment. According to the sqlite website, it is production
ready.

Would you recommend sqlite for a production website?

Thanks,

Mark
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss