excel

excel

JobApp

Creating a job app with chat forum

Public

Val Town is a collaborative website to build and scale JavaScript apps.

Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.

/

/

Viewing readonly version of main branch: v12

View latest version

Backend

This directory contains the server-side code for the Job Board with Chat application.

Structure

index.ts - Main entry point for the Hono API server
Database tables:
- job_postings - Stores job listings
- chat_messages - Stores chat messages

API Endpoints

Jobs

GET /api/jobs - Get all job postings
POST /api/jobs - Create a new job posting

Chat

GET /api/chat - Get chat messages (most recent 100)
POST /api/chat - Post a new chat message

Database Schema

job_postings

id - INTEGER PRIMARY KEY
title - TEXT
description - TEXT
company - TEXT
location - TEXT
salary - TEXT (optional)
contact - TEXT
created_at - TEXT (ISO date string)

chat_messages

id - INTEGER PRIMARY KEY
username - TEXT
message - TEXT
created_at - TEXT (ISO date string)