New real-time Analytics-like logging system
So the company I work for is considering spending over $20,000 on a new web analytics software. Out of the list of packages are Omniture, CoreMetrics, and WebTrends.
It is amazing that this is a niche that has not really been filled via open source offerings.. yet.
Say hello to PG::Stats.
Okay, okay… so this is NOT a finished work of art yet. But I have started a large portion of it thus far. In fact, I currently have:
- A standalone high-performance customized web server daemon for the data push API
- A single perl module for the actual data insertion
- A near-finalized table structure.
The system is written purely in Perl. Theres a front-end I currently have styled and sketched out using the Catalyst framework but nothing functional on that end.
The database is Postgres (as apposed to MySQL) because:
- Postgres supports Table partitions and proper inheritance.
- Postgres has nifty data-type such as IP Address types
- MySQL is now owned by Oracle – need I say more?
I have been thinking of turning this into a GPL’d application and setting up a subversion project on my server if enough people would be interested.
Gimme a shout at dean@supergluetech.com
No comments yet.