Horses and Sparrows: The myth of 'trickle down' economics
6 by lhoff | 0 comments on Hacker News.
Friday, April 30, 2021
Thursday, April 29, 2021
Wednesday, April 28, 2021
Tuesday, April 27, 2021
New top story on Hacker News: Daniel Kaminsky, Internet Security Savior, Dies at 42
Daniel Kaminsky, Internet Security Savior, Dies at 42
44 by hughmandeville | 2 comments on Hacker News.
44 by hughmandeville | 2 comments on Hacker News.
Monday, April 26, 2021
New top story on Hacker News: Signald: Unofficial Daemon for Interacting with Signal
Signald: Unofficial Daemon for Interacting with Signal
10 by gaius_baltar | 6 comments on Hacker News.
10 by gaius_baltar | 6 comments on Hacker News.
Sunday, April 25, 2021
Saturday, April 24, 2021
Friday, April 23, 2021
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?
34 by vaughan | 22 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
34 by vaughan | 22 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
Thursday, April 22, 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?
34 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.
34 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.
New top story on Hacker News: NetBSD Toaster Powered by the TS-7200 ARM9 SBC (2016)
NetBSD Toaster Powered by the TS-7200 ARM9 SBC (2016)
4 by commandnotfound | 3 comments on Hacker News.
4 by commandnotfound | 3 comments on Hacker News.
Wednesday, April 21, 2021
Tuesday, April 20, 2021
Monday, April 19, 2021
Sunday, April 18, 2021
Saturday, April 17, 2021
Friday, April 16, 2021
Thursday, April 15, 2021
New top story on Hacker News: Europe eyes strict rules for artificial intelligence
Europe eyes strict rules for artificial intelligence
18 by simonebrunozzi | 7 comments on Hacker News.
18 by simonebrunozzi | 7 comments on Hacker News.
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
28 by caruizdiaz | 12 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!
28 by caruizdiaz | 12 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!
Subscribe to:
Posts (Atom)