Re: Windows Installation User account - Correct database for us

From: Wolfgang Keller <feliphil(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Windows Installation User account - Correct database for us
Date: 2014-07-17 14:30:40
Message-ID: 20140717163040.148fbd4e7fc5bdf7be055a79@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> H2 or SQLite can be very reasonable choices for in-app embedded
> databases, so long as your app can operate within their constraints on
> concurrency and data size.

Firefox uses SQLite and the places.sqlite database is notorious for
getting corrupted every five minutes. Libreoffice/Openoffice Base uses
H2 and there are plenty of reports by users about data losses due to
database corruption.

Personally I'd *never* use an "embedded" database for anything.

Sincerely,

Wolfgang

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prabhjot Sheena 2014-07-17 17:44:32 Checkpoint_segments optimal value
Previous Message Adrian Klaver 2014-07-17 14:10:11 Re: Why pg_toast table not get auto vacuumed?