It’s only one month before my pet project becomes one year old. This is what my files’ timestamp claims though.

QueueMatrix will turn one year old on May 15, 2007. I don’t exactly know what to call it but here’s how it works. It processes flat files to structured data then displayed as human readable data. Those flat files are produced by a cluster of Asterisk (VoIP) servers then callhome to a database. As the year chugged along, a bunch of features were requested and messy patches were done.

I wrote before that this “system” will be used as a basis for the salaries of around 200 people. I can’t mess up anymore.

My long term plans for it include:

• Data warehousing – Close to one year, the size of the database is now at ~1.3GB. Although still small, I want to purge this data and warehouse it (should prevent tampering too).
• More distribution of processes – I should explain this in another post. The current system runs on a desktop machine. Sometimes, it gets overloaded. The new system is being tested with meaner Javascript, using my own version of JSON and less backend processing. It’s now threaded too (in some way).
• Prepare for servers in different geographic locations – I’ve heard of such plans where another server will be installed …in another timezone. More timezone calculation headaches and that friggin’ DST.
• Dissolve manual processes – I can’t disclose too much about this issue but there are still manual processes that I want to remove.
• Tighter security
• Automate installation processes
• Find a better way to index files – I’m so ashamed of my solution it makes me cringe. What I did was have one directory scanned, processed and stored to the database every X number of minutes. The ugly part is that before scanning, the table is flushed instead of appending the new files found. Ewww.

This entry was posted on Sunday, April 15th, 2007 at 22.44 and is filed under foo, bar and h4xx1ng, Software/Code, Techitude. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.