Columbia Scheduler

Head over to the scheduler:

Every decent college or university needs a decent scheduling utility, and most such utilities allow one to easily organize courses and visualize one’s academic week. Columbia University, which I consider decent (you may have other opinions), lacks a visualization mechanism, leaving students to draw their own schedules based on a textual representation. This feature is one of the most useful because it makes an otherwise-tedious task fun. So I whipped out Notepad and made my own program to fill the need. It parses course information off the online bulletin, stores it in a MySQL database, and draws weekly calendars for users. (Later, I would discover that Barnard College, associated with Columbia, does have this function in its scheduling utility. Not fair!)

It was all very good, until I decided to update the system to a newer version of the bulletin — the new and old course numbers overlapped, among other things, so I had to make numerous adjustments. Also, the parser was not quite up to par; it could not read courses that took place at multiple locations. So I decided to spend a day rewriting the program from scratch.

The new system uses Sqlite as a database mechanism. This makes it incredibly easy to make a copy of the course data — just copy the database file. Because each semester has its own database file, it’s easy to change to a different semester — just swap database files. Updating is a breeze — delete the old database file and regenerate it using new data. And because the database would mostly be used only for reading data, and only occasionally for writing, it would be fast.

Maintaining the system involves some steps. First, the new course data has to be downloaded off the bulletin. This is cached, so that the database can be regenerated many times without incurring network overhead (actually, I did regenerate the database many times while figuring out a workable format). The database handler is then fired up, which first deletes the current semester’s database if it’s available, then creates the tables and inserts the data all over again.

Using the system is pretty straightforward. Now that it has a complete mirror of the online bulletin, it can generate its own directory of courses. The user can navigate through the course listing and select courses to add to his/her schedule, and the weekly calendar is built up course by course. The new system also supports multiple locations, days, times, and instructors per course, which is an immense improvement. In addition, users can browse courses by instructor and by location.

Well, if you’re a Columbia student, I hope you find the new calendar system useful. It won’t register your courses for you, but it should help you make good use of your time.


  1. Aloha says:

    Купил давеча древний артефакт Вершитель. Идя с почты, нашел пятитысячную купюру – реальные а не фантик))

  2. I savour, cause I discovered just what I used to be looking for.
    You’ve ended my 4 day lengthy hunt! God Bless you man. Have a
    great day. Bye

  3. Spot on with this write-up, I absolutely think this site
    needs far more attention. I’ll probably be returning to read
    through more, thanks for the advice!

  4. Sherry says:

    I couldn’t resist commenting. Very well written!

  5. At this time I am ready to do my breakfast, afterward having my
    breakfast coming over again to read more news.

  6. mejor tv says:

    I got this site from my friend who told me about this website and
    now this time I am browsing this site and reading very informative content at
    this time.

  7. I know this website offers quality depending articles or reviews and other data, is
    there any other website which gives these kinds of
    things in quality?

  8. says:

    Valuable info. Fortunate me I found your web site by chance, and I am
    surprised why this twist of fate did not took place in advance!
    I bookmarked it.

  9. Jeannine says:

    whoah this weblog is great i love reading your articles. Keep up the good work!
    You understand, many people are hunting around for this info, you
    can help them greatly.

  10. Aw, this was an incredibly good post. Spending some time and
    actual effort to make a good article… but what can I say… I procrastinate a whole
    lot and never seem to get anything done.

  11. bilet333 says:

    Только наше казино дает возможность ощутить прилив азарта и роскошь игровых залов прямо за домашним монитором. Рулетка, игровые автоматы, более 130 наименований азартных игр, интересные соперники и головокружительный успех. Вы можете прямо сейчас почувствовать себя VIP-гостем любого из лучших игорных домов мира.3330 условных фишек сразу после легкой регистрации! SSL сертификат доверия,индкс честности MD5, SLOT ROOM

Leave a Reply

Pingbacks & Trackbacks

  1. inportb » Blog Archive » Taming Columbia’s Course Schedule - Pingback on 2007/08/23