E-learning tool. [C# & MSSQL.]

Well that’s some thing to be cooked up with in three weeks.

Dint had any faintish idea how to make it work... till a short sleepy conversation at loliz place a week ago.

Complex things can be taken down in to small pieces.. tiny tricks.

E-learning tool has to be an small app which is running in the background all the time, like those messenger apps do, download "rich" learning content from the main source and present to user in a comfortable way. That’s the basic idea. Content we are dealing here has be "really rich" so we should support variety of video files, audio files, images, animated stuff like flash, text & etc.

First we decided to have minimal user database as the customer(multi-personal syndrome... lol) expected. MSSQL will do fine. Created database design, alone with user data & content detailed stored in several tables with content description plus urls of storage.

Running a app server to facilitate clients seem to be nice,... but is it really needed when things can be done in a simple way? Central database server would be fine... and a good online storage with ftp connectivity.

Both uploading will be also handled by the same client. Hmmm... when it come to security concerns... can make it a bit secure with a lil hash (say md5) checking against files downloaded. Then have to have an hasher in-built to our client. makes sense.

Back stage work will go like that. Have to think about a cool gui that could get all rich content in a neat way. We'll see into that.

Cheers!