ShihTzu Intelligence

A parody news website that reimagines the latest AI news through the lens of Shih-Tzu dogs. Built with Hono, SQLite, and Tailwind CSS.

Features

  • Modern, responsive design with gradient accents
  • SQLite database for article storage
  • Homepage with hero section and featured article
  • Article grid with hover animations
  • Individual article pages with rich content
  • About page with editorial standards
  • Newsletter signup section
  • Mobile-friendly navigation

Tech Stack

  • Framework: Hono (lightweight web framework)
  • Database: Val Town SQLite
  • Styling: Tailwind CSS (via CDN)
  • Fonts: Inter (Google Fonts)

Pages

  • / - Homepage with featured article and article grid
  • /article/:slug - Individual article pages
  • /about - About page with mission and editorial standards

Sample Articles

The site comes pre-seeded with parody articles including:

  • "ShihGPT-5 Released: Now Understands 'Who's a Good Boy?' in 47 Languages"
  • "Breaking: Shih-Tzu Achieves Artificial General Napping (AGN)"
  • "New Study: Shih-Tzus Pass the Treat-ing Test with Flying Colors"
  • "Shih-Tzu Passes the Bark Exam, Outperforms 90% of Human Lawyers"
  • "Scientists Observe Quantum Zoomies"
  • "Shih-Tzu-Led Startup Valued at $50 Billion After Pivoting to Naps"

Database Schema

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 )

Adding New Articles

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() ] });

Customization

  • Colors: Edit the gradient classes and Tailwind colors in the layout
  • Images: Replace placedog.net URLs with your own Shih-Tzu images
  • Content: Modify the seed articles or add your own
  • Branding: Update the site name and footer text

Deployment

Deploy as an HTTP val on Val Town. The database will automatically initialize on first request.