Bryar::DataSource::DBI - Retrieve blog posts and comments from database

• Create a mysql database called "bryar":
  
  

      CREATE TABLE posts (
            id mediumint(8) unsigned NOT NULL auto_increment,
            content text,
            title varchar(255),
            epoch timestamp,
            category varchar(255),
            author varchar(20),
            PRIMARY KEY(id)
      );
  
  

  
  
  

      CREATE TABLE comments (
            id mediumint(8) unsigned NOT NULL auto_increment,
            document mediumint(8),
            content text,
            epoch timestamp,
            url varchar(255),
            author varchar(20),
            PRIMARY KEY(id)
      );
  
  

• Install Class::DBI::mysql and Class::DBI::AbstractSearch
• Ensure the web server's database user can read from all tables, and write to the comments table.
• Put source: Bryar::DataSource::DBI in your Bryar config.
• Get blogging!