💻 Beger - Board Management System

A modern, full-stack application for managing boards with user authentication, repairs tracking, and test results management. Features a React 19 frontend and blazing-fast Hono backend powered by Bun.

Created for my fathers job.

⚡ Quick Start

git clone https://github.com/iiivanpopov/beger.git
cd beger

cp .env.example .env # Then config

docker-compose build
docker-compose up -d

🚀 Features

• 🔐 JWT Authentication - Secure user authentication with access/refresh tokens
• 👥 Role-Based Access Control - Admin and user roles with different permissions
• 🔧 Repairs Management - Track and manage board repairs
• 📊 Test Results - Record and monitor test results
• 📋 Google Sheets Integration - Import data directly from Google Sheets
• 🎨 Modern UI - Beautiful and responsive interface with React 19
• ⚡ High Performance - Built with Bun for exceptional speed
• 🐳 Docker Ready - Easy deployment with Docker Compose
• 👅 Internationalization - Multi language

📋 Prerequisites

Before you begin, ensure you have the following installed:

• Docker
• Git

⚙️ Tech Stack

📱 Frontend

Framework: React v19 ⚛️

• Tanstack Router - File-based routing solution
• Ky - Elegant HTTP client with a convenient API
• Tanstack Query - Powerful server state management for data fetching
• React Hook Form - Performant form state management
• Valibot - Lightweight validation library (Zod alternative)
• React Intl - I18n

🔒 Backend

Framework: Hono v4 🔥

• Drizzle ORM - TypeScript-first ORM for type safety
• Valibot - Request validation
• Bun - Ultra-fast JavaScript runtime with built-in PostgreSQL and Redis drivers

🗄️ Database

• PostgreSQL - Primary database
• Redis - Caching and session management

🔧 Development Tools

• ESLint - Code linting with @antfu/eslint-config
• Stylelint - CSS/Style linting
• @yelaiii/stylelint - My Custom Stylelint configuration

📦 Installation (Docker Compose)

1. Clone the Repository

git clone https://github.com/iiivanpopov/beger.git
cd beger

2. Configure Environment Variables

Create a .env file in the root directory:

# Server Configuration
PORT=5333                                           # Backend port

JWT_ACCESS_SECRET=c9e5fd5df58770fea7063ebad0c78d6c  # Generate new secret for production
JWT_REFRESH_SECRET=2d03a2683014ad790487149e73d97bc2 # Generate new secret for production

# Admin Credentials
ADMIN_PASSWORD=                                     # Set a strong admin password

# Database Configuration
DB_USER=postgres                                    # PostgreSQL username
DB_PASSWORD=postgres                                # PostgreSQL password (change in production!)

# Google Sheets Integration
SHEET_URL=""                                        # Your Google Sheet CSV URL (in quotes)

The default JWT secrets shown above are for development only. Generate strong, random secrets using:

openssl rand -hex 32

📝 Note: The SHEET_URL must be enclosed in double quotes

2.1 Custom Port Configuration (Optional)

If you need to use a different backend port, update both files:

.env:

PORT=4111  # Your custom port

apps/frontend/nginx.conf:

location /api/ {
  proxy_pass http://backend:4111/api/;
  # ... rest of configuration
}

3. Build the Project

docker-compose build

4. Start the Application

docker-compose up

Or run in detached mode:

docker-compose up -d

The application will be available at:

• Frontend: http://localhost (port 80)
• Backend API: http://localhost:5333/api (or your custom port)

🔄 Updating the Application

When new updates are available:

docker-compose down

git pull

docker-compose build

docker-compose up -d

📊 Google Sheets Integration Setup

The application supports importing data from Google Sheets. Here's how to set it up:

Step 1: Prepare Your Sheet

Ensure your Google Sheet has the exact column headers as shown:

Step 2: Publish to Web

1. Open your sheet in Google Sheets
2. Go to File → Share → Publish to web
3. In the modal, select CSV (Comma-Separated Values) format (not "Web Page")
4. Click Publish and copy the generated URL

Step 3: Add to Environment

Add the CSV URL to your .env file (remember to use quotes):

SHEET_URL="https://docs.google.com/spreadsheets/d/e/YOUR_SHEET_ID/pub?output=csv"

📁 Project Structure

beger/
├── apps/
│   ├── backend/
│   │   ├── src/
│   │   │   ├── app/        # App init layer
│   │   │   ├── modules/    # Feature modules
│   │   │   ├── config/     # Configuration layer
│   │   │   ├── database/   # Database schemas & migrations
│   │   │   ├── middleware/
│   │   │   └── utils/      # Project shared utils
│   │   └── drizzle/        # Database migrations
│   └── frontend/
│       ├── src/
│       │   ├── api/        # API hooks & requests
│       │   ├── routes/     # Tanstack Router routes
│       │   ├── pages/      # Page components
│       │   ├── components/ # Business components
│       │   ├── providers/  # React context providers
│       │   ├── styles/     # CSS global styles
│       │   └── shared/     # UI-Kit, hooks, utils
├── assets/
├── docker-compose.yml
└── .env

👁️ Preview

Internationalization not included!

• Youtube: https://youtu.be/XJMSeYHSzy0