Arch-System

A Next.js application with local SQLite database and authentication - works completely offline.

Features · Clone and run locally

Features

• Works across the entire Next.js stack
  • App Router
  • Server Components
  • Client Components
• Local SQLite database (via better-sqlite3)
• JWT authentication (via jsonwebtoken)
• Password hashing with bcrypt
• Styling with Tailwind CSS
• Components with shadcn/ui
• No external services required - works completely offline

Clone and run locally

1. Clone the repository:

   git clone <repository-url>
   cd arch-system

2. Install dependencies:

   npm install

3. Set up environment variables:

   cp .env.example .env

   The .env file only needs a JWT secret (optional - a default is provided):

   JWT_SECRET=your-secret-key-change-in-production

4. Initialize the database and create admin user:

   node scripts/create-admin-user.js

   This will:

   • Create the data directory
   • Initialize the SQLite database at data/arch-system.db
   • Create an admin user with credentials:
     • Username: Admin@123#
     • Password: Yugioh@123#
     • Email: admin@arch-system.local

5. Run the development server:

   npm run dev

   The application should now be running on localhost:3000.

Deployment

Linux / macOS

./deploy.sh

Windows

deploy.bat

These scripts will automatically install dependencies, set up the environment, initialize the database, build the project, and open your browser to the login page.

Database Architecture

• SQLite (via better-sqlite3) for local data storage
• JWT (via jsonwebtoken) for authentication
• bcrypt for password hashing

The database file is stored at: data/arch-system.db

For detailed setup instructions, see LOCAL_DEPLOYMENT.md.