lanci-pirli

Travelling competition score collector — manage competitions and participant scores locally.

Usage

npx lanci-pirli

Opens in your browser at http://localhost:3000. Data is stored in competitions.db in the current directory.

Configuration

Create a .env file in your working directory:

PORT=3000      # Server port (default: 3000)
TOP_N=10       # Number of top scores to display (default: 10)
APP_LANG=it    # UI language: it, en, fr, de, es (default: it)

Features

• Create and manage competitions (place + date → name)
• Enter scores with competitor name, score, optional location and phone
• Autocomplete competitor names within a competition
• View top N scores per competition (best score per competitor)
• Edit or delete individual scores
• Hide competitions from the list
• Export scores as CSV (top N or full list) or JSON
• Import JSON scores with merge deduplication
• UI available in Italian, English, French, German, Spanish

Development

git clone ...
cd lanci-pirli
npm install
npm run dev     # Starts both client (port 5173) and server (port 3000)

Tech Stack

• Frontend: React + Vite + TypeScript + Tailwind CSS + shadcn/ui
• Backend: Express + TypeScript + Drizzle ORM + SQLite (better-sqlite3)