Not much progress made today -

• Tried SQL server compact edition (thought it might be a ripped of 3 MB edition of kam chalau SQL server), turned out something else, so back with SQL EXPRESS 2008 now.
• Tested if the MDF database file can be accessed by ASP.NET and C# programs simultaneously - turned out that it is possible. Just have to take care of closing the connections after every small use.
• Of course LINQ comes into picture here too, easing the access to data
• Prabhat did major work with the Control module - is waiting for the database design to get over.
• AVR-CDC came along with driver issues, we realized that people won't be dedicating a laptop for surveillance in most of the cases, so USB is out of question unless AVR-CDC works well.
• If it doesn't - enter, parallel ports
• Harsha got the Radar style motion detectors working... working on video writer too.
• And, as I write, I feel like cooking some coffee and finishing the database and controllers by the time Prabhat wakes up.
  

For SpaceLock's Web Interface, I've started using LINQ to SQL. LINQ stands for LanguageINtegratedQuery. You no longer put SQL queries into strings and drive them using various objects provided System.Data.sqlConnection. Instead, these queries become a part of your code itself. Yes, we're talking about integration as the name implies. Read more here to see how LINQ minimized the code and improved security.
While the listed code on the blog that uses classical SQL query is still vulnerable to lot of tricks.

Finally the designing phase of web interface for SpaceLock is done...
Time for a short Anime break.... then probably some walk to stretch out...

Night is the time for Database and Controllers... Hope to work upon the M-Jpeg Streamer from tomorrow.

Adios

Settings is done... what remains is the Help section. Planning to build it later.
Todo :

• database connectivity
• controller codes
• testing
  

HTML/CSS design for Intrusions page done, now layout for Help and Settings page remains. Things are coming close to the powerpoint mockups.
After those 2, I can start planning the database and write controller snippets for Web Interface.

Just got over with designing the Control Interface for SpaceLock.

Things are in interface stage as of now... no logic/database implemented in background... just the interface in html/css

Allright, the full speed, full-time development period has started. We got some 6 great super-free days to work over the project. No worries of class tests, college and other projects. Give the best into this and soon we all would be gathered in a room to show a demo to the world.
lol.. cut the crap...
Here's the progress we made yesterday (very little)

• Tested if two copies of Emgu CV based programs can acquire images simultaneously from the webcam. Nope, that doesn't happen. What it means is that we can't have 3 programs acquiring images form cam at same time and doing their own work. And, the solution now lies in grabbing a frame from webcam and giving it to 3 threads that would take care of
  
  • streaming it as m-jpeg
  • rotating cam by motion analysis
  • surveillance study
    
• Started laying out some CSS and structure for the web interface. Blank templates done and main page after login has been started.
  
• The other efforts went into exploring more C# for threading.
• Godse started planning out what information to show up on the C# interface that runs on the system.
  
• Harsha has bebun making an independent surveillance system using Emgu CV that would be submerged into the project later.
  
• Sagi has decided onto what components to buy and would be starting soon with the rotatory mount
  

Today :

• Hopefully as I jot these points at 6 AM, I think the HTML/CSS part of the Web Interface would be done by today.
• And by today evening I would've started with programming controls and planning the SQL database.
• Planning the database would become easier as by evening, completion of Views and Control Interface planning by Godse would leave me with enough inputs.
• And of course I guess we all would start getting the clearer picture of the architecture and lot of doubts and interactions :)