Posts tagged "missouri state"

Introducing Etcetera

Just a brief post introducing a system I’m working on for… work. It’s our equipment tracking and service ticketing system for ETC at Missouri State University.

It runs Django 1.1 running on top of Apache2, mod_wsgi, and Python 2.5.4 (with a PostgreSQL database). I’m short on time today, but I’ll post more later about some of the inner workings of the application and some issues I’ve seen while working on it (and how to resolve those). More to come!

I’m not one for classical music, but wow — he blew my mind with this solo. He’s probably one of the greatest clarinetists (that had better be the correct word) I’ve ever heard in my entire life. And he’s a student at Missouri State.

Here’s “Black Dog”, composed by Scott McAllister, from 2009 November 17 at the Wind Ensemble Concert at Missouri State University.

Update on Etcetera, screenshots too!

I’m giving a brief presentation on the Django-based system I’m building for Missouri State University’s Educational Technology Center tomorrow, and thus I’ve done a few obligatory slides on what it can do. Here’s a SlideShare viewer for the PDF I’ve saved from my slides.

I’m developing it using Django’s subversion trunk for now, but once 1.2 is released (before too long, I imagine), I’ll lock in the feature set there and use the 1.2 line. All development is done on my local machine, which is setup with virtualenv and pip. I’m currently using TextMate and occasionally MacVim as my text editors. I then use my local machine as an Apache test environment as well, running through a mod_wsgi daemon. All the development code is currently hosted on github, but that may change if the university doesn’t want the code listed publicly. It’s there for convenience, as I can post updates to the application there, and whoever manages the server in the future can just pull the changes. It’s also great for collaboration, as others can view the code and make suggestions (which are surely needed; I’m still in the Django-learning phase).

The production server running it is a Mac OS X Leopard Server-running quad-core Intel Xserve. It uses PostgreSQL 8 in both development and production. Here’s some numbers (my favorite part).

  • The system is serving roughly 16 (soon to be about 25) users
  • It houses nearly 6000 rows of equipment — everything in ETC’s inventory
  • It holds close to 1000 past and present work order tickets for equipment problems across campus
  • It will track about 1200 equipment checkout orders per fiscal year from 91 buildings/locations and 324 organizational/business units on campus
  • I really need to install Google Analytics code to get usage statistics… once I do, I’ll have those numbers as well

It runs quite nicely in tandem with Nathan Borror’s slick redesign of our department’s website, also written in Django (it uses docutils to parse reStructuredText files into HTML).