Schema Migration Articles

Page 1 of 1 (4 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

11/6/2019 • EN

Non-relational bear-traps

Discusses common pitfalls and challenges when using non-relational databases, focusing on difficulties in changing primary keys and access patterns.

Database Design Dynamodb Non Relational Databases Primary Key Schema Migration

Cal Paterson

3/1/2010 • EN

Changing primary key index structure

A technical guide on safely converting a SQL Server primary key index from nonclustered to clustered (or vice versa) using a temporary unique constraint.

Clustered Index Database Optimization Primary Key Schema Migration SQL Server

Adrian Hills

12/27/2009 • EN

Writing Schema migrations for App Engine using the Mapper Class and the deferred Library

A guide to writing schema migrations for Google App Engine using the Mapper class and the deferred library, including a bug-fixed code example.

Appengine Datastore Deferred Library Mapper Class Schema Migration

Ian Lewis

Schema Migration Articles

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

Non-relational bear-traps

Changing primary key index structure

Writing Schema migrations for App Engine using the Mapper Class and the deferred Library

Select Language

We use cookies