Jekyll Sqlite Plugin

jekyll-sqlite.rb

require 'sqlite3'

module SQLiteGenerator
  class Generator < Jekyll::Generator
    priority :high
    def generate(site)
      site.config['sqlite'].each do |name, config|
        require 'pp'
        SQLite3::Database.new config['file'] do |db|
          Jekyll.logger.info "Jekyll SQLite:", "Starting to load #{name}"
          db.results_as_hash = config.fetch('results_as_hash', true)
          db.execute('PRAGMA synchronous = OFF')
          db.execute('PRAGMA journal_mode = OFF')
          db.execute('PRAGMA query_only = ON')
          site.data[name] = db.execute(config['query'])
          Jekyll.logger.info "Jekyll SQLite:", "Loaded #{name}. Count=#{site.data[name].size}"
        end
      end
    end
  end
end