News for hackers. Stuff that matters.
Re:Ask HN: What could a modern database do that PostgreSQL a... by throwaway_pdp09 on Monday September 06, 2021 @03:58AM (#28431487)
I'm doing a project perhaps relevant to this. Talk of declarative schemas (or what you imply they offer) is very interesting and I'd like to know more but I can't find anything relevant (just magento and sqlalchemy). Indeed, searching for <<<"Declarative schemas" "sql">>> in google gets this very thread on the first results page.

Any links to clear, actionable and reasonably comprehensive examples of these would be most helpful. Obviously abstract statements of the required semantics are also needed, but I also need to see what actual code would look like.

TIA

Re:Ask HN: What could a modern database do that PostgreSQL a... by GeneralMayhem on Monday September 06, 2021 @04:38AM (#28431672)
Magento (the new XML-based version, not the old create/update/revert-script version) gives a lot of these properties. Making it part of the database instead of a third-party tool would be better, though - it lets you cover more features, and with deeper integration you can get transactional updates and history logs.