🚀 Building a Tauri v2 + Drizzle + SQLite App — Starter Template

#tauri #drizzle #sqlite

🚀 Building a Tauri v2 + Drizzle + SQLite App — Starter Template

A complete starter template using Tauri v2, Drizzle ORM, and SQLite — with proxy-based queries, live previews, and working fullstack setup. No backend server needed.

✅ Unlike older tutorials, this one uses Tauri v2 and solves the JSON + proxy adapter problem.

📦 What’s Inside?

🧬 Drizzle ORM (sqlite-proxy mode)
🧱 SQLite for local database
⚡ Tauri v2 for native UI
🔁 Auto migrations on dev start
🧪 Working nested relations (Drizzle with: support)

🧑‍💻 Getting Started

git clone https://github.com/meditto/tauri-drizzle-proxy
cd tauri-drizzle-proxy
pnpm install
pnpm tauri dev

First time you run it, all migrations will run automatically.

🧠 If you modify your schema, run:
pnpm db:generate

🧠 How It Works

Drizzle ORM runs in sqlite-proxy mode. All SQL is sent to the Tauri backend via a custom run_sql command. The backend uses sqlx to execute the query and return JSON to your UI.

This repo adds:

✅ SQL type fallback for handling subqueries + JSON columns
✅ Custom SQLite row adapter to handle nested .with() queries
✅ Logs & dev-friendly debug output

🛠️ Tech Stack

Layer	Tech
UI	React + Vite
ORM	Drizzle ORM
Database	SQLite
Backend	Rust (`sqlx`)
Shell	Tauri v2

💡 What Was Fixed (vs Previous Attempts)

Previous attempts to integrate Drizzle ORM with Tauri (such as tauri-drizzle-sqlite-proxy-demo) relied entirely on the tauri-plugin-sql to run queries. This led to issues with relation loading—especially when returning empty records with nested relations.

This project takes a different approach:

✅ It uses tauri-plugin-sql only for database creation and migrations.
✅ It implements a custom Rust SQL proxy using sqlx, giving full control over query execution and serialization.
✅ It includes a workaround for Drizzle ORM's limitation: when a get query returns an empty array, we return an empty object to avoid breaking relation parsing.

This design ensures full relation support and reliable query behavior in a Tauri + Drizzle + SQLite environment.