Tag: database
Unit of Work
A pattern that tracks all changes made to domain objects during a business transaction and coordinates writing them out as a single atomic database operation.
3mo ago
quality advanced
UPSERT
PHP 5.0+
An atomic INSERT-or-UPDATE operation — inserts the row if it does not exist, updates it if it does — eliminating the race condition of a separate check-then-insert.
3mo ago
database intermediate
UUID vs Auto-Increment IDs
UUIDs are globally unique identifiers that don't expose record counts or enable enumeration, at the cost of larger index size and random writes.
3mo ago
general beginner
UUID vs ULID vs Auto-Increment
PHP 7.0+
Primary key strategies: auto-increment is simple and fast, UUID v4 is globally unique but random (poor index performance), UUID v7 and ULID are sortable globally unique IDs.
3mo ago
database intermediate