fhadmin

A lightweight, customizable admin panel for FastHTML applications with SQLite databases.

Features

• 🔐 Simple password authentication
• 📊 Table browser with card-based overview
• 🔍 Full-text search across text columns
• ✏️ Inline cell editing
• ➕ Create new records via modal
• 🗑️ Delete records
• 💻 SQL console for custom queries
• ⚠️ Dangerous SQL query detection with confirmation prompts
• 📄 Pagination with smart page buttons
• 🎨 Beautiful UI with DaisyUI/Tailwind

Installation

pip install fhadmin

Quick Start

from fasthtml.common import *
from fhadmin.core import AdminConfig, create_admin
from fastlite import database

# Create your main app
app = FastHTML()

# Configure and mount the admin panel
cfg = AdminConfig(db_path="data/mydata.sqlite", password="secret")
admin_app = create_admin(cfg)
app.mount("/admin", admin_app)

Visit /admin/login to access the admin panel.

Configuration

The AdminConfig dataclass accepts:

How It Works

fhadmin uses a configuration-based architecture that stores settings in app.state.cfg. Routes read the configuration at request time, making it:

• Notebook-friendly — Rerun any route cell without side effects
• Easy to debug — Routes are plain functions, no closures
• Flexible — Change database or password at runtime if needed

Routes

Requirements

• Python 3.10+
• fasthtml
• fastlite
• fhdaisy
• fh-heroicons

License

MIT