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
Class::DBI::mysql
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.
source: Bryar::DataSource::DBI
Get blogging!
To install Bryar, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Bryar
CPAN shell
perl -MCPAN -e shell install Bryar
For more information on module installation, please visit the detailed CPAN module installation guide.