SQL and Web Dev, The MIT way.
Caught in the “web” of lisp, sql, and databases has been pressing me hard for my time. With everything else in my life coming to an almost complete standstill I had taken a small sabatical from blogging. I’ve been reading up on things as mundane as RDBMS these days. But two little websites I found from the guy who gave us the “Greenspun’s Tenth Rule”, has put my mind through a mixer. What was mundane (RDBMS), now is as exciting as anything else. If you think thats not saying much, I had considered SQL and RDBMS theory as interesting as a pile of rock.
I have never seen SQL being explained with such casual prose. If only my college could do sql this way I would have been a database geek instead of a languages geek. And, thats not to say that “compilers” were taught in a “oh, so fascinating” way because of the involvement of certain Research Scholars. This, simply put is the best SQL tutorial I’ve ever seen
And to top that, the same guy has also written an interesting and extremely thoughtful piece about making websites. Its a nice read, and is suprisingly up to date too. here is a link : Philip and Alex’s Guide to Web Publishing. These are must reads for anyone who is even thinking of doing web development. I guess, if you are a total newbie to web development, this is the second thing you should do after you read up on HTML.
As an aside, I’ve been checking out django on python for an interesting web development framework. The Admin system is just so cool, and the fact that I can get a simple system working in less than a matter of 20 minutes without actually writing a single line of SQL is just amazing. But the fact is that I still keep going back to LISP after all the initial hype. When I love the fact that I can do an almost 1-1 mapping between XHTML and LISP’s S-expr, and I can keep it lisp all the way down. Hmm, probably another post is on its way as an interesting comparison between Django and Lisp for web-development from the perspective of some one who is evaluating web development frameworks for a first foray into web applications. So stay tuned.. (yuck! I sound like a VJ.damn!)