NORM: No ORM Framework
summary
A Postgres-centered toolset compares live catalogs across environments using foreign data wrappers to import catalogs and run fast diffs, not repository text, and it generates SQL patches that make one environment look like another (prod→dev or dev→prod) including columns types defaults constraints ownership and privileges. The code uses dynamic SQL functions (named diff) to compare and produce ALTER/CREATE/DROP scripts; patch ordering and some edge cases are work in progress but comparisons run nearly instantaneously.
AI-written summary · about
chapters (18)
- 0:00Start
- 5:29Why software engineers are unhappy?
- 5:54Design tools
- 6:48Version control and compare
- 8:25What makes two tables different?
- 9:26Deployments!!!!
- 11:27Security/access management
- 13:33How we compare schemas in different databases?
- 16:05What we can compare
- 17:37Compare tables
- 17:53Compare columns
- 18:22Compare constraints
- 20:10And we can generate patches!
- 21:44Constraints patches
- 22:23Compare all privileges
- 24:47Dealing with recursive roles
- 27:37Future work
- 29:10Other issues
related talks
42mNORM_GEN: an alternative to ORM
46mBeyond Good and ORMs
01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & Extensibility
25mBig Bad World of Postgres Dev Environments
48mDevOps Discovery: Navigating the Database Landscape- 48mDevOps Discovery: Navigating the Database Landscape
- 48mDevOps Discovery: Navigating the Database Landscape
27mOSSom for Better Oracle to Postgres Assessments