HN
login

SQLite 3.53's SET NOT NULL replaces a full table rebuild with six writes

DEV Community·10 points·alexgeorgiev17·about 3 hours ago·dev.to

Adding NOT NULL to an 8M-row SQLite table used to mean rebuilding it; 3.53's ALTER COLUMN SET NOT NULL does it in 6 writes instead of 69,843.

Read the full article at dev.to →

#sqlite#null#writes#53s#table#rebuild#replaces#full

Related stories

Related topics

databases45distributed68macos80database57production59faster92projects45org27programming322