PostgreSQL Extensions Requests

pg_notify enables real-time asynchronous messaging between the database and client. After coming from Firebase (and exploration of Supabase) this is common need for modern real-time applications, removing the need for optimistic updates, complex boilerplate heavy state-management packages like Redux/NgRx. Caveats: This is difficult to build and maintain, requiring many custom triggers, where clause exceptions etc. This may not be the extension to fix this issue, other PaaS services offer custom libraries to solve this solution.

Allows id generation in the following formats UUID v6, UUID v7, nanoid, ksuid, ulid, Timeflake, PushID, xid, cuid (deprecated), cuid2, typeid https://github.com/VADOSWARE/pg_idkit

https://github.com/theory/pg-semver

https://github.com/paradedb/paradedb/tree/main/pg_search

esperemos

esperemos

https://github.com/supabase/pg_jsonschema