COMMIT, ROLLBACK, and Autocommit: PostgreSQL Transactions for SQL Server DBAs
SQL Server DBAs lean on the ‘run to the SELECT, then COMMIT or ROLLBACK by hand’ workflow. PostgreSQL’s autocommit, abort-on-error, and plpgsql change the rules. Here is how to get the same safety and diagnostics in psql and pgAdmin.
A Decision Framework (and When to Stop Arguing)
This is the finale of the “Where Does Business Logic Live?” series. Over five posts we have looked at , the , the , the reality, and the . Now let’s make it actionable. This…
Security, Misconceptions, and Hybrid Architectures
This is Part 5 of the “Where Does Business Logic Live?” series. We have made the , the , and the comparison. Three things remain before we can build a decision framework: how security actually…
Performance and Operations: Measuring Instead of Arguing
This is Part 4 of the “Where Does Business Logic Live?” series. Parts and made the principled cases for the database and the application tier. Principles are where these debates start; measurements are where they…
The Case for Business Logic in Application Layers
This is the third post in the “Where Does Business Logic Live?” series, and it is the deliberate mirror image of the last one. In I made the strongest case I could for putting data-centric…
The Case for Business Logic in Stored Procedures
This is the second post in the “Where Does Business Logic Live?” series. In I laid out the terms of the debate and split “business logic” into five different kinds of logic that behave very…