From: Tobias Bussmann <t.bussmann@gmx.net>
Content-Type: multipart/mixed;
	boundary="Apple-Mail=_EE1C591E-CC76-4262-BD74-1B7E5ED799C2"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.10\))
Subject: Images in news mails
Message-Id: <99A6E7C8-1634-4162-96FD-D5AC404ADBCF@gmx.net>
Date: Thu, 4 Sep 2025 21:49:01 +0200
To: pgsql-www@lists.postgresql.org
UI-OutboundReport: notjunk:1;M01:P0:1B0FqLGvZyU=;nZ6HU8lYNWUb7rlQAi1EZZHJl/P
 6BKi10zdxserwBus0SG4ZZKC4EZwxk/TV6TERO6tz/F48G37+v42wD3ls193H1DpmuTrngn+k
 9+GJM6JWLKHCxilSd1Z4R/jsMQsNSvsSQmdV1iR+BvzpW/z6nilDzEXPzE92lVqM4BM2GIHMZ
 qXZPgTaw0QdieL7fR7Z0Y6cQCDDZEevb4uGszBWdjHZXvN/dpswXKP2oYVDH9nwp0E8LRuZq+
 KgVn9+9m1rh4INvCV2k3ZpeVkVSfsvjn6/ETb3vl06dHnV+RaNXe7wDMpc7vJzQIxR0bgI+2t
 E/CwYGpEQ65vjODjGWs/dVFIA5pV7xPgBWcBu5+DPpjcFUx/As3Kj4L/C6jmsgU0oV57TZxAz
 VUvjUJnq9j87wl1Cxos/v5huLnU4vKV7I3AxVh2wTNq9WU4DocuNNi9nQxGJ66NftsIcSft41
 yzlwmjCX5eN8ntmPZDiyUMKeWTiwPtmkvHE1lb98B+qIaJTGKOzb8yZAhM1rvQaMoQ54/82H/
 f7kEKT2PVsLhaU9AbgFT+3126OygAcK4vsplNeYzCiUF7MAaPSvqhPzwmyBYQxhEtUkoEyAT9
 dkLVc+hfhhbGwXXjuwOu6q+ZL4C++38rpNn2YEFpESWuDDMVb6TTVRyCm9OWjmXoT/4siQ3oM
 CmF1TosMIImYyG/kno53yZnSLGGMB4xwB0RxYYVWkx7Kqx7UO7jFfD2YqyF8fQt6nNaRZqFdG
 EzNhbm2UQP2EoEkob+Fq34wSoT99RoHhPhv/lCv24jKfK1LGQhjphkSA7ELUSMABArub79+A4
 3J/AbYOZmoy1VNq0q/5g/mxw9gChFDtT+dKNfLgoP1jlsSp+2RW3D7V6OTFUhADc250kdjb5/
 rLHdoShyic+HhMBzm1Olyl1DY14/dCqvJXeZeqFYWOe+EvBiufYIcM1ZR4paARbvdLLi2jyWN
 YNPtq0wMkRWXMr22i1kvNLBqh/AsYHA+jFx7HvH8YybenLleoex48ucgF8q00jmIPvxiNUEUG
 eb7Xckvx/eYygXM3yMBX6ldf2fxgWBXJ5719yG9Kix5sGwck2QxDTNGk1eGauH+0QiOVqn1O+
 7xjXxtnv1Npu11slJVN4lwkHXLPb3s35076j/LIOHHQZ2nygmDZ0TtuLI+bpNkGgyLSD/WezF
 77ZfYs0KfJ8xdIWfjBdvWth6+p8S08d5EDL7ABm0xQP4J99ocdM5xK2Ii8VBcySzJHm9mNFF4
 EpgTDNTJL6YPUg82ItX39k6ifkgYECW8GlzZ/ptGQwFCgip/t2dT/L9nP0n+IbOeIA4XAg1/q
 pwSrRhTctDuV2V1BPBHp8eHQf65zACs+9y1GkjV3rf8JHTKL7G9JAlkwlxT5AZFvhe3qgubjO
 TjTB7McEvh076txnd9dL2CkPFnA9H4IN3P+olPHfSlS5cgdDBeXogBg+BysSCBuuH/xGJN2/h
 7CWSkoStO55T7RAX3jSuWnnQERWi44G2csnGdzFJCKsvJSIvpE3TfHjcK7Cj7pt5d6hdxX4Rt
 V9pKoNqfYkTahJaJWgo+p2Zb/VrZ90wc7AZrc1mL27zrTojYbJt0DTPfHiu4dWTKMLInNVvSc
 hOAM4xhL+SuzBC6DoVDvk8vNsWwkjTIjM7ZUWH46IA/GM80jGGC4cXqtA1zceWUX7T1eHAUak
 Fqvc3i443CZtib27wot+d6jQzuiWYNyzlj25drQP35v5XaXRXgz7vGh+F0gVm1C9BCoRt5Neo
 /S2gQQ+oOv6PA5yovP8zXuwdDfixqqrrmGqbBf8KYeusDut/iDTupkD1MgaDKHRTPYnq+O6Si
 +Vl1CgQ8Z1/Oc7EAVzmOAhFSkKpumx4+NKgmorEWkZNO2I771lt74NUsuTVpdt/lE53cvEVKd
 BjaeBZMcJ3x6xUnaTAAguLhgSS7Zd6cjnizdPAUQ29C7GXYHKzuajkld1KH/y/Q9yZ9gJ6yBk
 jhiasqHOVdMrd1N7qFiE0T+/dD7TT7bjmpEr6EEb+i+evcgkNzHQ9quL25Dp61oyxhhQZhc5j
 j/lX0W9OZQcrhDj/R9YgxDr0fZ3hcEHDZk2Zk5oo8RcEXnFe/VAuE4E+uBV6ghVJSl2D5OGI6
 AQWcaZU0KE+0dAz/6Ihcs1SK6sGlXEjB3g93lrX/Hm70xFolIR1XEJ6teEJZDikn0e1yk0FV2
 X6i3qIKsoATZjZwkr//AdSksT5MoE65DX0CrZQxDT0PD7TMlhjV6PeKnBt0Bm0gy1DlsQPxsQ
 1lZLQoDMB2eFEMOEgpkEriv5rKz33WsLJLKkEkLOf6/L5S2XtOpU11gn86BkgBwYZBJZwgDpA
 1uCtrQdQDPj/cUq0FoeGMnWJThwFG0LnRN33Cx7b/HPP+ZMr9vKNKFFllWM+7Y6oPZYTNz5Wq
 kF5RUHbpErAMYbSrBIqQfCDnJZp3wYaR4z3sWnb92GFOdGqVuV/dKZol8MmayYBs8ALLR0Ewp
 voB8KwIvuiqMki1dXale0mYRQ7TSFakLh3G47nV9NzQd1JxaG8pYo1K7IqI9cagCAczi4/70P
 aD0xM0k4JnYkX7Ag3Mz00yTqzJlJUP+4TZyXDhNLHbuStdYj6QyTw0Op0xTRENPRvK9Y5Ov+6
 j3AOE6J8SwpH9oRzGQyb3YGta/tJJn7x9+g2KARcbJV0ehsh9hd1I4qItCi6JsK6KaYO2rjnM
 QYbjxOncfI0D0HEuq16zFVR4S8rlxcJoNbFBudv5G4e1/IdP4kwYhKdV5DeTc6/+ePpyUDRzj
 VoV4AMzGumbHJxMJaNktOdVzA0SwZp9wjoNh2PN7TMGIhkkXlOlyyyY5HjqgBuNuWt/C3h3vv
 IBsJ3g2kYfwD6npe3oYs72XVciAzoMT3MIvgWa0XR5/3kldPIGfbADlkZ+JDWvWaRE5zxlTHN
 OhbHIaanOVSz4ygzcuAYYAw+hewikw0U3AM40PFTlKShb7N/9x925/xAagoWXntTVx3jusA8C
 qr6jljYhECpZlM6IRmhH1BylMtsZg/KayBN/1hoPJSMm2Q1NOI94mrFzsLuTsdcYwzL4EqvUZ
 GiHq7zgFM2/odf5nhEcvpx9wVbVpw3mVFJB3Tt4tC1RBeaF1qhNc913F6REA4mPlW9wgxcm7I
 oJYXBUNHj9Rvu5Xq5pJZUrLig3G3VLe9e+KbgWdszsHHv91oO/mT/UYA8E0Q2pEjGQeZVdAqN
 YYphVMOERGwjnLPLrv7sxzjwMbqw08JqvUo9HMFzUcq+BYxbSGBRs/09cARQTv/LtVITSuF1J
 10BHyH0rFceE+NJV7T1ED7G0NbIY5mIZ+FzHI58DmKmMRsz4wTQxSz7hJOA+IaJXcBveLk5Lq
 7JWHwzYD1oW8bcZhX6uNB+NgQMoqoJ2bFgECQSh9/FYLFCBnKNbAagQs2Hy3a/2bIcHx+E7bF
 fRjRJV17hbRVjpUhPLEYo9HNkq+EthNm3m+Ssxf8u3Y5N1nmCVz92q/+DD6BDRGHEHgEG8lKV
 C2zZUI3uuW10Z5F4lcOQFPSpMruvMOtjgN9cbEHA6yRt+ML5s3Kqva9jOP803eDxTGVzurp0N
 fvF6eJC/fKv6NJ2iCoCRYd1AyIQfuSGD7392ExQYktahqfP68bg0SutcBChTV/crYBDb7s1Vo
 O7LocgZ2YiWqRIP3/BVmoDYO76KiIuN2u0FIRzx2KfAnlAIbxrArZolzBNBzd+YZTH/3/JX2J
 D7ydcmiQvQfJFyY3rwyh57cloz98xvcfkqNgFBo2tX91TpABgQjzXMnSFIZDEnJ+aXsL5/I9E
 I4r2mZAwZOHrB1+lcc8TBi5C4w/eVtTYBkDrQdUel3Q0CxGMhZuYx3rj27jGwlSRzqbXsZfsQ
 pTAJLPbXogVUMEMtse/1Qu0KN9WNn5W15WDj2irUK51ubIWG2Fmzu7YCn9Q4uhMYAV32cuaz7
 qW5GuguhzFIortgL1IYyrgA1ge2DQzXL1ODVon3EYSpjvJyO78D0cAXNijkB4v29MZVQUDV3t
 wR1mhKpdjAY7uMNxEgpk/cJVU2VUkeOsz8u+jH9zDwoWZldA46pBcVJpoGGOp1V16iUVN97xl
 CncluBMffUMNGp15hu5ctCw73xfb6o+Ye37cd5Ha/KJ+ZfgEzUJr2tMYF4x00/sGQx/JVTVF7
 A69SK0X2IlTiqSjo6CnsEoNUpWhaqojNYNMUVa6zDAZM6Img1Jb9hqkNl6sBdj4GdklTP+F2m
 X1bnIzXaBNcHP6CBjZW0QgRhs/LQXyqs03l46D+jaM49tHTXwCC/og4hY6aju0IZ+DxgHgblY
 dZXYoVvTCNOmykzpJNOKzySEkpHOo+XiG8oMfq6jBUAZxspFxnNHL4bKm+WfkvBbJ0haAp5GG
 143DMk61eVsBoNSAOmW44fBJceRCDRfDsz6RNBfeS3LU/nFLtFBpD2gA4YC1hAziGYPRYM8f9
 igJh3Mo1C8bngF8zQgz0P0bI4l9/IjuddtDa9eOu2jTnwmW9EK+7RK5tmFvMsCjD/aIe/Nsge
 JJI5IQgri2JvzA0pCKyauuKkLrHsek6WPZrC6GLCqoRSNBNz51il3hir9Exbo0Pop+FLNlDKG
 zfHdKc8jXjbQjOKMj5DnkQg+IJ+6i98GGAVem3oiQ6QQHcTEtQl2EkX1JPxqVOU5CrgiMBmrz
 jvw5YPUwAS9SufL47TDB9oWuyK4yTOEPkjbmLOmTf3jCBt2zU/gki4JR1KmAjwXBBrf5uykeb
 9AbW+tyWORCAx0VUCLgob6A88uP0UKrSlARLuDKKmSErcMCKvScOR4oTSZheIo1RQx3WzRooO
 O+oTr/NbfaezvOHYBPH
Archived-At: 
 <https://www.postgresql.org/message-id/99A6E7C8-1634-4162-96FD-D5AC404ADBCF%40gmx.net>
Precedence: bulk


--Apple-Mail=_EE1C591E-CC76-4262-BD74-1B7E5ED799C2
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Ever since HTML emails were introduced for project news in around 2020, =
I have wondered why, on my system (macOS using Apple Mail as the MUA), =
emails were sometimes displayed in a distorted way. Today, I took the =
time to track it down. Apple Mail ignores the size if the image source =
is provided inline via CID and not referenced externally [2, footnote =
3]. As a workaround, the width can be specified again in the 'style' =
tag, as I have done in the attached patch.

Another issue is that the Slonik logo is displayed again at the end of =
the email. In contrast to the first issue, this affects the Mail app on =
iOS as well. My analysis suggests that this is caused by the MIME =
structure of the email:
- multipart/mixed
  - multipart/alternative
    - text/plain
    - text/html
  - image/png with Content-Disposition: inline

This issue is resolved if I change the structure to the following:
- multipart/alternative
  - text/plain
  - multipart/related
    - text/html
    - image/png with Content-Disposition: inline

This change could be made in the send_simple_mail() function in the =
pgweb/mailqueue/util.py, but it would require further testing and =
refactoring to support regular and inline attachments simultaneously. I =
don't feel confident enough to do this without setting up a working test =
system of pgweb.
An alternative solution could be to utilise the embed_images_in_html() =
function in pgweb/news/util.py instead of attaching the image to the =
email.

With these changes applied, the mail is displayed correctly on Apple =
Mail [4].

Best regards
Tobias

[1]: <https://pasteboard.co/LBjIKy2V1Woe.png>
[2]: <https://www.caniemail.com/features/html-width/>
[3]: <https://pasteboard.co/WVLPyCzYaxB9.png>
[4]: <https://pasteboard.co/UGMvMYvpMZXG.png>


--Apple-Mail=_EE1C591E-CC76-4262-BD74-1B7E5ED799C2
Content-Disposition: attachment;
	filename=0001-fix-display-of-images-in-apple-mail-v1.patch
Content-Type: application/octet-stream;
	x-unix-mode=0644;
	name="0001-fix-display-of-images-in-apple-mail-v1.patch"
Content-Transfer-Encoding: quoted-printable

=46rom=208d94a9ee3c53c18dd3534f411ce1ae173f3db284=20Mon=20Sep=2017=20=
00:00:00=202001=0AFrom:=20Tobias=20Bussmann=20<t.bussmann@gmx.net>=0A=
Date:=20Thu,=204=20Sep=202025=2021:13:57=20+0200=0ASubject:=20[PATCH]=20=
fix=20display=20of=20images=20in=20apple=20mail=20for=20project=20news=0A=
=0A---=0A=20templates/news/mail/pgproject.html=20|=204=20++--=0A=201=20=
file=20changed,=202=20insertions(+),=202=20deletions(-)=0A=0Adiff=20=
--git=20a/templates/news/mail/pgproject.html=20=
b/templates/news/mail/pgproject.html=0Aindex=2055ddc2a0..0c98726a=20=
100644=0A---=20a/templates/news/mail/pgproject.html=0A+++=20=
b/templates/news/mail/pgproject.html=0A@@=20-4,8=20+4,8=20@@=0A=20=0A=20=
{%block=20content%}=0A=20<div>=0A-=20=20<img=20style=3D"float:=20left"=20=
height=3D"50"=20width=3D"50"=20src=3D"cid:slonik.png"=20alt=3D"PostgreSQL=20=
logo">=0A-=20=20<img=20style=3D"float:=20right"=20height=3D"50"=20=
width=3D"50"=20src=3D"cid:slonik.png"=20alt=3D"PostgreSQL=20logo">=0A+=20=
=20<img=20style=3D"float:=20left;=20width:=2050px"=20height=3D"50"=20=
width=3D"50"=20src=3D"cid:slonik.png"=20alt=3D"PostgreSQL=20logo">=0A+=20=
=20<img=20style=3D"float:=20right;=20width:=2050px"=20height=3D"50"=20=
width=3D"50"=20src=3D"cid:slonik.png"=20alt=3D"PostgreSQL=20logo">=0A=20=20=
=20<h1>{{news.title}}</h1>=0A=20</div>=0A=20{{news.content|markdown}}=0A=
--=20=0A2.45.2=0A=0A=

--Apple-Mail=_EE1C591E-CC76-4262-BD74-1B7E5ED799C2--