Group Work + Database

This weekend has been great for me.

Saturday I spent researching SQL Server and its take on stored procedures, transaction control and CLR.

then did some research regarding database design, and proceeded to implement what I was hoping Andrew to have complete at the beginning of this session.

I have written several stored procedures which allow Shawn to use the database for the PHP Mapping Engine he is building and pull out points for specified UUID's/Devices. Then a couple of procedures to pick up the next point in a record set for displaying the points.

Then I proceeded to split up the all the GPRMC strings that we've generated since the use of gps + mobile combo. Some of the data was Shawn's trip on the mountains - so that will be interesting to have a look at once plotted. The splitting of the string was done by a parser class I hacked together that spits out decimal lat+long's as well as km/h and other attributes of an RMC string.

Now we have a database with which we can work for the display of points.

It is now necessary to write more procedures to make Shawn's job easier in locating the necessary data for a device and any criteria such as subdivig a drive into separate trips.

I hope that Andrew will have a Membership provider finished by this Wednesday, as I've taken a lot of what he was supposed to do off his back.

Once that is complete, I can commence integrating the PortalSite with the database.

Main features I want to focus on initially include user creation, logins and profile settings.

In conclusion - good news. I spoke to Karen Williams today - and our WebTrac device has finally been ordered.

So unless it gets stolen/broken/misplaced along the way - we should have it in use by next week.