Database Constraints Articles

Page 1 of 1 (3 articles)

5/1/2025 • EN

Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID

PostgreSQL 18 introduces NOT VALID for NOT NULL constraints, allowing addition without table scans and validation with reduced locking.

Alter Table Database Constraints Not Null postgresql Schema Migration

Hubert (depesz) Lubaczewski

10/25/2016 • EN

Bullet Proofing Django Models

A technical guide on designing robust Django models for a bank account system, covering constraints, logging, and best practices.

Backend Development Database Constraints django Models software design

Haki Benita

2/23/2010 • EN

Autogenerated SQL constraint names - why to avoid them

Explains why using explicit, meaningful names for SQL constraints is better than relying on autogenerated names for easier maintenance and safer deployments.

Database Constraints Database Maintenance Deployment Automation SQL Best Practices SQL Server

Adrian Hills

Database Constraints Articles

Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID

Bullet Proofing Django Models

Autogenerated SQL constraint names - why to avoid them

Select Language

We use cookies