Archive for April 2021

Biden Bans Travel from India

April 30, 2021 Add Comment
Biden Bans Travel from India
As they discussed the decision this week, top health officials warned the White House about uncertainty over how vaccines might respond to a homegrown virus variant in India.

from NYT > Top Stories https://ift.tt/3e4DF1B

New top story on Hacker News: Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?

April 22, 2021 Add Comment
New top story on Hacker News: Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?
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

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

April 21, 2021 Add Comment
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.

A Lawsuit Over Frozen Embryos

April 16, 2021 Add Comment
A Lawsuit Over Frozen Embryos
Elaine Meyer and Barry Prizant had given up on having more than one child. Then, in their 60s, they got a letter from the hospital where they’d long ago had IVF treatment.

from NYT > Top Stories https://ift.tt/3tn9rfm

New top story on Hacker News: Ask HN: Twilio blocked our account and with it hundreds of our customers

April 14, 2021 Add Comment
New top story on Hacker News: Ask HN: Twilio blocked our account and with it hundreds of our customers
Ask HN: Twilio blocked our account and with it hundreds of our customers
37 by caruizdiaz | 13 comments on Hacker News.
I'm the founder of a tech startup in the field of telephony and we use Twilio for parts of our service. A little over 3 hours ago our entire account was suspended without reason. We received an email stating that fact without further explanation. Since then, we are trying to get in contact with them through every channel we could find: email, Twitter, LinkedIn, and I even tried emailing Jeff Lawson, their CEO. They don't have a support number we can call. We are not a small customer and we have been with them for more than 6 years. It's deeply frustrating that despite that fact, we don't seem to matter to them at all. If you work at Twilio or if you can help us get in touch with them, I'd be indebted to you forever!

Takeaways from Day 13 of the Derek Chauvin Trial

April 14, 2021 Add Comment
Takeaways from Day 13 of the Derek Chauvin Trial
The first medical expert called by Derek Chauvin’s defense team said George Floyd died after a combination of factors — including pre-existing heart conditions, drug use and exposure to vehicle exhaust from the police cruiser — caused his death. He faced difficult cross-examination.

from NYT > Top Stories https://ift.tt/2QpwwiW
Subscribe to: Comments (Atom)