@mro @lualang I don't exactly remember when I switched from flat files and #Racket to #sqlite, #CGI and #Lua, this post goes over more details:

https://andregarzia.com/2025/03/why-i-choose-lua-for-this-blog.html

The post includes a description of the stack. Basically, it is a Caddy server with a CGI module that spawns PUC Lua 5.3 for each request. The CGI gets the post from a SQLite file and assembles the HTML back using mustache templates.

I use many modules cause of my admin needs, this is a list of the modules from my install script but I think I might have installed some others manually.

* cmark
* dkjson
* etlua
* hasher
* lsqlite3
* lua-markdown-extra
* lua-djot-extra
* luafilesystem
* lub
* lustache
* multipart
* penlight
* uuid
* yaml
* http
* gumbo
* sleep
* bbcode
* cookie

Most modules installed via Luarocks.

SQLite Is All You Need

https://www.dbpro.app/blog/sqlite-is-all-you-need

#sqlite

I updated #gotosocial to 0.22-rc4 and turned on post expiration and now I'm seeing errors sqlite3: database disk image is malformed

Does anyone have a fix for this? I tried running sqlite3 recovery but that broke the web interface somehow and I had to rollback

Any help would be appreciated to save this instance. I'm uneasy with running a database that has errors long term, even if I disable post expiration

#homelab #selfhosted #sqlite