Re: Images storing techniques

2023-03-30 Thread Bruce Momjian
On Thu, Mar 30, 2023 at 11:30:37AM +0200, Gaetano Mendola wrote: > I would suggest to store your images in a file system and the store paths to > those images. > > You can keep files and entries in your database synced via triggers/stored > procedures (eventually written in python since pgsql does

Re: Images storing techniques

2023-03-30 Thread Peter Eisentraut
On 29.03.23 23:29, Riccardo Gobbo wrote: 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 mem

Re: Images storing techniques

2023-03-30 Thread Gaetano Mendola
I would suggest to store your images in a file system and the store paths to those images. You can keep files and entries in your database synced via triggers/stored procedures (eventually written in python since pgsql doesn't allow you to interact with the file system). On Thu, Mar 30, 2023, 11:

Images storing techniques

2023-03-30 Thread Riccardo Gobbo
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 dr