For what it's worth, I have my own Python sql query abstraction that I find
infinitely useful.
I create/edit all action (if this then that) operations from a web interface
where I reference values using a database value notation that is then
interpreted by a sanitized Python eval. Pretty simple but powerful. Can send rf
messages, set db values for squirting into switch io, etc.
Sure, single point of failure, but stateful and historical (critical for PID),
which the importance of was already pointed out. I think it's important to have
stupid devices and one or a few smart nodes for databasing and bringing things
to a web interface. Computers are quite reliable these days. If you want the
thing to be networked, you'll need a single node to either get things out or
determine which of your redundant smart nodes have failed anyway. I guess you
could make this node a simple micro for no other purpose (or a hacked router),
but I find SBCs such as the Pi plenty reliable.
C
> On Feb 23, 2016, at 11:16 AM, Matthias Urlichs <matth...@urlichs.de> wrote:
>
> Arley Carter <arcart...@bellsouth.net> writes:
>
>> Have you looked at the work done by the OPC Consortium?
>
> Not yet.
>
> [three hours later] O … K … Skip ahead if you don't want to read me ranting.
>
> If you want something that's *way* overspecified (I do not want to implement
> a
> structured version of SQL queries – among other interesting things – nor do I
> see any need to do so) and impossible to implement without (a) access to the
> reference implementation and its test cases and (b) at least a man year for
> the basics (the Java server example is 430 lines -- more than 70(!) import
> statements, way too few comments, and a heap of empty handlers most people
> would find to be somewhat essential), be my guest.
>
> This eerily reminds me of the X.400 train wreck of the 1980s.
>
> In any case, this is the OWFS list. I can guarantee that nobody in their
> right
> mind would ever connect an 1820 temperature sensor to such a system.
>
>> They are rather
>> far down the track in the direction you are headed.
>
> They also want $3000 for access to their C source code. Redistribution is not
> permitted, sorry, so any open source implementation will have to be done from
> scratch.
>
>> Why replow fields and reinvent wheels?
>
> Look at how much FHEM or OpenHAB can do. Ultimately I would like to build
> [the
> foundation of] something that's as capable, but somewhat more reliable (no
> single point of failure) and accessible ("if X, do Y" should be three lines
> of
> debuggable Python/Perl/whatever, or three Node:Red clicks).
>
> In any case I am no re-inventing any wheels. The wheels are out there, I can
> learn how they're built, and decide to use them in a vehicle that is easier
> to
> driver than what's already out there and that'll stay on track if one of the
> wheels gets loose.
>
>> Site24x7 APM Insight: [yeah, right]
>
> Adding commercials to emails is not a particularly good idea IMHO.
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Owfs-developers mailing list
> Owfs-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/owfs-developers
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Owfs-developers mailing list
Owfs-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/owfs-developers
