🚀 Sqlite

📚 Table of Contents

• 🚀 Sqlite
  • 📚 Table of Contents
  • 📖 1. Overview
  • ✨ 2. Features
  • 🎥 3. Demo
  • 🚀 4. Usage
  • 🛠️ 5. Development Stack
    • 🖥️ 5.1 Development Tools
    • ⚙️ 5.2 Monorepo
    • 💻 5.3 Application
      • ⚛️ 5.3.1 Front-end
      • 📡 5.3.2 Back-end
    • 📟 5.4 CLI (Command-line Interface)
  • 📄 6. License

📖 1. Overview

Sqlite is a focused project in this monorepo that delivers a practical tool with a clean user experience across platforms.

✨ 2. Features

1. Core functionality tailored to Sqlite
2. Web experience for quick access
3. CLI distribution for automation workflows
4. Mobile-ready build targets
5. Desktop-ready build targets

🎥 3. Demo

• 🌐 Live Demo

🚀 4. Usage

• 🌐 Web
• 💻 CLI
• 📱 Mobile
• 🖥️ Desktop
  • 🍎 MacOS
  • 🐧 Ubuntu
  • 🪟 Windows

🛠️ 5. Development Stack

🖥️ 5.1 Development Tools

No	Group	Technology	GitHub	Download
1	IDE	Antigravity		Download
2	IDE	Cursor	GitHub	Download
3	Agent	Claude	GitHub

⚙️ 5.2 Monorepo

No	Group	Technology	GitHub
1	Git	GitHub	GitHub
2	Git Hooks	Husky	GitHub
3	Build	Turborepo	GitHub
4	Dependencies	Renovate	GitHub

pnpm install --save-dev --save-exact husky turbo 

💻 5.3 Application

⚛️ 5.3.1 Front-end

No	Group	Technology	GitHub
1	Language	TypeScript	GitHub
2	Runtime	Node.js	GitHub
3	Packages Manager	pnpm	GitHub
4	Linter	ESLint	GitHub
5	Formatter	Prettier	GitHub
6	Testing	Jest	GitHub
7	Framework	Next.js	GitHub
8	Styling	Tailwind CSS	GitHub
9	UI	DaisyUI	GitHub
10	Desktop	Tauri	GitHub
11	Mobile	Capacitor.js	GitHub
12	Hosting	GitHub Pages	GitHub

# 1. Node.js
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.40.4/install.sh | bash
nvm install
# 2. TypeScript
pnpm install --save-dev --save-exact @types/node ts-node typescript
# 3. Linter
pnpm install --save-dev --save-exact eslint
# 4. Formatter
pnpm install --save-dev --save-exact prettier prettier-plugin-tailwindcss
# 5. Testing
pnpm install --save-dev --save-exact @types/jest jest jest-environment-jsdom ts-jest
# 6. Styling
pnpm install --save-dev --save-exact @tailwindcss/postcss tailwindcss daisyui
# 7. Tauri
pnpm install --save-exact @tauri-apps/api
pnpm install --save-dev --save-exact @tauri-apps/cli
# 8. Capacitor
pnpm install --save-exact @capacitor/core @capacitor/android @capacitor/ios
pnpm install --save-dev --save-exact @capacitor/cli

📡 5.3.2 Back-end

No	Group	Technology	GitHub
1	BFF	tRPC	GitHub
2	ORM	Prisma	GitHub
3	KV	Redis	GitHub
4	JSON	MongoDB	GitHub
5	SQL	PostgreSQL	GitHub
6	Auth	Auth.js	GitHub
7	Email	Resend	GitHub
8	Payment	Lemon Squeezy	GitHub

# 1. tRPC
pnpm install --save-dev --save-exact @trpc/server @trpc/client @trpc/react-query @trpc/next @tanstack/react-query@latest zod
# 2. Prisma
pnpm install --save-dev --save-exact prisma prisma-dbml-generator prisma-json-schema-generator
# 3. Redis
pnpm install --save-exact redis
# 4. Auth.js
pnpm install --save-exact next-auth
# 5. Email
pnpm install --save-exact resend
# 6. Payment
pnpm install --save-exact @lemonsqueezy/lemonsqueezy.js

📟 5.4 CLI (Command-line Interface)

No	Group	Technology	GitHub
1	Language	Golang	GitHub
2	Framework	Cobra	GitHub
3	TUI	BubbleTea	GitHub

# 1. Cobra
go get -u github.com/spf13/cobra@latest
# OR
go install github.com/spf13/cobra-cli@latest

📄 6. License

GNU General Public License - Version 3 (GPL-3.0)