AudioFerret/v1/sql/qryTrack Playing

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret‎ | v1‎ | sql
Jump to: navigation, search

About

  • Purpose: in theory, reduces bandwidth usage by having the server send only the currently playing track rather than sending the whole list and having the client hunt for the one that's playing. In practice, we often want to know the last N tracks... so maybe we need a query for that instead.
  • Uses: Tracks_Played

SQL

<mysql>CREATE OR REPLACE VIEW qryTrack_Playing AS

 SELECT * from Tracks_Played ORDER BY ID DESC LIMIT 1;</mysql>