[tehlike]

Keeping id generation inside the app is useful, you can batch multiple statements (e.g. insert product, insert product details in a single query, or other sorts of dependencies). You don't have to wait for first insertion to finish to get the id of the record, for example.

[pmarreck]

Good point. There are implementations of this in various languages, then, that are linked in the blog post.

I'm not sure how difficult it would be to tell postgres to only generate the identifier if it's not part of the inserted data already... but that might be a nice compromise

[tehlike]

I think that's what default value achieves. If it's not provided, it generates one, if it is provided, it's used.

[pmarreck]

It is! I had looked it up in the meantime.