This is a great question. I would love to see more documentation on what this means for transactional emails.

Adding systems in place to handle unsubscribing from transactional emails will mean quite a bit of engineering time/effort for many companies.

They defined bulk senders in the 3rd paragraph: "bulk senders — those who send more than 5,000 messages to Gmail addresses in one day"

> is that the domain or the sending SMTP server?

Let's hope from what ever comes first, or people will start sending from 1.example.com, 2.example.com ...

Many people know javascript, so when they want to build something, they use the language they already know.

If you know you are at risk for specific cancers, then you would likely get tested more regularly and could potentially catch them at an earlier stage when they're usually more treatable.

I haven't looking into this specifically, so I have no idea if that works for the types of cancers this tests for. My point is applies to testing just generally speaking

You can make a REST endpoint match a client's needs, but if you have multiple clients (for example, 1 for mobile and 1 for desktop) that all need different amounts of data (for example, the mobile client shows a simplified view with less data), then you would need to write 2 different REST endpoints to handle each clients. Multiply that by the number of pages with a difference.

> then you would need to write 2 different REST endpoints to handle each clients.

Or you use Accept header for its intended purpose

Accept: com.company.user-aggregated/json

Accept: com.company.user-aggregated-lite/json

etc.

And let the server return the fields defined by the relevant schemas.

I mean, the advise given for GraphQL in prod is to literally call predefined queries only.

Since we're here talking about Postgres and SQL standards. Here's my wishlist:

- Support for arrays of foreign keys. This one has been worked on a couple of times but hasn't made it into a release. https://commitfest.postgresql.org/17/1252/ - I think this would be an absolutely phenomenal way of handling sorting, instead of having to use linked lists and CTEs or some type of "order/position" column

- Support for deferring NOT NULL and CHECK constraints to the end of a transaction (just ran into this problem yesterday)

Edit: typos

> Support for arrays of foreign keys.

Standards-wise, the first step would be arrays in general :)

> Support for deferring NOT NULL and CHECK constraints to the end of a transaction

Agreed 100%

“Array of foreign keys” has been at the top of my list for so long. Would simplify sooooo much.

I followed the link about arrays of foreign keys but couldn't see what it was saying. Could you briefly summarise for me?

Is there a database that supported arrays of foreign keys?

Of the major databases, only Oracle and PostgreSQL have array extensions and neither support FKs as array elements.

I'm curious how people think this feature should work? ON DELETE SET NULL, ON DELETE CASCADE, something else?

I would love it if the would remove the key from the array.

We use it in Palantir, that is a proprietary overlay on top of Spark. It supports this feature reasonably fine.

> - Support for deferring NOT NULL and CHECK constraints to the end of a transaction (just ran into this problem yesterday)

I'm curious what the use case of this is?

Deferrable constraints are usually considered for foreign keys, since there you might have to juggle updates to multiple tables and might violate the constraint in the intermediate states. But that doesn't appear to apply in that way to CHECK constraints.

2 tables that reference each other and the foreign key columns both have a NOT NULL constraint.

Any plans to introduce a way to connect to a Neon database without making it publicly accessible via the internet?

Yes. What's your use case? Security or egress costs (those are 0 if you are in the same region).

Security

We are looking at private link for this. Will this work for you?

I haven't used PrivateLink before, but from my brief look, it looks like it would work.

how would they do this? allow it to be added to a wireguard VPN or something?

Or within AWS world you can do VPC peering.

How about private link?

I build marketing software for authors (called StoryOrigin if you want to look it up for credibility purposes), so I'm quite familiar with the space.

Exactly what you've described is already out there: https://www.atticus.io/ (released last year - I have no affiliation.)

This is the first I've heard of it. Looks neat. I do like the Front/Body/Back Matter view in the sidebar.

I'm curious as to how you all are providing SSL for custom domains

The sites are deployed on Vercel and Digital Ocean. Both platforms allow users to connect their custom domains, and they auto-generate the SSL for these domains.

Gotcha. That makes sense since each site is deployed separately and not a subdomain of a single deploy. Thanks for sharing!

1) https://github.com/react-page/react-page (comes with a Slate plugin actually) 2) https://grapesjs.com/