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
