Tag Archives: database

Course Listing Database Project

I was just told by UMass Dartmouth that they wouldn’t be releasing publicly available data in a database format just so I, a mere student, could work on a simple project for what they deemed is likely only a personal project for my own benefit, without actually asking me what the project is about.

They then proceeded to say I was more than welcome to process the HTML-ified version of the course listing, which, they reminded, is a more ambitious project. What the…!? Are they trying to make my life difficult?

Well, you know what? I’m going to process that HTML, and then I’m going to push that database to my home directory on the UMass Dartmouth servers, so everyone can use it without bothering with talking to these people.

There shouldn’t be any problem with this, given that it’s already publicly available information. I think the real problem here is they just don’t have time for silly student ideas.

Edit: HTML processing code finished. I have an SQLite database of all UMass Dartmouth classes. 🙂

Narvenyl Likes Spiders

Indeed, where would I be without them? Narvenyl’s new DataSpiders create new possibilities in database abstraction that makes me “geek out”.

The problem is simple. You define what each table looks like, and you can get data from each table in a nice list of objects. However, you can’t minipulate that data, or extend beyond one table, before the results are compiled into an orderly format and returned back to the caller.

From your, the programmer’s, point of view, you ask for purchase #382 from your store’s database, and you get purcahse #382. You know what is inside that object, because you’ve defined what fields are in each object.(For example, the fields “date” and “payment type” are very predictable. However, what about a field called “purchased”? Suddenly, you no longer have a simple, easy-to-store value. Now you have a list of items with their own values!

SQL developers know exactly what I’m talking about. You SELECT data from a database, and then you SELECT more afterwards to get the related data, such as items purchased, addresses used, etc. All this is done largely by hand.

Narvenyl is supposed to automate this kind of task, but how? The fields are defined, and you query those fields and return them. It’s fairly inflexible. Continue reading

Narvenyl Progress (Summary: Slow)

The supply of time has been continually decreasing at the same time demand is increasing. I’m talking about the combination of holidays, deadlines at work, and other such nuisances revolving around a rather ingenious concept called real life.

When it comes to time restricting some of my more fun activities, I generally drop into sarcasm. But I’ve gotten it out of my system now (that’s what blogs are for, right?) so I can carry on writing the rest of this post in all due seriousness. Continue reading

One Down, One to Go

I am officially re-settled into Ubuntu again! I had to drop Kopete due to an annoying crash when I tried to log into certain protocols, so I use Gai… I mean… Pidgin instead. I seem to be running in circles – this is the second time I’ve switched back from Kopete.

On the side, I forgot to back up my MySQL DBs and private keys for e-mail signing. The former is a mirror of another DB (thankfully!) and the latter is dispensable (really, who checks those things anyway?).

Powered by ScribeFire.