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
-- Access policy only. Album/media business repositories are introduced separately.
CREATE TABLE IF NOT EXISTS platform_album_access (
site_id INTEGER NOT NULL REFERENCES platform_sites(id),
album_id INTEGER NOT NULL CHECK(album_id > 0),
revision TEXT NOT NULL,
salt TEXT NOT NULL,
password_hash TEXT NOT NULL,
PRIMARY KEY(site_id, album_id)
);
CREATE TABLE IF NOT EXISTS platform_visitor_limits (
key TEXT PRIMARY KEY,
window_start INTEGER NOT NULL,
attempts INTEGER NOT NULL
);