A simple contact form application that collects user submissions and stores them in SQLite database.
├── backend/
│ ├── database/
│ │ ├── migrations.ts # Database schema and table creation
│ │ └── queries.ts # Database query functions
│ ├── routes/
│ │ └── submissions.ts # API routes for form submissions
│ └── index.ts # Main Hono app entry point
├── frontend/
│ └── index.html # Contact form UI
└── README.md
GET /api/submissions - Retrieve all form submissionsPOST /api/submissions - Create a new form submissionThe form_submissions_1 table contains:
id (INTEGER PRIMARY KEY) - Auto-incrementing submission IDname (TEXT NOT NULL) - Submitter's nameemail (TEXT NOT NULL) - Submitter's email addressmessage (TEXT NOT NULL) - The message contentcreated_at (DATETIME) - Timestamp of submission