Skip to content

Instantly share code, notes, and snippets.

@dbarbar

dbarbar/spotbox ideas.md

Created November 1, 2011 04:30
Show Gist options
  • Save dbarbar/1329941 to your computer and use it in GitHub Desktop.
Save dbarbar/1329941 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
spotbox ideas.md

DB instead

Uri. Fixed length string. Primary key

First add. Time stamp or int

Most recent add time stamp or int On duplicate key most recent add = now

Request count. Int On duplicate key request count++

Title strong Artist strong Album. String Length. Int Popularity. Int Played count int? Could delete the row once it gets checked as played.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment