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
CREATE TABLE platform_legal_documents (
kind TEXT NOT NULL CHECK(kind IN ('terms','privacy')),
locale TEXT NOT NULL CHECK(locale IN ('en','zh-Hans')),
title TEXT NOT NULL,
markdown TEXT NOT NULL,
effective_on TEXT NOT NULL,
revision INTEGER NOT NULL DEFAULT 1,
updated_at INTEGER NOT NULL,
PRIMARY KEY(kind,locale)
);