What about binary blobs? I hate having to store them outside of the database and... | Hacker News

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

Ambolia on Dec 7, 2024 | parent | context | favorite | on: How to use Postgres for everything

What about binary blobs? I hate having to store them outside of the database and that you can't just do a dbdump/import to clone a project.

taffer on Dec 7, 2024 [–]

Have you had a look at the bytea[1] type? It allows you to store binary objects up to 1GB and it's dumped transparently just like a string.

[1] https://www.postgresql.org/docs/current/datatype-binary.html

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