hello, planning build aquarium controller using pi 3.
unsure programming language wisest choice, because windows (c#/asp.net/sql server etc) developer trade.
here's i'm looking do.
have main application (the controller, not in mvc sense meaning program controls aquarium) controls relay board on serial port based on conditions. expensive timer, want iteratively develop being able accept input sensors (uart or i2c etc) , use parameters well. i've read serial usb adapters work quite shouldn't problem add more 1 serial connection.
want build separate web app runs on pi, allow web-based gui view , alter settings , parameters used in switching logic, charting/viewing logged data.
therefore need language controller allows communication on serial port available library read , write local sql database.
web app available language/framework sufficient long supports database connection. familiar c# i'm thinking perhaps java , web framework work.
controller would, once per minute, fetch values database, read available sensors, perform simple logical operations based on values (e.g. time between 8am , 6pm, sensor 1 value above 6.6), change state of 1 or more relays if necessary, , log data sensors action taken.
have no problems database design or programming itself, i'm part.
i'm unsure of "stack" @ first.
database have multi-user web app , controller can interact simultaneously.
controller program doesn't need gui, need figure out sort of logging method debugging. don't think i'll need api long can access database via web app.
ideas? pi work? have similar projects far general programming (could long it's running web app , logging sql data sensors).
forward thoughts. thanks!
unsure programming language wisest choice, because windows (c#/asp.net/sql server etc) developer trade.
here's i'm looking do.
have main application (the controller, not in mvc sense meaning program controls aquarium) controls relay board on serial port based on conditions. expensive timer, want iteratively develop being able accept input sensors (uart or i2c etc) , use parameters well. i've read serial usb adapters work quite shouldn't problem add more 1 serial connection.
want build separate web app runs on pi, allow web-based gui view , alter settings , parameters used in switching logic, charting/viewing logged data.
therefore need language controller allows communication on serial port available library read , write local sql database.
web app available language/framework sufficient long supports database connection. familiar c# i'm thinking perhaps java , web framework work.
controller would, once per minute, fetch values database, read available sensors, perform simple logical operations based on values (e.g. time between 8am , 6pm, sensor 1 value above 6.6), change state of 1 or more relays if necessary, , log data sensors action taken.
have no problems database design or programming itself, i'm part.
i'm unsure of "stack" @ first.
database have multi-user web app , controller can interact simultaneously.
controller program doesn't need gui, need figure out sort of logging method debugging. don't think i'll need api long can access database via web app.
ideas? pi work? have similar projects far general programming (could long it's running web app , logging sql data sensors).
forward thoughts. thanks!
not same, wrote similar system control ventilation of cellar according measured temperature , humidity values. differences: i'm not logging sql rrd (round robin database) , don't have web app - 'controller' generates graphics , value readings otherwise static webpage every time runs. in addition have written small gui app displays on small touchscreen on pi , allows controls.
i've written in python using tkinter gui part. 'controller' gets called cron every 3 minutes (that's how sensors update). far, i'd pi task.
i've written in python using tkinter gui part. 'controller' gets called cron every 3 minutes (that's how sensors update). far, i'd pi task.
raspberrypi
Comments
Post a Comment