Self-hosted personal gallery application with online photo management and albums, supporting Live/Motion Photos, EXIF parsing, geolocation recognition, and an explore map.
TypeScript albumsexif-extractiongeocodinglive-photomotion-photophoto-galleryphoto-sharingwebgl-viewer
ALTER TABLE `albums` ADD `position` real DEFAULT 0 NOT NULL;--> statement-breakpoint
-- Backfill positions to preserve the previous display order (newest first, id asc tiebreak).
-- Ordering by `position` ASC reproduces the former `createdAt` DESC sort.
UPDATE `albums` SET `position` = (
SELECT COUNT(*) FROM `albums` AS a2
WHERE a2.`created_at` > `albums`.`created_at`
OR (a2.`created_at` = `albums`.`created_at` AND a2.`id` < `albums`.`id`)
) * 1000;