Real PostgreSQL schemas, reviewed

The database behind each product, documented and reviewed by ArchLens Postgres: every table, every foreign key, the design findings, and a 3D explorer you can rotate. Each schema is fetched from the project's own repository at a pinned commit; nothing is edited by hand.

This browser is not letting the page draw in 3D (WebGL is unavailable), so each card plays a recording of its explorer instead of the live miniature. The docs and findings links work as normal; the explorers themselves need WebGL.

Quickest test: open this page in a private or incognito window. Extensions are off there, and canvas or fingerprint blockers are the usual cause.

Chrome: type chrome://gpu in the address bar and look at the WebGL lines. If they say Unavailable, open chrome://settings/system, turn on "Use graphics acceleration when available", and relaunch. As a last resort, chrome://flags/#ignore-gpu-blocklist.

Edge: type edge://gpu in the address bar and look at the WebGL lines. If they say Unavailable, open edge://settings/system, turn on "Use graphics acceleration when available", and restart Edge.

Firefox: open about:config, search webgl.disabled and make sure it is false; about:support shows the graphics status under Graphics.

Safari: WebGL is on by default. Check Safari → Settings → Advanced → "Show features for web developers", then the Develop menu → Feature Flags, and make sure WebGL is enabled.

Look for a WebGL or hardware acceleration setting in this browser, or try another browser.

Miniflux

Minimalist feed reader: users, feeds, entries, enclosures, API keys. The schema is rebuilt here from the migration strings in the Go source.

miniflux/v2 at 2.3.3 · site

16 tables14 foreign keys4 domains1 errors6 warnings9 notes

Matrix Synapse

Matrix homeserver: rooms, events, devices, end-to-end keys, federation. Almost no foreign keys by design; this is the full schema at schema version 72, before later deltas.

element-hq/synapse at v1.160.0 · site

137 tables14 foreign keys14 domains21 errors28 warnings123 notes

GitLab CE

The whole DevOps platform: projects, merge requests, CI, security, packages, and much more. 1,429 tables: the stress test. Far past the explorer's comfort zone, kept in on purpose.

gitlabhq/gitlabhq at v19.3.1 · site

1,429 tables1,861 foreign keys111 domains by table prefix39 errors161 warnings1,668 notes