A parody news website that reimagines the latest AI news through the lens of Shih-Tzu dogs. Built with Hono, SQLite, and Tailwind CSS.
/ - Homepage with featured article and article grid/article/:slug - Individual article pages/about - About page with mission and editorial standardsThe site comes pre-seeded with parody articles including:
CREATE TABLE articles (
id INTEGER PRIMARY KEY AUTOINCREMENT,
slug TEXT UNIQUE NOT NULL,
title TEXT NOT NULL,
excerpt TEXT NOT NULL,
content TEXT NOT NULL,
image_url TEXT NOT NULL,
category TEXT NOT NULL,
author TEXT NOT NULL,
published_at TEXT NOT NULL,
created_at TEXT DEFAULT CURRENT_TIMESTAMP
)
To add new articles, insert into the SQLite database:
await sqlite.execute({
sql: `INSERT INTO articles (slug, title, excerpt, content, image_url, category, author, published_at)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,
args: [
"article-slug",
"Article Title",
"Short excerpt for previews",
"<p>Full HTML content...</p>",
"https://placedog.net/800/400?id=7",
"Category",
"Author Name",
new Date().toISOString()
]
});
Deploy as an HTTP val on Val Town. The database will automatically initialize on first request.