We're consulting firm led by hands-on software engineers that specializes in custom software development for projects that touch millions of lives in areas of immigration (streamlining operations and working to reduce backlogs on benefit processing) and healthcare (post-COVID public health data analytics work) for the US federal government.
Tech stack: Typescript, React, Java/Groovy, Spring Boot, Docker, K8s, AWS.
Based on my experience, I like the author's approach since it makes things pretty clear-cut and optimized the storage in the core table (in my experience as well, deletes happen frequently and the soft deletes are rarely touched). In large, row-oriented tables that that storage can add up and even with views/materialized views there's a cost to using/maintaining those as well.
Yeah, I checked it out and wanted to use but a bunch of regular old SQL queries don't work. Please add support for the old fashioned group by syntax! (This will be helpful for getting to a true drop-in replacement!)