Foreign Data Wrapper – Supabase

Supabase meets Gravatar

Are you using Supabase or some other PostgreSQL setup? We built for you a PostgreSQL Foreign Data Wrapper (FDW) for accessing Gravatar profile data. It is implemented as a WebAssembly component using the Supabase Wrappers framework.

Find everything you need in our GitHub repo and in the Wrappers framework catalog:

What is a Foreign Data Wrapper?

Foreign Data Wrappers (FDW) are a core feature of Postgres that allow you to access and query data stored in external data sources as if they were native Postgres tables.

Enrich your user database with Gravatar

You can join Gravatar data directly with your database tables using standard SQL, eliminating separate API calls. The database handles all API communication and connection management, so your application simply queries as usual without managing HTTP requests.

Features

  • Query Gravatar profiles by email address
  • Returns profile information including display name, avatar URL, location, etc.
  • Email hashing using SHA-256 (as required by Gravatar API)
  • Support for API key authentication via Supabase Vault extension
  • Automatic fallback to public API when no API key is provided

Looking for development documentation? Check DEVELOPMENT.md.



Last updated on: