analytics

const (
	// Count the number of distinct IP addresses which have visitied the path.
	QueryVisitorsPerPath = `SELECT COUNT(distinct ip) FROM visits WHERE path = ?;`
	// Count the number of entries with the given path.
	QueryVisitsPerPath = `SELECT COUNT(id) FROM visits WHERE path = ?;`

	// List all the distinct paths in the database.
	QueryAllPaths = `SELECT DISTINCT path FROM visits;`
	// List all the distinct hosts in the database.
	QueryAllHosts = `SELECT DISTINCT host FROM visits;`
)