[kwlug-disc] Newbie... Playing with Linux etc...
Bob Jonkman
bjonkman at sobac.com
Mon Apr 19 22:51:02 EDT 2010
Sounds like the outline of a KWLUG presentation to complement Khalid's
presentation in May on MySQL.
Hint. Hint.
--Bob.
On Mon, 19 Apr 2010 at 22:27, Fernando Duran <liberosec at yahoo.ca> wrote
about Re: [kwlug-disc] Newbie... Playing with Linux etc...:
> --- On Mon, 4/19/10, Khalid Baheyeldin <kb at 2bits.com> wrote:
>
>
>
>> SQLite is not really an option for many real life situations, where you need concurrency (e.g. a web site that uses a content management system).
>>
>
> I disagree. Sqlite has a concurrency issue (locks) with _writes_ only, so most web sites (lots of reads, infrequent writes) can be good candidates for it. See for example http://www.sqlite.org/whentouse.html ("Websites" section) or http://www.appliedstacks.com/NewestFirst/SQLite .
>
> I have several web sites where I have migrated from Mysql to sqlite and I couldn't be happier: it's faster with less CPU and memory footprint. Plus I've seen too many mysql corruptions and data losses; I only use mysql if there is absolutely no other alternative and I don't know anybody with experience in both mysql and postgres that doesn't agree.
>
>
> Cheers,
>
> Fernando
>
>
>
>
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
>
More information about the kwlug-disc
mailing list