From acb38afcd4780191569ee809f3e8bdb550a634bc Mon Sep 17 00:00:00 2001 From: Dimitri Sokolyuk Date: Wed, 5 Sep 2012 18:34:48 +0000 Subject: blogsum --- examples/create_sqlite.sql | 36 ++++++++++++++++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 examples/create_sqlite.sql (limited to 'examples/create_sqlite.sql') diff --git a/examples/create_sqlite.sql b/examples/create_sqlite.sql new file mode 100644 index 0000000..8bc8850 --- /dev/null +++ b/examples/create_sqlite.sql @@ -0,0 +1,36 @@ +BEGIN TRANSACTION; +CREATE TABLE articles (id integer primary key, date date, title text, uri text, body text, tags text, enabled boolean, author text); +INSERT INTO "articles" VALUES(1,'2009-11-16 18:07:10','Welcome to Blogsum','Welcome-to-Blogsum','

Introduction

+ +

Blogsum is a very basic blogging application. It was written from scratch with a focus on simplicity and security, favoring practicality over feature bloat.

+ +

Writing Articles

+ +

The Administration interface is straightforward and bereft of unnecessary features. Three views allow you to create posts, moderate comments and administrate (manage posts). Blogsum uses HTML markup for article formatting. New articles are saved as a draft .

+ +

There''s one other useful thing to remember about editing your articles. If you have a lengthy post you might want to split it up with the <!--readmore--> tag. Anything that appears after this HTML comment will appear in the full article view, but will be hidden from your blog''s front page. Here comes one now...

+ + + +

Managing Articles

+ +

As mentioned above, new articles are saved as a draft. Click the publish button to see your post go live. You can make edits to a live article, but the timestamp won''t be updated unless you re-draft and re-publish the story. If you decide that you really want to remove an article from the administrate view, you can delete it.

+ +

Comments and Moderation

+ +

Article comments are moderated and must be accompanied with a successful Captcha challenge. All user input is encoded to avoid XSS issues. Click on the moderate view to approve or deny a comment submission.

+ +

Using Tags

+ +

Tags are used liberally throughout Blogsum. Besides the tags defined in an article, Blogsum also uses the /Tags/ path to search for authors. It also favors the use of tags as a conventional replacement to categories. Anyone can use the /Tags/ path to search for articles in Blogsum (example).

+ +

Themes

+ +

Blogsum includes a default theme (what you''re viewing now). If you wish to modify it according to your tastes, you should create your own theme. To create a theme, copy the themes/default directory to your own directory (e.g. themes/foobar) and modify accordingly. Changes can be made to any of the files in a theme, but the path and filenames should not change. When you are finished, edit the $blog_theme setting in Blogsum/Config.pm and restart your webserver.

+ +

Go Forth and Blog!

+ +

As you can see, Blogsum is a very simple application designed for less maintenance, more writing. We hope you enjoy publishing your works within Blogsum. If you create your own themes, please consider donating those back to the project. Enjoy!

+','Blogsum,Welcome',1,'jdixon'); +CREATE TABLE comments (id integer primary key, article_id integer, date date, name text, email text, url text, comment text, enabled boolean); +COMMIT; -- cgit v1.2.3