| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Gaetano Mendola <mendola(at)gmail(dot)com> |
| Cc: | Riccardo Gobbo <riccardo(dot)gobbo(dot)2(at)studenti(dot)unipd(dot)it>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Images storing techniques |
| Date: | 2023-03-30 15:15:36 |
| Message-ID: | ZCWnmGyRV1HBULGY@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 doesn't allow you to
> interact with the file system).
You might want to read this blog entry:
https://momjian.us/main/blogs/pgblog/2017.html#November_6_2017
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Embrace your flaws. They make you human, rather than perfect,
which you will never be.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2023-03-30 15:55:25 | Re: Transparent column encryption |
| Previous Message | Jelte Fennema | 2023-03-30 15:11:18 | Re: running logical replication as the subscription owner |