Datawarehouse for internet of things?

Not sure if this is too off topic for these forums, we will see.

Anyone know of a good place to poll all your devices, so they can interact ?
Not just imps, although it would be nice to have some sort of shared table with values here also.

I have tried a few.

open.sen.se

  • User have to create each feed before a device can send it.
  • Have modules that can convert data and act on them, shows promise.
    Still in beta.

Thingspeak
Fixed number of fields per device, have to split complex devices over multiple virtual devices.

xively.com / pachube / cosm
Has changed name 3 times in recent times.
Corporate

I have my own basic system, but maintaining it takes some work, and I dont get any features for free :slight_smile:
open.sen.se is probaly the one I like the most, but when I asked them about the limitations in the system, I was told off somewhat rudely that it was not aimed at private people, but just to showcase it for potential business users.
And the activity seems to have died off.

Well, no problems with open.sen.se here:
http://open.sen.se/dolf

I just started using Exosite. Today or tomorrow I get my Arduino Ethernet Shield and will try posting a ton of Dallas Onewire temp readings. I can let you know how it goes. My first impression is that I like it.
http://exosite.com/

There was a post that talked about connecting the imp, but I have not tried it.
http://forums.electricimp.com/discussion/1240#Item_4

I’m a big fan of Firebase - which is a hosted realtime NoSQL database - it’s not specifically designed for “Internet of Things” applications, but it works great for them.

Downside is that it’s quite an expensive solution if you’re going to scale (if you’re just building stuff for yourself a free developer account should work fine).

@Dolf : Yes open.sen.se works, the biggest turnoff I had with them is that the user has to create each field and then enter the feed id into the sender for each item.

With 1-wire for example the end user can add sensors by simply plugging them in, there should not be a need for the user to also tell some interface that a sensor was added, and on some hardware solutions the numbers of sensors is not finite, there may be only 4 1-wire ports on the board, but if the user connects a t-string thats 6 sensors connected to 1 port, alternativly users can connect 2 sensors to the same port by simply connecting the wires.