Hacked News

Comments from Hacker News https://ift.tt/iKjXx18 via

Hey HN, I’m an engineer at Supabase [0] and one of the creators of this demo. My team and I have been working hard to bring developers the next version of Supabase Realtime. The current version of Realtime [1] is a Change Data Capture (CDC) server for a PostgreSQL database that broadcasts changes via WebSockets to authorized subscribers. It’s written in Elixir/Phoenix. The server utilizes PostgreSQL’s logical replication functionality, which writes database changes to Write-Ahead Logging (WAL) segment files, and a replication slot, responsible for managing and retaining WAL files. Database changes are polled from WAL by the server using PostgreSQL’s replication function pg_logical_slot_get_changes and changes converted to JSON objects using the wal2json [2] extension by setting it as the output plugin. Security is enforced through two checks - each check ensures only authorized client subscribers are sent database changes. The first check validates a JWT that is sent by clients sub...

Article URL: https://jacobian.org/2022/apr/11/mercenary/ Comments URL: https://news.ycombinator.com/item?id=30992409 Points: 40 # Comments: 31 from Hacker News: Front Page https://ift.tt/wrfeMsU via

Article URL: https://blog.craftyguy.net/cmdline-help/ Comments URL: https://news.ycombinator.com/item?id=30991834 Points: 9 # Comments: 7 from Hacker News: Front Page https://ift.tt/omOZgBi via

Article URL: https://securityzines.com/#comics Comments URL: https://news.ycombinator.com/item?id=30991368 Points: 11 # Comments: 0 from Hacker News: Front Page https://ift.tt/QX09OIh via

New story on Hacker News: Why I'll never use Affirm again https://ift.tt/vTzGKxe

Comments from Hacker News https://ift.tt/omOZgBi via