Tanggung deh, kita bikin dashboard #grafana nya #litestream.

Lumayan jadi bisa sekalian pantau ukuran #sqlite nya #gotosocial instance ini.

Comment je sécurise mes services : ma stratégie de sauvegarde multi-niveaux sous Proxmox

https://blablalinux.be/2026/03/27/ma-strategie-sauvegarde-proxmox/

Lapor kong @kongtol

#sqlite nya #gotosocial dah kelar dibikin replikasinya pake #litestream sesuai petunjuk dari doc-nya gts.

Rails 8과 Kamal을 이용한 Hetzner 서버 배포 완벽 가이드

Rails 8의 Solid Stack과 SQLite를 활용하여 외부 데이터베이스 의존성 없이 단일 전용 서버에서 프로덕션 환경을 구축하는 전체 과정을 다룬다.

🔗 원문 보기

Turbolite – a SQLite VFS serving sub-250ms cold JOIN queries from S3

https://github.com/russellromney/turbolite

#HackerNews #Turbolite #SQLite #VFS #S3 #JOINqueries #DatabaseOptimization

Show HN: Turbolite – a SQLite VFS serving sub-250ms cold JOIN queries from S3

https://github.com/russellromney/turbolite

#github #sqlite

Wow sqlite has CTE queries!
This improves readability a lot.

I've used CTE queries in clickhouse before and it was a charm. Especially in combination with our nasty python f-string formatting back then.

Sqlx does not seem to like the single row paradigm too much though.
But for now implementing the From trait into transfer objects isn't too bad. At least the query is precise and easy to understand.

#rust #sqlx #sqlite #cte