Hello Folks,
i've been a postgresql user for a lot of years, mainly using it on
common x86 hw; now for a personal project of mine i wish to know your
opinion on porting it on an embedded platform.
I'm currently using PostgreSQL in my home automation project (x86
platform) not for storing huge amount of data but for handling events
(with triggers and SP), use an high level programming language (PgSQL
with some custom functions), handling data and states (with integrity)
and so on.
So this is a small DB, not so much data on it, a combination of Cron,
Apache/PHP, PostgreSQL and some custom programming can handle it all, i
rely mostly on PgSQL for high level customization despite of its
original scope; strange application isn't it ?
PostgreSQL is the core system, it's informed on everything happens on
real environment and it does what it need to do.
I'm currently evaluating to port the whole platform into an embedded
system, i didn't chosen it yet but i'm looking for at something related
to Linksys APs hw ports, maybe some fancy hw like that. Cron and PHP
are portable and available, i can replace Apache with some light HTTPD,
but what about PostgreSQL ?
Is there anyone using it on small non x86 hw ? limited resources (let's
say you got a compressed linux kernel and software in less than 8-4Mb
ROM) and fully featured with triggers, SPs and so on ?
I know mostly of you are using it in a massive storage cluster or HA
system, but i greatly appreciated this DB even for its internals
(Object Oriented, Stored Procedures, SQL custom Programming, triggers,
integrity and so on), these are the main features i choose it instead
of MySQL and others
Can you please let me know your thoughts ?
thank you in advance for your reply
Ben