Hi Gavin, [apologies if msg reference chain mangled -- forgot to Cc list <:-( ] On 12/26/2012 12:45 PM, Gavin Flower wrote:
I have a close friend who is working on embedded software for a green house controller. He would love to use PostgreSQL, but they started using SQLite and pg does not appear to be suitable for embedded systems.
I'll second that! Though, to be fair, there is a wide range of applications that "embedded" can address. The resources that are available to one may be (several!) orders of magnitude different than others. I am currently using pgsql in an embedded system though suspect I may have to port everything over to another engine for deployment. There are too many assumptions made about the underlying hardware available for pgsql that are at odds with the goals of most embedded systems. (e.g., I need to be able to have the DB reside in "immutable" memory -- and the "writable" memory requirements carefully constrained) So, "cleverer" solutions end up prevailing. A pity as a single embedded system deployment probably puts more "seats" in play (e.g., easily 10,000 - 1,000,000 per design) than *years* of "natural growth" would, otherwise. --don -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
