BBC NEWS: April 2021

Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?
41 by vaughan | 23 comments on Hacker News.
I know [RethinkDB][1] used to do this with their SQL-like ReQL language, but I looked around a bit and can't find much else about it - and I would have thought it would be more common. I'm more interesting in queries with joins and doing it efficiently, instead of just tracking updates to tables that are modified, and re-rerunning the entire query. If we think about modern frontends using SQL-based backends, essentially every time we render, its ultimately the result of a tree of SQL queries (queries depend on results of other queries) running in the backend. Our frontend app state is just a tree of materialized views of our database which depend on each other. We've got a bunch of state management libraries that deal with trees but they don't fit so well with relational/graph-like data. I came across a Postgres proposal for [Incremental View Maintenance][2] which generates a diff against an existing query with the purpose of updating a materialized view. Oracle also has [`FAST REFRESH`][3] for materialized views. I guess it's relatively easy to do until you start needing joins or traversing graphs/hierarchies - which is why its maybe avoided. EDIT: [Materialize][1] looks interesting in this space: "Execute streaming SQL Joins" but more focused on the event streams rather than general-purpose DML/OLTP. [1]: https://ift.tt/32z6nkG [2]: https://ift.tt/305Xtvu [3]: https://ift.tt/3dFUX51 [4]: https://ift.tt/3g2klkX

Columbus Grapples With Police Shootings That Have Taken Black Lives

By BY WILL WRIGHT, LUCIA WALINCHUS AND KEVIN WILLIAMS from NYT U.S. https://ift.tt/3avWmce

The G.O.P. Is Getting Even Worse

By BY DAVID BROOKS from NYT Opinion https://ift.tt/3tWjrwg

The New York Times News Quiz, April 23, 2021

By Unknown Author from NYT Briefing https://ift.tt/3dFINsG

Biden plans to nominate ocean scientist Rick Spinrad to head NOAA, the country’s premier climate science agency.

By BY CHRISTOPHER FLAVELLE from NYT U.S. https://ift.tt/3az7NQn

ABC sells out ad space for the Oscars, even as fewer people are expected to watch.

By BY BROOKS BARNES AND TIFFANY HSU from NYT Business https://ift.tt/3sPiHbi

Britain Apologizes for Racism in World War I Memorials

By BY THE ASSOCIATED PRESS from NYT World https://ift.tt/3vcxFJL

Republicans Look to Slash the Size of Biden’s Infrastructure Plan

By BY EMILY COCHRANE AND JIM TANKERSLEY from NYT U.S. https://ift.tt/3axHREY

Neighbor with footage of Ma'Khia Bryant shooting: Officer 'did what he thought was best'

from Yahoo News - Latest News & Headlines https://ift.tt/3ndoaXV

Brett Favre: It’s ‘Hard to Believe’ Derek Chauvin Intentionally Killed George Floyd

from Yahoo News - Latest News & Headlines https://ift.tt/2PbSfe7

Algerian author Said Djabelkhir sentenced to jail for offending Islam

from Yahoo News - Latest News & Headlines https://ift.tt/3epg0rr

Fact check: No evidence to back claim that man convicted for Floyd's murder was not Derek Chauvin

from Yahoo News - Latest News & Headlines https://ift.tt/3sN4xXY

Delta plans to buy 25 Airbus planes amid expected travel rebound

from Yahoo News - Latest News & Headlines https://ift.tt/2RVYILc

Anti-Asian hate-crime bill passes Senate 94-1, with only Republican Sen. Josh Hawley voting against it

from Yahoo News - Latest News & Headlines https://ift.tt/3dIBjoV

New top story on Hacker News: The Rise of North Korea's Hacking Army

The Rise of North Korea's Hacking Army
9 by mitchbob | 1 comments on Hacker News.

Wednesday 21 April 2021

New top story on Hacker News: Ask HN: How is a company like Comcast able to get away with spam?

Ask HN: How is a company like Comcast able to get away with spam?
49 by jc_811 | 18 comments on Hacker News.
I recently signed up for Comcast Xfinity internet (only one available in my area), and ever since I signed up I receive marketing emails almost daily that do not have an unsubscribe link because they are marked as "service related emails". I've unsubscribed from every single email preference in my account, and even went so far to confirm with their support agents that I did it correctly. However, almost daily I receive emails about "See what your wifi can do" or "Don't forget about these new features" etc, that are clearly marketing and not service related. Browsing forums online it seems there are countless others who have the same complaints as me. So, my main question is, how can a company get away with this when it is blatantly in violation of the CAN-SPAM Act? Is it truly just too difficult for any individual to hire a lawyer and go up against Goliath? Does the CAN-SPAM act have any loopholes I'm not aware of that would allow this? I'm genuinely curious to this, and do not want to come off as just an angry customer ranting.