database

package

v0.12.0 Latest Latest Go to latest Published: Aug 6, 2026 License: MIT Imports: 19 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/lbe/sfpg-go

Links

Open Source Insights

Documentation ¶

Overview ¶

Package database wires SQLite connection pools and database lifecycle for the server.

Index ¶

func RecreatePoolsWithConfig(ctx context.Context, paths DatabasePaths, cfg *config.Config, ...) (*dbconnpool.DbSQLConnPool, *dbconnpool.DbSQLConnPool, error)
type DatabasePaths
- func Setup(ctx context.Context, rootDir string, cfg *config.Config) (DatabasePaths, *dbconnpool.DbSQLConnPool, *dbconnpool.DbSQLConnPool, error)

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func RecreatePoolsWithConfig ¶ added in v0.3.0

func RecreatePoolsWithConfig(ctx context.Context, paths DatabasePaths, cfg *config.Config, oldRwPool, oldRoPool *dbconnpool.DbSQLConnPool) (*dbconnpool.DbSQLConnPool, *dbconnpool.DbSQLConnPool, error)

RecreatePoolsWithConfig closes old pools and creates new ones with the given config. This is used when configuration is loaded after initial pool creation to honor database-stored pool settings during startup.

Types ¶

type DatabasePaths ¶ added in v0.3.0

type DatabasePaths struct {
	Main   string // Path to sfpg.db
	Thumbs string // Path to thumbs.db
}

DatabasePaths holds the file paths for both application databases.

func Setup ¶

func Setup(ctx context.Context, rootDir string, cfg *config.Config) (DatabasePaths, *dbconnpool.DbSQLConnPool, *dbconnpool.DbSQLConnPool, error)

Setup initializes the database environment: 1. Sets up the directory struct 2. Runs schema migrations 3. Establishes connection pools (RW/RO) 4. Ensures root folder entry exists 5. Schedules periodic optimization

Source Files ¶

View all Source files

app.go

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL