菜单
Use when adding liteorm's embedded database studio (admin GUI) to an app — mounting the http.Handler, registering models for rich introspection, and locking it down.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Use when storing large or growing binary content (files, uploads, blobs) in SQLite as streamed io.ReaderAt/io.WriterAt instead of loading whole []byte — the orm.LOB field + liteorm.org/dialect/sqlite/lob.
Use when working with liteorm's declarative orm front-end — model structs and tags, AutoMigrate, the orm.Repo, associations (Load/Attach), hooks, or soft delete.
Use when liteorm code behaves unexpectedly, or proactively before writing it, to avoid the common gotchas around loading, soft delete, types, and dialect-gated operators.
Use when migrating a gorm codebase to liteorm — running models on gorm tags as-is, rewriting them to native orm tags, and adjusting for what differs.
Use when adding vector (sqlite-vec), full-text (FTS5), or hybrid RRF search to liteorm's SQLite backend.
Use when capturing, applying, inverting, or concatenating SQLite changesets (the SESSION extension) for audit logs, one-way replication, or undo — the liteorm.org/dialect/sqlite/changeset package. SQLite backend only.
| name | studio |
| description | Use when adding liteorm's embedded database studio (admin GUI) to an app — mounting the http.Handler, registering models for rich introspection, and locking it down. |
liteorm ships a database studio (a browser admin GUI) as a stdlib http.Handler you mount in your own server. It is a separate module — go get liteorm.org/studio — so it adds nothing to your build until you want it; no separate binary or service to run. Full docs live with the module (liteorm.org/studio).
import (
"net/http"
"liteorm.org/dialect/sqlite"
"liteorm.org/studio"
)
db, _ := sqlite.Open("app.db")
defer db.Close()
// Mount under any path; wrap with your own auth middleware.
http.Handle("/studio/", http.StripPrefix("/studio", studio.Handler(db,
studio.WithModels(&User{}, &Post{}),
)))
studio.Handler(db, opts...) returns an http.Handler. It works with any backend you've opened (*liteorm.DB); it does not open a connection itself. Visit the mount path with a trailing slash (/studio/).
studio.WithModels(&User{}, &Post{}, ...) — register your models so introspection is model-aware: belongs-to relations become navigable foreign keys, and Go types refine datatypes the catalog can't (a bool stored as SQLite INTEGER shows as a boolean). Optional but recommended; unregistered tables still work from the catalog.studio.WithReadOnly() — disable all writes (browse-only).studio.WithDisableSQL() — remove the raw SQL editor.studio.WithAI(fn) — enable AI features (NL filters, SQL generation, result charts, query analysis). fn is func(ctx, studio.AIRequest) (string, error) — LLM-agnostic; the studio passes the assembled prompt (schema context, no row data) and you return the model's text. The key stays server-side. See the guide for a Claude example.WithReadOnly() / WithDisableSQL() to narrow it.go get liteorm.org/studio / import "liteorm.org/studio". The library package depends only on the liteorm core; you pass it your already-opened *liteorm.DB.-tags studio_readonly to force read-only at compile time regardless of options — write endpoints refuse with a clear 403, import is off, and the raw-SQL editor refuses any non-read statement (including a write smuggled inside a WITH … CTE). studio.Hardened() reports it; /api/config shows "hardened": true. Seed the DB directly through liteorm before mounting — the lock only covers the HTTP surface.mux := http.NewServeMux()
// ... your app routes ...
mux.Handle("/admin/db/", requireAdmin(http.StripPrefix("/admin/db",
studio.Handler(db, studio.WithModels(models...)))))
http.ListenAndServe(":8080", mux)