bboyho
commented
6 years ago Phant is No Longer in Operation
Unfortunately Phant, our data-streaming service, is no longer in service and will be discontinued. The system has reached capacity and, like a less-adventurous Cassini, has plunged conclusively into a fiery and permanent retirement. There are several other maker-friendly, data-streaming services and/or IoT platforms available as alternatives. The three we recommend are Blynk, ThingSpeak, and Cayenne. You can read our blog post [ https://www.sparkfun.com/news/2413 ] on the topic for an overview and helpful links for each platform.
I am working on a Proof of Concept with various devices sending data to our local Phant installation. This works well, but the data is just a simple list of events.
For further processing, I would like to transfer the data to an SQL database, at regular intervals of, say, 1 minute.
This database will link the data to other data unknown to the devices, like user profiles, location descriptions, etc. I assume that transferring to and SQL database makes it easier to create data visualisations.
I do not worry about the logic needed to actually insert data, JSON would be fine to work with, but I also se that SQL insert script can be downloaded.
My concern is how I can select only the data that has been added since my previous transfer. Can Phant generate a unique increasing number, like an Identity column in Microsoft SQL Server? Or should I rely on the timestamp, assuming no two events ever occur at the same timestamp?
I think this will be common scenario, so it may be useful to write a best practice.