Project log
Significant changes, newest first. In the repository, so it is versioned with the code.
Catalog pages now render on the server
Every listing and record page arrives complete in the initial response instead of after JavaScript runs. Search engines and link previews had been seeing an empty shell.
Public read access tightened
Table and function privileges are now stated explicitly rather than inherited from platform defaults. Eight database tests assert them, and each was checked by breaking it deliberately.
Two import endpoints taken offline
The one-off tools that loaded the recovered catalog were still deployed and callable. They were removed; the code is kept for local use.
A second copy of the catalog
The full catalog was exported to a dated snapshot in the repository. Until then the only complete copy was the live database.
Moved to a standalone database
The site now runs on its own Supabase project rather than the builder's hosted one. All 1,395 catalog records and their links moved intact.
Rebuilt on a server-rendering framework
The app moved from a single-page build to TanStack Start, so pages can be assembled on the server. The catalog pages followed the next day.
Catalog recovered from archived snapshots
ParticipateDB went dark and was rebuilt from Archive.org captures: 396 tools, 325 projects and 275 references. Sixty-five entries were recovered only in part, and three not at all.