thedarktrumpet

Common Lisp surprises me more and more each and every day. I never thought of using it for SQL interaction, but the adventures of CL-SQL for my linguistics class lately really opened my eyes.

CL-SQL is an ORM, like that of ActiveRecord, Django's ORM, and so on. It leans a little more toward the SQL Alchemy side of things, though. I will likely provide a much more detailed tutorial later once I get a general understanding of this library - but for now I'll provide a bit for links on where to find more information:

CLSQL Main Site: http://clsql.b9.com/
Script I learned a lot from: http://www.boundp.net/files/weblog.lisp
Github post of my wordnet stuff: http://gist.github.com/244360

Now for a bit of information about wordnet. I'm currently in a computational linguistics course at the university, and part of the class is to develop a project of sorts. Mine relates to the use of wordnet, which is a fairly complicated database. Basically, wordnet was developed by Princeton, that has a fairly large set of words and their definitions, synonyms, hypernyms, hyponyms, and so on. In sort, it shows a lot of ways that one word relates to another word in various ways. I found a web site that had the MSSQL files for Wordnet, which I downloaded and attached. Along with that, a number of example view code that I modified to add to a listing of views. Since I do my development, most of the time, on Linux - I decided to get ODBC setup to the MSSQL server. CL-SQL works beautifully with this setup. The gist above shows the details.

For the SQL Server database I got, you can view the information here: http://opensource.ebswift.com/WordNetSQLServer/

I will likely provide more information as I go with this, as I'm finding wordnet more and more fun to mess with

I finished my presentation for Iowa Code Camp this morning - it went pretty well I feel, although a very little turnout. Here are my notes and other information!

Here are some download locations for my notes and my code itself:

Sides themselves:
http://static.thedarktrumpet.com/theory-iccn09.pdf

Code:
http://static.thedarktrumpet.com/code-iccn09.lisp

It has been a nice day today, reaching almost 50F. I went outside to double check on the motorcycle running ok (it just got back from the shop recently) and it ran perfectly. I sat out there for a few minutes thinking how nice it'd be to go for a ride. Unfortunately, because of the cold weather, there's not a lot I can really do.


Outside that, I think the site is coming along pretty well :) Some areas are still not working 100%, but I ran out of time tonight, I need to finish a review paper for my class and prepare for the week.