News for hackers. Stuff that matters.

A comment on How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design. Parent comment

Re:How PostgreSQL aggregation works and how it inspired our ... by nextaccountic on Friday August 06, 2021 @01:47AM (#28083734)
Hey, that seems very cool!

I saw it is written in Python. Does the Python code run only when creating the sql query? Am I supposed to add the generated sql code to git?

[ Parent | on HN ]
Re:How PostgreSQL aggregation works and how it inspired our ... by paulddraper on Friday August 06, 2021 @07:15AM (#28085580)
Correct. The Python code generates the triggers and functions to keep the rollup table up-to-date.

Add the SQL DDL to whatever migration control system you use.

[ Parent | on HN ]