Implements SQLite database operations in Bun using the built-in bun:sqlite driver.
npx skills add https://github.com/aicodepro/ai-agent-nexi --skill bun-sqlite-aicodepro
Please help me install this Agent Skill. Skill: bun-sqlite Source: https://github.com/aicodepro/ai-agent-nexi/tree/main/agent/skills/bun-sqlite Command: npx skills add https://github.com/aicodepro/ai-agent-nexi --skill bun-sqlite-aicodepro
High-intent search queries and answers about installing and using this skill.
Import Database from bun:sqlite, create an instance with a file path or :memory:, then run queries with db.run() for writes and db.prepare() for reads. No external packages are required since the driver is built into Bun.
Call db.prepare() with your SQL, then execute with .get() for one row, .all() for all rows, or .run() for writes. Parameters can be positional (?) or named ($name, :name, @name) passed as objects.
Yes, db.transaction() wraps a function into an atomic transaction. You can control locking behavior with .deferred(), .immediate(), or .exclusive() modes depending on concurrency needs.
These errors occur from concurrent write access to the database file. Enable WAL mode with PRAGMA journal_mode = WAL to allow readers and one writer simultaneously, and add retry logic for busy states.
Yes, db.prepare accepts generic type parameters for row shape and parameters, so stmt.get() returns a typed object or null. This gives compile-time safety without an ORM.
lexicalninjaDesign database schemas, migrations, and data access layers for applications.
paunchygentInstrument services with Prometheus metrics and expose a /metrics endpoint.
Impertio-StudioDiagnose and optimize slow MariaDB queries using logs, EXPLAIN, and performance schema.
AdigunQIntegrate Next.js with Supabase and Drizzle ORM for type-safe database operations.
