Re: MySQL vs SQLite For Production Website?

I know very little about PostgreSQL so please forgive my ignorance. Your
last statement caught my attention. You said to choose MySQL or
PostgreSQL depending on use case and preferences. I can understand
preferences because I would choose MariaDB because of familiarity, but
what "use case" would you choose PostgreSQL over MySQL?



On 2015-05-27 14:53, Joseph Sinclair wrote:
> I have to agree with Brian. SQLite is not intended to replace a
> database, it's intended to replace a flat file. Even the
> documentation for SQLite emphasizes that it replaces 'fopen()', not
> MySQL.
> If you would be happy (from an admin perspective) keeping the entire
> data set in a single text file, then SQLite is probably a good choice
> (with better semantics!).
> If you expect to *ever* need a "real" relational database backend,
> then start with MySQL (alt. MariaDB) or PostgreSQL (depending on use
> case and preferences) and evaluate from there.
>
> On 05/27/2015 12:05 PM, Brian Cluff wrote:
>> 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