Deno code to create an rss feed of public entries from the sqlite database of a Shiori bookmark server.

example.rss

<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
    <channel>
        <title>keyboardcrunch - recently read</title>
        <link>https://blog.keyboardcrunch.com/</link>
        <description>A list of stuff I found interesting or look forward to reading.</description>
        <lastBuildDate>Thu, 15 Jun 2023 01:59:18 GMT</lastBuildDate>
        <docs>https://validator.w3.org/feed/docs/rss2.html</docs>
        <generator>https://github.com/jpmonette/feed</generator>
        <item>
            <title><![CDATA[A Begginers All Inclusive Guide to ETW — Blake's R&D]]></title>
            <link>https://bmcder.com/blog/a-begginers-all-inclusive-guide-to-etw</link>
            <guid>https://bmcder.com/blog/a-begginers-all-inclusive-guide-to-etw</guid>
            <description><![CDATA[An all inclusive guide to ETW, from what it is to how we can use it.]]></description>
        </item>
    </channel>
</rss>

sqlite3_to_rss.js

import { Database } from "https://deno.land/x/[email protected]/mod.ts";
import { Feed } from 'https://jspm.dev/feed';

// database work
const db = new Database("shiori.db");
const bookmarkQuery = db.prepare(
  "SELECT title, excerpt, url FROM bookmark WHERE public = 1",
);
const bookmarks = bookmarkQuery.all();
db.close();
console.log('Public Entry #: ', bookmarks.length);

// feed work
const newFeed = new Feed({
  title: 'keyboardcrunch - recently read',
  description: 'A list of stuff I found interesting or look forward to reading.',
  link: 'https://blog.keyboardcrunch.com/',
  updated: new Date()
});
for (const row of bookmarks) {
  newFeed.addItem({
    title: row['title'],
    link: row['url'],
    description: row['excerpt']
  })
}
// write out the rss feed
console.log(newFeed.rss2());

Needs to be run with deno run --allow-env --allow-read --allow-ffi --unstable sqlite3_to_rss.js flags, the sqlite3 module needs FFI, env, read, and unstable to operate.