I will be using arduino as controllers in each room and communicating with each controller via UDP though the wired network.
I plan to use a oracle database and APEX (web service part of oracle) as the main engine for deciding what goes on when.
(Im using Oracle and APEX because I develop in them at work, so it is easy)
until....
Oracle doesnt communicate via UDP, so I need a processing tool that can query Oracle and send commands out to the drone style arduino devices distrubuted though out the house.... figured Processing seems like a logical step as its simular language to arduino (that I had to learn anyway).
Its been a quite a fun project so far.... I have got the arduino device receiving UDP packets and turning things on and off.
But I need help with the Oracle intergration stuff..... any ideas? is there anyone who can help?