Neither Docs nor Readme of gitea-helm do reflect possible SQLite settings #14279

New Issue

GiteaMirror · 2025-11-02T11:08:23-06:00

GiteaMirror commented

2025-11-02 11:08:23 -06:00

Originally created by @wethinkagile on GitHub (Mar 20, 2025).

Description

When activating SQLite for our K8s/Helm setup, it is poorly documented what settings are possible (1)

When looking at source code (2) I found that a whole lot of database settings would be possible, however it is unclear to me which one. Can someone help to single out the SQLite ones, and then I would PR into readme file of gitea-helm repo and according gitea docs, ie. of app.ini.

		Type               DatabaseType
		Host               string
		Name               string
		User               string
		Passwd             string
		Schema             string
		SSLMode            string
		Path               string
		LogSQL             bool
		MysqlCharset       string
		CharsetCollation   string
		Timeout            int // seconds
		SQLiteJournalMode  string
		DBConnectRetries   int
		DBConnectBackoff   time.Duration
		MaxIdleConns       int
		MaxOpenConns       int
		ConnMaxLifetime    time.Duration
		IterateBufferSize  int
		AutoMigration      bool
		SlowQueryThreshold time.Duration

This issue was first discussed at helm-gitea repo (3).

Gitea Version

1.23.4

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

Linux

How are you running Gitea?

Kubernetes Helm

Database

SQLite

Originally created by @wethinkagile on GitHub (Mar 20, 2025). ### Description When activating SQLite for our K8s/Helm setup, it is poorly documented what settings are possible[ (1)](https://gitea.com/gitea/helm-gitea#single-pod-configurations) When looking at source code[ (2)](https://github.com/go-gitea/gitea/blob/main/modules%2Fsetting%2Fdatabase.go) I found that a whole lot of database settings would be possible, however it is unclear to me which one. Can someone help to single out the SQLite ones, and then I would PR into readme file of gitea-helm repo and according gitea docs, ie. of app.ini. ``` Type DatabaseType Host string Name string User string Passwd string Schema string SSLMode string Path string LogSQL bool MysqlCharset string CharsetCollation string Timeout int // seconds SQLiteJournalMode string DBConnectRetries int DBConnectBackoff time.Duration MaxIdleConns int MaxOpenConns int ConnMaxLifetime time.Duration IterateBufferSize int AutoMigration bool SlowQueryThreshold time.Duration ``` This issue was first discussed at helm-gitea repo[ (3)](https://gitea.com/gitea/helm-gitea/issues/831 ). 1. https://gitea.com/gitea/helm-gitea#single-pod-configurations 2. https://github.com/go-gitea/gitea/blob/main/modules%2Fsetting%2Fdatabase.go 3. https://gitea.com/gitea/helm-gitea/issues/831 ### Gitea Version 1.23.4 ### Can you reproduce the bug on the Gitea demo site? Yes ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System Linux ### How are you running Gitea? Kubernetes Helm ### Database SQLite

GiteaMirror added the type/bug label 2025-11-02 11:08:23 -06:00

GiteaMirror commented

2025-11-02 11:08:24 -06:00

@lunny commented on GitHub (Mar 28, 2025):

I think this should be a documentation improvement at https://docs.gitea.com/administration/config-cheat-sheet#database-database

@lunny commented on GitHub (Mar 28, 2025): I think this should be a documentation improvement at https://docs.gitea.com/administration/config-cheat-sheet#database-database

GiteaMirror commented

2025-11-02 11:08:24 -06:00

@wethinkagile commented on GitHub (Mar 28, 2025):

..found that a whole lot of database settings would be possible, however it is unclear to me which one. Can someone help to single out the SQLite ones..

@wethinkagile commented on GitHub (Mar 28, 2025): > ..found that a whole lot of database settings would be possible, however it is unclear to me which one. Can someone help to single out the SQLite ones..

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/gitea#14279