Re: [pgsql-advocacy] Postgres replaces SQLite as well as it replacesOracle?

Well there are a variety of definitions of "embedded".  You could probably run
SQLite on a device that has a total of 1MB of RAM or similar. -- Darren Duncan

On 2017-02-24 5:12 PM, Joshua Kramer wrote:
> Hello,
>
> Has anyone done articles or advocacy for Postgres in embedded applications?
>
> I am fooling around with Home Assistant on a Raspberry Pi.  This is a
> Python 3 app that is normally backed by SQLite.  But it has issues
> because often times more than one process wants to write to the
> database, and SQLite doesn't do that well.  I found a handy guide on
> replacing SQLite with PG in this application:
>
> https://community.home-assistant.io/t/howto-postgresql-on-raspberry-pi-all-in-one-installer/5527/21
>
> Two things I noticed right off the bat.  The UI of HomeAssistant is
> MUCH faster using PG than it is using SQLite.  We're talking 5 seconds
> for a page refresh vs half a second.  Second, Postgres is tiny!  The
> whole stack- OS, Postgres, HASS server- takes up a whopping 67 MB of
> RAM.
>
> It'll be interesting to see how these stats change as I leave the
> thing running for months on end.
>
> Cheers!
> -JK