CSV to SQLite Uploader

A simple React app that allows you to upload CSV files and automatically create new SQLite tables in Val Town.

Features

  • Upload CSV files via drag & drop or file picker
  • Automatically infer column types from CSV data
  • Create new SQLite tables with proper schema
  • View uploaded tables and their data

Structure

  • backend/ - Hono API server
    • index.ts - Main API routes
    • database/ - Database utilities
  • frontend/ - React app
    • index.html - Main HTML template
    • components/ - React components
  • shared/ - Shared utilities and types

Usage

  1. Navigate to the app
  2. Upload a CSV file
  3. Specify a table name
  4. The app will create a new SQLite table with your data