SvelteKit SQLite Authentication Template

This repository provides a basic template for self-made authentication in SvelteKit backed with a SQLite database. The app has these pages:

• homepage
• register
• login
• account (for authenticated users)
• dashboard (for authenticated users)

Screenshots

Users table

CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY,
    username TEXT NOT NULL UNIQUE,
    password_hash TEXT NOT NULL,
    created_at TEXT NOT NULL DEFAULT current_timestamp
);