Re: MySQL vs SQLite For Production Website?

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@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>

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