Fullstack Next.js Template

A production-ready fullstack template with Next.js 15, Tailwind CSS v4, shadcn/ui, SQLite, and Docker.

Tech Stack

Layer	Technology
Framework	Next.js 15 (App Router, Turbopack)
Styling	Tailwind CSS v4 + shadcn/ui
Database	SQLite (via better-sqlite3 + Drizzle ORM)
Language	TypeScript (strict mode)
Deployment	Docker (multi-stage, standalone output)

Project Structure

src/
├── actions/ # Server Actions (type-safe DB operations)
│ ├── user.actions.ts
│ └── post.actions.ts
├── app/
│ ├── api/ # REST API routes
│ │ ├── users/route.ts
│ │ └── posts/route.ts
│ ├── layout.tsx # Root layout (ThemeProvider, fonts, Toaster)
│ ├── page.tsx # Dashboard with CRUD demo
│ └── globals.css # Tailwind v4 + shadcn theme
├── components/
│ ├── ui/ # shadcn/ui components
│ ├── user-form.tsx
│ ├── post-form.tsx
│ ├── user-list.tsx
│ ├── post-list.tsx
│ └── delete-button.tsx
├── db/
│ ├── schema.ts # Drizzle ORM schema (users, posts)
│ ├── index.ts # Database connection
│ ├── migrate.ts # Migration runner
│ └── seed.ts # Seed script
└── lib/utils.ts # Utility functions (cn helper)

Getting Started

Development

# Install dependencies
npm install
# Generate migration files after schema changes
npm run db:generate
# Run migrations
npm run db:migrate
# Seed sample data
npm run db:seed
# Start dev server
npm run dev

Docker Deployment

# Build the app image
docker build -t fullstack-app .# Build and run migrations
docker build -t fullstack-migrate -f Dockerfile.migrate .
docker run --rm -v app-data:/data fullstack-migrate
# Seed the database (optional)
docker run --rm -v app-data:/data --entrypoint "" fullstack-app npm run db:seed
# Run the app
docker run -p 3000:3000 -v app-data:/data fullstack-app

Database Commands

Command	Description
npm run db:generate	Generate SQL migration from schema changes
npm run db:migrate	Apply pending migrations
npm run db:seed	Insert sample data
npm run db:setup	Migrate + seed in one command

API Endpoints

• GET/POST /api/users — List or create users
• DELETE /api/users?id=1 — Delete a user
• GET/POST /api/posts — List or create posts
• DELETE /api/posts?id=1 — Delete a post