Sensors to SQL

AIman

Does anyone know how to hook sensors straight into SQL?

I am intending to run a wirless hook up from my robot to my desktop, use SQL to analyize the results and return instructions. Of course if SQL can't be used then VBA would be an option.

Currently thinking the Prop would be a good choice on the robot end but that is open to discussion.

Mike Green

SQL consists of a series of commands that come in as text strings. You will need some kind of front end on the PC side that takes commands from the wireless link and submits them to the SQL engine. A Stamp could make up the commands and send them over the link, but it would be a better use of processing power to do the work on the PC side. In other words, to have an interface program on the PC in VB that accepts commands from the Stamp that are very simple with simple responses.

A Prop on the robot end would be much more capable of handling the SQL commands and responses directly. It can also do floating point which the Stamp cannot.

AIman

Thanks.

My job requires running SQL to servers so a front end won't be too much of a problem. Actually we run servers straight to SQL, Excel and Access. Still haven't figured out why we don't use just one program....

Question - do you use cameras ever? If so how do you code things to identify objects? Example - hey something's there - should I go under over or around?

Mike Green

Have a look at CMUcam (do a websearch). This is an open-source camera processor. It can do some very simple visual processing like find the centroid of a blob of color ... useful for tracking a ball or a person wearing a particular large area color. More complex image processing is very complicated and is usually a multi-step process. You could probably spend a couple of years in a graduate level university course learning this.