User avatar
Andrew Nesbitt @andrewnez@mastodon.social
5mo
Instead of using git as a database, what if you used database as a git?

nesbitt.io/2026/02/26/git-in-postgres.html
2
1
1
0
User avatar
luna the doggie neofox_snug therian @lunareclipse@snug.moe
5mo
@andrewnez actually I would argue storage efficiency is important for making it accessible to self-host.

If you don't have a bunch of disposable income to put towards a homelab, storage really isn't very cheap. Especially now that prices of everything have doubled or tripled due to AI datacenter demand.

Renting a VPS with more than 20-50GB of storage gets expensive very fast. Too expensive for many people.

Using an old PC for hosting can sometimes be an option but that will have reliability issues, and you probably won't have more than like 1TB of space available then anyway. Also dependent on your ISP giving you public IPs.
1
0
0
0
User avatar
Doomfrent Curdles @diffrentcolours@tech.lgbt
5mo
@lunareclipse @andrewnez I'd be interested to know if anybody's explored how effective it is to run Postgres on a deduplicating filesystem like ZFS or brtfs.

Hopefully, it might be that this is a non-issue in practice without having to build deduplication or delta compression into Postgres directly.
2
0
1
0
User avatar
walnut 🌱 @walnut@thesoftestpaws.net
5mo
@diffrentcolours @lunareclipse @andrewnez
I don't know much about this, but it seems like the tradeoffs/gains would need to be measured on a case by case basis still

despairlabs.com/blog/posts/2024-10-27-openzfs-dedup-is-good-dont-use-it/
0
0
1
0