Proposal to Add sqlpage.send_mail for Email Notifications

[mtt-artis]

Hi 👋

Currently, we use bash scripts with curl --smtp to send email notifications via sqlpage.exec. Would adding a native sqlpage.send_mail functionality be beneficial for DX?

Something as simple as the code below

sqlpage.send_mail(
    'sender@example.com',
    'recipient@example.com',
    'Email Subject',
    'Email Body'
);

with a SQLPAGE_STMP_HOST and SQLPAGE_STMP_PORT env variables.
do not know how to handle SMTP errors yet

[lovasoa]

I'll work on that function !

In the meantime, please have a look at https://github.com/sqlpage/SQLPage/tree/main/examples/sending%20emails

[mtt-artis]

Thanks a lot! I'm aware that there's an HTTP service for it, but our applications don't have access to resources outside the company intranet.

[mtt-artis]

I'm happy with the implementation.

I'm only thinking about whether we should make it slightly more generic so it covers the most common scenarios ?

For example, could the Recipient field support multiple email addresses (e.g., comma- or semicolon-separated)? Would the same apply to the CC field?

Similarly, would support for file attachments be useful?

I don't mind if CC and attachments are left for a later iteration. I just wanted to mention them now so we don't forget about those use cases (if you find them valuable)