New Feature of Fosstrak LLRP Commander: Log LLRP tag reads to SQL database

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.

Advertisements

One Response to New Feature of Fosstrak LLRP Commander: Log LLRP tag reads to SQL database

  1. […] Database Integration in Fosstrak LLRP Commander/ALE Middleware In a previous blog post, I already mentioned a new feature of Fosstrak that allows users to log tag reads reported in LLRP […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: