Special News: April 2021

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

'He was guilty.' Extra juror in favor of Chauvin conviction

from Yahoo News - Latest News & Headlines https://ift.tt/32CV3E1

Over 400 Asian New Yorkers Sign a Letter Against Andrew Yang's Mayoral Bid

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

Ma’Khia Bryant’s Neighbor Says Cops Had No Choice but to Shoot

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

John Kerry praises Biden's action on climate change

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

Sen. Tim Scott to deliver Republicans' rebuttal to Biden's joint address

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

What is the Paris climate agreement and why did the US rejoin?

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

Rev. Al Sharpton at Daunte Wright funeral: Time to get rid of the "stench of police brutality"

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

A light for Myanmar's darkness

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

Ex-Sheriff Underwood’s corruption case headed to jury as prosecutors, defense clash

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

New probe confirms Trump officials blocked Puerto Rico from receiving hurricane aid

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

Nigeria warily eyes border after Chad leader's death

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

Wednesday 21 April 2021

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
75 by igorhvr | 19 comments on Hacker News.

New top story on Hacker News: Godot 3.3 Has Arrived

Godot 3.3 Has Arrived
20 by sc__ | 2 comments on Hacker News.

New top story on Hacker News: DNA of giant ‘corpse flower’ parasite surprises biologists

DNA of giant ‘corpse flower’ parasite surprises biologists
47 by theafh | 1 comments on Hacker News.

New top story on Hacker News: Comparing the New Generation of Build Tools

Comparing the New Generation of Build Tools
3 by mariuz | 0 comments on Hacker News.

Derek Chauvin held in solitary confinement for 23 hours a day

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

Lawsuit seeks monetary damages after Asian American detective taunted

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

Indonesia searching for missing submarine with 53 on board

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

States suspend Syria's OPCW rights over chemical attacks

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

Brooklyn Woman Charged With Hate Crime For Slapping Woman Speaking Mandarin in Manhattan

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

EXPLAINER: Why 1 murder count against Chauvin may not stick

from Yahoo News - Latest News & Headlines https://ift.tt/32Diz3D

Head-on crash in no passing zone kills driver, has passenger in hospital, SC cops say

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

EU outlines ambitious AI regulations focused on risky uses

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

New top story on Hacker News: 0.1 ETH turned into $30M in 46 days

0.1 ETH turned into $30M in 46 days
10 by undefined1 | 2 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?
12 by jc_811 | 6 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.