5 ms·

Does anyone know if there is a comparison somewhere for the various Postgres offerings (eg heroku, aws, crunchydata, fly, supabase, etc)), both managed and unma

by twsted 3y ago

Does anyone know if there is a comparison somewhere for the various Postgres offerings (eg heroku, aws, crunchydata, fly, supabase, etc)), both managed and unmanaged, with features and pricing?

jadayesnaamsi 3y ago
I am particularly interested in a comparaison between this new one from Supabase/Fly and the one from Neon.
- cpursley 3y ago
  Main thing I want to know: which of the managed Postgres services allow for logical replication. I love Heroku, render and neon is promising - but non allow access to the WAL.
  - kevinbrolly 3y ago
    Hey, supabase employee here. We allow you to use logical replication - https://supabase.com/docs/guides/database/replication https://supabase.com/docs/guides/database/replication AFAIK all the others mentioned do not allow logical replication as you noted.
  - SahAssar 3y ago
    Can I ask what your use-case is for logical replication on something like neon?
    - cpursley 3y ago
      So I can run something like Supabase or WalEx which subscribe to WAL changes.
      - SahAssar 3y ago
        Ah, gothca. I've mostly used triggers and LISTEN/NOTIFY for those things, so haven't tried the WAL methods.
        cpursley 3y ago
        There’s significant limitations with the trigger approach.
        SahAssar 3y ago
        Just an FYI: neon just released logical replication.
        ajc23 3y ago
        https://neon.tech/blog/change-data-capture-with-serverless-postgres https://neon.tech/blog/change-data-capture-with-serverless-p...