Mint Forum

hi,

I was wondering how you would go about displaying your mint statistics on a site? How difficult is this? is it just a case of knowing the right queries or is it a little more involved?

any ideas or help would be mucha appreciated!

jesse

I’m doing this in Ruby, but some of the ideas might be useful in PHP or whatever language you’re using to pull the data.

Sample in use: http://nubyonrails.com/articles/2006/06 … ast-o-rama

I made a separate table that caches the number of hits for a resource in a certain time period. I run a nightly cron that summarizes the data from the main Mint table and saves it to that cache table. The blog/cms/whatever just needs to pull the data out of the cache table based on the resource name being requested.

The cache table is simple:

  CREATE TABLE mint_caches (
        id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
        resource VARCHAR(255) NOT NULL,
        resource_title VARCHAR(255) NOT NULL,
        visit_count INT(10) NOT NULL,
        earliest_visit DATETIME
  )

Source: http://topfunky.net/svn/plugins/mint