Images storing techniques

From: Riccardo Gobbo <riccardo(dot)gobbo(dot)2(at)studenti(dot)unipd(dot)it>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Images storing techniques
Date: 2023-03-29 21:29:45
Message-ID: CAOYha2EGumQ3OpaYrJETdsPjZRG7Pyq3OJpsZOT=mh5NBGU6sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Good evening,
I'm a Master degree student at University of Padua in Italy and I'm
developing a web application as assignment for the Web application course.

Context: the Web application that my group is developing would ideally be
used to manage county side fairs where there would be foods and drinks,
these displayed into a digital menu.
The application uses postgre to implement a database where stores data,
mostly strings as emails and orders but also some images (representing the
dishes).
The web pages are created using java servlets and jbc

Question: for better performance is it better to store images as BYTEA or
convert every image in base64 and store the generated string (so in html
it's enough to insert the base64 string in the tag)?
Converting an image in base64 would use a 30% more memory than storing
directly the image's bytes, but I don't know if working with characters
rather than bytes could have more prons than cons

Thank for the time you dedicated for the answer and I apologize both for
disturbing you and my English.

Best regards, Riccardo.

Computer Engineering
Mat. 2082156

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2023-03-29 21:48:19 Re: Temporary tables versus wraparound... again
Previous Message Bruce Momjian 2023-03-29 21:21:00 Re: is_superuser is not documented