Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

BLOB on Postgres are awesome, but there's also a full-featured file API called Large Objects for when the use-case requires seeking/streaming.

Wrote a small Go library to interface with it: https://github.com/mohamedattahri/pgfs

Large Objects: https://www.postgresql.org/docs/current/largeobjects.html



Large Objects works great for images and stylesheets and other file assets for my small PostgREST projects.


TIL thanks!




Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: