Backend and data

Under the hood

The parts you never see: the database, the catalog, imports, push, payments and deletion. How each piece works, and why it was built that way.

Supabase and the data model

Postgres does most of the work

One Supabase project: Postgres holds the catalog and every user's data, edge functions hold every secret, and scheduled sweeps do the slow work.

SupabasePostgresEdge functions

Search and vague search

90,000 games, one query

A local catalog seeded from IGDB, searched in Postgres with typo-tolerant matching, plus a queued language-model search for games you can only describe.

IGDBpg_trgmLanguage model

Platform imports

Owned games in, passwords never

Steam through OpenID, Xbox through OpenXBL, PlayStation by PSN ID, and Android by an on-device check. Linking is a connection, not a sign-in.

SteamXboxPlayStationAndroid

Notifications and OneSignal

Your like never waits on a push provider

Every notification is written in the same transaction as the action that caused it. A sweep delivers pushes through OneSignal, and release reminders are scheduled on the phone.

OneSignalTriggersSweeps

RevenueCat

Monetization and entitlements

Free with ads, then Pro, all in RevenueCat

Free for 50 games with a few ads. Prysm Pro removes the limit and the ads. Every purchase and every ad reports to RevenueCat, and the backend, not the app, decides who is Pro.

RevenueCatAdMobWebhooks

Security and privacy

Nothing in the app to steal

Passwordless sign-in, row-level security on every table, secrets only on the server, and payments decided by the backend.

AuthRLSSecrets

Account deletion

Permanent, complete, and never silent about money

Delete your account in the app or on the web. Images go first, then the RevenueCat customer, then the account, and a subscription is never left running unannounced.

PrivacyRevenueCatWeb

Services, website and credits

Who receives what, and who we build on

Every outside service Prysm uses and what it receives, how this website is built, and where the game data comes from.

VendorsNext.jsIGDB

Tech stack

Supabase

Postgres

Deno

RevenueCat

OneSignal

IGDB

AdMob

Cloudflare