Special News: April 2021

Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?
38 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

Chicago man charged in road-rage shooting that wounded child

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

D.C. statehood bill passes in the House, but faces 'formidable' odds in the Senate

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

Biden wanted to rally the world around his new climate target. Not all nations joined

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

Bodies found in desert in 1980 ID’d as woman seeks parents

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

A Virginia GOP candidate for governor said Derek Chauvin's guilty verdict 'makes me feel sick'

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

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

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

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

Video shows man rescuing child who fell onto tracks as train barrels into station

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

Former US Vice-President Walter Mondale dies aged 93

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

Upbeat assessments buoy hopes for revival of Iran nuclear deal

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

New top story on Hacker News: Americans overwhelmingly say marijuana should be legal

Americans overwhelmingly say marijuana should be legal
26 by undefined1 | 5 comments on Hacker News.

New top story on Hacker News: Manhattan to stop prosecuting prostitution, part of nationwide shift

Manhattan to stop prosecuting prostitution, part of nationwide shift
31 by pmiller2 | 14 comments on Hacker News.

New top story on Hacker News: Why Google Cloud is less trustworthy than AWS or Azure

Why Google Cloud is less trustworthy than AWS or Azure
23 by igorhvr | 0 comments on Hacker News.

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?
44 by jc_811 | 17 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.