Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
We used to store files as base64 strings in Postgres, but not anymore (mailpace.com)
7 points by albertgoeswoof on Sept 9, 2023 | hide | past | favorite | 2 comments


Large object (aka BLOBs) and bytea are also both options with Postgres over and above saving base64-encoded text.

That said, for email attachment storage, the article is right to consider separate file storage, though you must take take to keep the file store and DB in sync.


Yes, good point! We did actually consider that but realized it would just mean a bit of compression on that field in database - which would have helped, but not fully solved the problem.




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

Search: