How does this skill handle TypeScript type safety?

It demonstrates the use of Bun's specific extensions for query preparation, allowing you to define types for both input parameters and returned row objects.

Does this skill support in-memory databases?

Yes, it provides patterns for initializing both persistent file-based databases and high-speed in-memory instances using the ':memory:' string.

Does it support database backups?

Yes, it provides methods for serializing and deserializing databases to and from buffers, facilitating easy backup and restoration workflows.

Can I use this for high-concurrency applications?

Yes, the skill includes specific instructions for enabling WAL (Write-Ahead Logging) mode and optimizing PRAGMA settings to improve concurrent access performance.

What is the difference between .run(), .get(), and .all()?

The skill clarifies that .run() is for modifications (INSERT/UPDATE), .get() retrieves a single row, and .all() fetches all rows as an array of objects.

Bun SQLite

Name: Bun SQLite
Author: secondsky

bysecondsky

•

数据库管理

Integrates high-performance local data storage and management using Bun's native SQLite driver.

关于

The Bun SQLite skill empowers Claude to implement and optimize data persistence within Bun environments using the high-performance `bun:sqlite` module. It provides patterns for efficient schema design, prepared statements, and advanced transaction handling, ensuring developers can build fast, reliable local databases. Whether you are creating a lightweight backend, a CLI tool, or an edge-side application, this skill offers the best practices for leveraging SQLite's full potential within the Bun ecosystem, including performance tuning via PRAGMA settings and Write-Ahead Logging (WAL).

主要功能

Performance tuning via WAL mode and specialized PRAGMA settings
Support for prepared statements with positional and named parameters
Comprehensive transaction management with deferred and exclusive locking
21 GitHub stars
Optimized data mapping for BigInt, Uint8Array, and typed query results
High-performance native driver integration with bun:sqlite

使用场景

Implementing persistent data layers for lightweight backend services
Building high-speed local storage for Bun-based CLI applications
Prototyping database schemas with fast in-memory SQLite instances

关于

主要功能

Performance tuning via WAL mode and specialized PRAGMA settings
Support for prepared statements with positional and named parameters
Comprehensive transaction management with deferred and exclusive locking
21 GitHub stars
Optimized data mapping for BigInt, Uint8Array, and typed query results
High-performance native driver integration with bun:sqlite

使用场景

Implementing persistent data layers for lightweight backend services
Building high-speed local storage for Bun-based CLI applications
Prototyping database schemas with fast in-memory SQLite instances