shijith.k
Large Object feature of Postgres
Has anyone ever tried out the Large Object feature of Postgres?
I have a blob column in my table, and was wondering what data type to use, and that’s when I came across :bytea and this Large Object feature. Since :bytea is quite memory hungry as explained in the Postgres Documentation I was thinking about using Large Object. So, if anyone knows more about it, please help me out
Most Liked
frerich
I just published a new library for working with large objects in PostgreSQL: pg_large_objects | Hex
This makes it easy to stream data into/out of Postgres, e.g.:
# Stream enumerable into large object
{:ok, object_id} =
"/tmp/recording.mov"
|> File.stream!()
|> Repo.import_large_object()
# Stream data of large object into Collectable
stream = File.stream!("/tmp/recording.mov")
:ok = Repo.export_large_object(object_id, into: stream)
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"