Skills
.Work. You
Rest

sqlite-best-practices

Community

Master SQLite usage in Go for fast, safe apps.

Software Engineering#indexing#go#sqlite#transactions#schema-design#pragmas#database/sql
Authorbillybbuffum
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill guides Go developers in applying SQLite best practices to ensure robust data storage, correct schema design, and high-performance queries in local or embedded applications.

Core Features & Use Cases

  • Connection hygiene and PRAGMAs for better concurrency and reliability
  • Proper data types and money handling (using INTEGER for monetary values)
  • Safe transactions, indexing strategies, and common anti-patterns to avoid
  • Use Case: optimize a Go project that uses SQLite for offline storage, dashboards, or local services

Quick Start

Set up a Go project with a SQLite database, enable WAL mode and foreign keys, and implement a small repository using database/sql and mattn/go-sqlite3. Validate basic CRUD performance and correctness with simple tests.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sqlite-best-practices
Download link: https://github.com/billybbuffum/budget/archive/main.zip#sqlite-best-practices

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.