SQLite

SQLite runs FTC Dashboard's persistent storage — attendance records, budget entries, and message history. It's serverless, needs zero setup, and is fast enough for any app with hundreds of concurrent users. I'm comfortable writing raw SQL and optimizing queries.

SELECT p.id, p.title, COUNT(t.id) AS tags
FROM posts p
LEFT JOIN post_tags t ON p.id = t.post_id
WHERE p.published = 1
GROUP BY p.id
ORDER BY p.created_at DESC
LIMIT 10;