In a previous blog post, I already mentioned a new feature of Fosstrak that allows users to log tag reads reported in LLRP RO_ACCESS_REPORTS to a SQL DB. Here are a few screenshots that illustrate this functionality.
SQL Database Integration in Fosstrak LLRP Commander/ALE MiddlewareDecember 12, 2009
New Feature of Fosstrak LLRP Commander: Log LLRP tag reads to SQL databaseNovember 5, 2009
This is a quick post about a really cool feature Samuel, the Fosstrak lead on the LLRP Commander, added in the last release that allows users to specify the database to which LLRP messages are logged. Previously, we used a database that was built-in into the LLRP Commander. With the new feature, users can specify a (remote) SQL database server of their choice to which they want the data to be logged. This makes data analysis really trivial. Setup an open source database such MySQL or PostgresQL, install the Fosstrak LLRP Commander, connect to your reader or readers of choice and then analysis your data via SQL. The Fosstrak LLRP Commander logs all messages, but also parses the individual RO_ACCESS_REPORTs for TAG_REPORT_DATA on each tag read and lists each TAG_REPORT_DATA parameter as a new row in the SQL table.
This is great for data analysis purposes. No need to write any code to get RFID data such as IDs or RSSI values from one or more readers. At the MIT Auto-ID Lab, we are now using Matlab to query the database and visualize the data captured.