**
SQLite 10x faster than MySQL/PostgreSQL for local operations
**
SQLite is often underestimated as a professional-grade database, despite powering billions of applications (including Android, iOS, macOS, and even aviation systems). An SQLite node in n8n would be a game-changer for rapid prototyping and lightweight applications.
Proposed SQLite Node Features
| Feature | Use Case | Example |
|---|---|---|
| 1. Create DB File | Initialize new databases on-demand | n8n.db |
| 2. Upload Existing DB | Migrate or share SQLite files | Upload prod_backup.db |
| 3. CRUD Operations | Full transaction support | INSERT INTO users VALUES (…) |
| 4. Query Builder | Visual SQL for non-devs | Filter > Sort > Export |
| 5. Backup/Restore | Single-file snapshots | Backup to Google Drive |
Note:
- I found more projects that keep SQLite scale and replicated in other projects, hope to find the best in building this Node.
Thanks