From: | Darren Duncan <darren(at)darrenduncan(dot)net> |
---|---|
To: | PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: Postgres replaces SQLite as well as it replaces Oracle? |
Date: | 2017-02-25 05:07:04 |
Message-ID: | c3ec6e4a-4739-27a5-b7fc-a2c3f92d1d17@darrenduncan.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2017-02-25 18:40:40 | Re: Postgres replaces SQLite as well as it replaces Oracle? |
Previous Message | Joshua Kramer | 2017-02-25 01:12:54 | Postgres replaces SQLite as well as it replaces Oracle? |