gistfile1.rb

#!/usr/bin/env ruby
# http://github.com/mojombo/jekyll/tree/master

require 'rubygems'
require 'sqlite3'

db = SQLite3::Database.new( "blog.db3" )
db.results_as_hash = true
db.execute( "select * from articles" ) do |row|
  file_name = row['created_at'].split(" ")[0]
  file_name << "-#{row['title'].gsub(" ", "-")}.textile"
  out = File.new "posts/#{file_name.downcase}", 'w'
  out.puts "---"
  out.puts "layout: article"
  out.puts "title: #{row['title']}"
  out.puts "created_at: #{row['created_at']}"
  out.puts "updated_at: #{row['updated_at']}"
  out.puts "---"
  out.puts "\n#{row['body']}"
end