MySQL vs SQLite For Production Website?

[Brian Cluff]

If your database is going to be fairly small it might be OK, but in my 
experience sqlite ground my website to a halt once the database had a 
few megs of data in it.  It really didn't take much data at all to 
become ridiculously slow.

Brian Cluff

On 05/27/2015 11:31 AM, Mark Phillips wrote:
> 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 - PLUG-discuss at lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>