go-portable-app

Build a Go binary with embedded frontend and SQLite backend.

6|1|Updated Dec 25, 2025
One-click install
npx skills add https://github.com/czyt/tinyskills --skill go-portable-app
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: go-portable-app
Source: https://github.com/czyt/tinyskills/tree/main/skills/go-portable-app
Command: npx skills add https://github.com/czyt/tinyskills --skill go-portable-app

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Go portable development that bundles frontend assets and a SQLite database into a single, cross-platform binary, simplifying deployment and distribution.

Core Features & Use Cases

  • Single-binary deployment: embeds frontend, configuration, and data into one executable.
  • Embedded frontend: serves prebuilt web UI from embedded assets at runtime.
  • SQLite with entsqlite: zero-CGO cross-compilation friendly database with WAL for concurrency.

Quick Start

Build the project with embedding enabled and run the produced binary on your target platform.

Frequently Asked Questions about go-portable-app

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a single-binary Go app with an embedded frontend and SQLite?

You build a single-binary Go app by embedding prebuilt frontend assets and configuring an SQLite backend using entsqlite. This requires an embed-enabled build process to bundle assets and data into one executable file for simplified cross-platform deployment.

Can I cross-compile a Go application with SQLite without using CGO?

Yes, you can cross-compile a Go application with SQLite without CGO by using entsqlite with the sqlite3 driver. This zero-CGO approach maintains cross-compilation friendliness and enables deterministic packaging across different operating systems.

What is the best way to serve an embedded web UI from a Go binary?

The best way to serve an embedded web UI is to embed prebuilt frontend assets into the Go binary and serve them at runtime. This single-binary deployment method simplifies distribution by packaging configuration, data, and frontend assets together.

Does this single-binary Go approach support dependency injection for modular architectures?

Yes, the single-binary Go approach supports dependency injection for modular architectures by offering options for Wire or fx. This allows you to maintain a modular codebase while deploying a portable application with an embedded frontend and SQLite backend.

How does SQLite handle concurrency in a portable Go application?

SQLite handles concurrency in a portable Go application by using WAL mode within the entsqlite framework. This zero-CGO configuration provides cross-compilation friendly database operations while supporting concurrent read and write access in a single-binary deployment.