4 ms·

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...