xmltvdb 3

xmltvdb is a fairly simplistic tv listings database/viewer for xmltv listings. It uses PostgreSQL and mod_perl.

Creating the Database

First off, youll want to create your database. The schema.sql file contains the basics youll need. The mkschema.sh will replace the placeholder schema name within schema.sql with the value you pass it as an argument, and spit the result out to stdout. So, you might do something like:

./mkschema.sh xmltv | psql database xmltvuser

And assuming the xmltvuser has create schema privileges (important!) it should create everything. If you want separate users for schema ownership versus reading/writing data, youll have to setup the grants yourself. The pgadmin3 tool makes doing such mass grants easy.