System Architecture

System Architecture 🏗️

Localbase is design to be a single container application, meaning that every component will run on one docker container to increase resource efficiency when running.

Core Component 🛠️

• Frontend:

  • Build tool: Vite
  • Framework: React,
  • Styling: tailwind, shadcn/ui
  • Router: React Router
  • Data Fetching: Axios, TanStack Query

• Backend:

  • Language: Golang
  • Framework: Gin
  • Main database: PostgresSQL
  • Audit database: SQLite
  • ORM/SQL: GORM + sqlx

• Infrastructure:

  • Deployment: Docker
  • Demo and landing page host: self-host + Cloudflare

CI/CD Pipeline ♾️

Every code that has pass the PR will be automatically added via GitHub actions:

• Branch main: auto-deploy to a production environment
• Branch dev: auto-deploy to a development (production-like) environment

Security & Isolation strategy 🛡️

• SQL Injection Protection: Validate input field
• Project Isolation: Using table name prefix
• Tamper-proofing: ledger will be separated from postgres to avoid loosing data