paws

For me this answer was helpful and succinct, thank you.

Neat trick, any other params folks might want to know about?

I'm looking forward to trying out incremental backups as well as JSON_TABLE.

Thank you contributors!

It's possible to opt out of the TheWorkNumber [0] by postal mail. You might consider it. [1]

[0] https://employees.theworknumber.com/employee-data-freeze

[1] https://krebsonsecurity.com/2017/11/how-to-opt-out-of-equifa...

According to Matt Stoller [0] we have Alan Kaplinsky [1] to thank.

> Kaplinksy’s claim to fame is that he’s the lawyer who figured out you could get rid of the ability of a consumer to go to court by using what’s called a pre-dispute arbitration provision in a contract.

I'm no expert but Kaplinsky sure sounds like a modern day super-villain.

[0] https://www.thebignewsletter.com/p/ending-junk-fees-the-most...

[1] https://www.ballardspahr.com/People/Attorneys/K/Kaplinsky-Al...

As a generally healthy person it's very disappointing that catastrophic plans are only available for under 30s. [0] For me it makes the most financial sense to pay out of pocket for incidentals/annuals, but be covered for catastrophes e.g. get hit by a bus and wake up in a hospital.

What magical event happens to people at age 30 that led the legislators to ban catastrophic? Would love to see the actuarial data on that. I have no knowledge/evidence of the reasoning but to me it definitely smells like lobbying.

[0] https://www.healthcare.gov/choose-a-plan/catastrophic-health...

> the heart is designed for max availability over consistency, so when in doubt, it triggers a beat.

This is a great line, thanks! Going to share this with my distributed database reading group

I believe this is only available to paying members with a blue check.

EDIT: "this" meaning posting

Yeah, the current situation is pretty terrible. Deprecating the old credential-based auth flow, before adopting login.gov was a massive misstep. Five months ago I noticed the alert about deprecating the classic username/password auth, and posted about it [0].

As far as I know login.gov is a viable solution, already in use at the SSA, that is government-run aka doesn't require users to kowtow to an EULA, capricious arbitration, etc. The problem is there was apparently interagency squabbling that messed up the original deployment schedule. So it's not available. I do hope that changes because the current situation, of mandatory id.me seems pretty terrible.

[0] https://news.ycombinator.com/item?id=35519938

A few weeks ago I had excellent results using this to install Ventura on a 2017 MacBookPro13,3. While obviously not as fast as a newer machine, everything I tried so far works great, iCloud, Universal Control, latest apps etc.

Compared to other vendors, it seems like Apple has an aggressive obsolescence position. This app offers a significant countervailing force to eWaste, and IMO deserves broader recognition. Authors: great job, thank you.

I'm not taking a position on OCLP being trustworthy or not, but at least the project appears to be 100% open source [0], which is more than we can say about Apple.

[0] https://github.com/dortania/OpenCore-Legacy-Patcher

Thank you for pointing this out.

The macOS appocalypse was a really shocking moment -- it was so disappointing to learn that despite the privacy marketing shtick, macOS engineers chose to have Macs phone home sensitive data in an seemingly aggressive way, with no opt out. Now in 2023 the fact that "a preference for users to opt out of these security protections" never materialized, and the copy just disappeared from the website, is quite disappointing. Great write up here [0] - thanks @lapcat!

Anecdata: Ever since that day I've blackholed ocsp.apple.com/ocsp2.apple.com at the DNS level, and all my Mac apps have launched just fine since.

If anyone at Apple reads this, I want to be given the choice. Warn me, stuff the setting into whatever plist -- whatever, but give me the choice.

Frankly for a company with Apple's resources, it's hard to believe the OCSP test suite somehow didn't consider half-open TCP connections. If a global catastrophe like that can happen once, it can happen again - which is why, in addition to the clearly negative privacy implications, Apple should give users who care a clear opt-out.

[0] https://lapcatsoftware.com/articles/ocsp.html

Yikes. The only other time I heard about the Splunk sales team in the news, it sounded pretty bad also.

https://www.theregister.com/2020/08/12/splunk_sales_discrimi...

Could you please explain more about who these counterparties are exactly? Do they include brokerages?

I'm trying to understand why a counterparty would enter into an arrangement where a stock price change obligates them to financial liability like this. Presumably there's some upside if the stock price goes the other way, but it's unclear who the $ would come from in that case.

Also: Who originates options? When someone buys an option, is it the brokerage who collects the fees? Is the counterparty already involved at that point?

Not sure I'm understanding you correctly - by captive portals do you mean the "challenge" that renders in a browser/webview context, commonly when joining a new network? I'm not sure that would be suitable for what I describe above.

What makes LittleSnitch/Lulu/similar nice is they listen for "all" outgoing traffic types TCP/UDP/ICMP/etc, and show UI immediately, including for non-browser apps, e.g. games, VoIP, P2P apps, whatever -- it tends to be covered. Unless I'm mistaken I don't believe a captive portal can be triggered when "just any" process originates traffic.

That's the strength of LittleSnitch/similar, but the major weakness with host-level filtering they rely on, is you're 100% at the mercy of Apple's networking stack, and this Sonoma issue isn't the first time Apple moved the goalposts. Not too long ago Apple exempted their own services from whatever LittleSnitch hooks [1] and it could of course happen again with any macOS update.

In my view this is precisely why a separate box is appealing. Ideally it'd have as tight of a UI as the incumbent apps, including the same metadata (process name + app icon, protocol, port #, most recent previous attempt, etc).

[1] https://news.ycombinator.com/item?id=24838816

The more macOS seems to break user control of networking, the more I wonder what kind of "separate box" solutions are out there that can intermediate _outgoing_ traffic. e.g. Something like LittleSnitch on a router, where it notifies the Mac when it detects a new outgoing connection.

Do things e.g. pfSense support that already? "Hold" an outgoing connection from the moment the SYN is observed, notify whatever client, and only allow if the user clicks?

A few months ago I paired gcsfuse with Seafowl [0][1]. Was a lot of fun balancing tradeoffs that are usually not possible with classical databases e.g. Postgres. Thank you gcsfuse contributors for making it possible!

[0] Seafowl is an early stage open source database written in Rust. https://seafowl.io/

[1] https://github.com/splitgraph/seafowl-gcsfuse

    Post https://www.splitgraph.com/blog/deploying-serverless-seafowl

[2] Previous post https://news.ycombinator.com/item?id=36215088

Why?

Lovely, thank you!

> MultipathTCP

Can you please share more about this? I've been curious to build a router with redundant internet providers ever since I noticed certain PCEngines boards supported LTE modem modules. [0]]

I assume you're using Linux; do you wire all your modems via Ethernet and manage MultipathTCP all in your router? Any hardware offloading you're aware of/recommend?

[0] https://www.pcengines.ch/apu3c4.htm

Slightly OT: I noticed Colorado, Connecticut, New Mexico, and New York City either ended or limited qualified immunity in recent years. (In other states similar efforts faltered, apparently thanks to police unions and politicians in their pocket [0])

Via the article:

> Fifteen months after the Colorado bill was signed into law, there is so far little evidence to support any widespread negative effects on police retention or recruitment.

Now that it's been more time I've been curious to measure how curtailing QI has affected 1) police misconduct 2) police hiring and 3) insurance rates (e.g. indemnity) municipalities/townships/states pay.

If anyone has insight on ways to measure, places to find data, etc would be appreciated.

Meanwhile for those curious about Chicago police misconduct, TIL about [1]

[0] https://archive.ph/evcEG

[1] https://cpdp.co

Glad to hear you've had good results! Yes, @mildbyte did a great job making Seafowl comply with HTTP cache semantics (i.e. Etags/Cache-Control), and it should give good results for both CDNs and browsers. When building Open Data Monitor [0] I certainly observed some nice speed ups.

For those interested in how caching works (i.e. if your dataset is public it could be an easy win) more info is in the docs [1]

[0] https://open-data-monitor.splitgraph.io/week/2023-05-22

It's a Socrata scraper that renders diffs of public/government datasets

[1] https://seafowl.io/docs/getting-started/tutorial-fly-io/part...

Recently I got curious about SQLite in serverless settings and eventually figured out a way to combine GCP Cloud Run with Seafowl, an early stage database. SQLite has been quite helpful! Did a write up [0] in case anyone is interested. (also about to submit it for my first Show HN.)

[0] https://www.splitgraph.com/blog/deploying-serverless-seafowl

Thank you @thethirdteacup - that looks helpful.

Because you were downvoted I can't reply directly so doing it here instead.

Anyone else run into an Angular 15 styling nightmare when upgrading to the latest Material Design (MDC) release?

I attempted to use the migration tool [0] for upgrading an in-house LOB app, but unlike previous upgrades client hated the resulting UI - understandable b/c of major styling regressions everywhere - so downgraded back to 14.

Angular 14 LTS support ends in November [1] and as best as I can tell, if we want to stay on a supported Angular release we're forced into a lot of custom styling work users simply don't care about.

If there's some way to stay on the "legacy" [2][3] components on Angular 15 or 16, would appreciate any links/hints. Cheers

[0] https://material.angular.io/guide/mdc-migration#2-run-the-mi...

[1] https://angular.io/guide/releases#actively-supported-version...

[2] https://material.angular.io/guide/mdc-migration#form-field

[3] https://material.angular.io/guide/mdc-migration#library-wide...

"These changes generally improve spec-compliance and accessibility." Maybe that's great for some folks, but the client liked the UI exactly as it was.

When I purchase flight tickets I like to review the breakdown of associated fees and taxes - usually plenty of entities taking their pound of flesh. So I was pretty surprised to learn that airlines have enjoyed tax exemption for jet fuel for international flights, on a worldwide basis apparently since the 1940s. IATAs position is unsurprising [0]. I find it curious that the airline industry has enjoyed such generous tax treatment for so long [1].

Granted, unlike today, in the 40s when this tax treatment was being established I doubt any government was considering taxes as a way to tackle climate change.

[0] https://www.iata.org/contentassets/ebdba50e57194019930d72722...

[1] https://en.wikipedia.org/wiki/Kerosene_tax#Criticism_of_kero...

I don't know if it qualifies as the "most interesting" but as a travel bug I wrote a little airfare scraper that I got plenty of value out of.

Basically it's a script that scrapes several places for flight deals and "mistake fares" and notifies my phone if it matches with my city. No searching like other flight apps, you basically just set it up and wait, and various places will pop up. Helps if you're in a hub city e.g. NYC.

The phone notification was crucial because such deals sold really fast. In case the booking didn't work out I was usually covered by the 24 hour cancellation rule [0][1].

I started off running it on my own server but later I learned IFTTT handles device notifications without paying the Apple Developer tax, so I migrated things there. Used it more when I was single but nevertheless it's helped me land some killer deals e.g. NYC-Dublin RT for $300, NYC-Paris RT for ~$400.

Thought about making a paid app out of it but the limited seating and time-sensitive nature of these deals is tricky.

[0] https://www.transportation.gov/airconsumer/notice-24hour-res...

[1] I believe this rule, which is not so broadly known, was imposed on air carriers in response to certain fraudulent online marketing practices going on at the time.

I'm not knowledgeable about CalECPA, but I sure don't see why officers who 'acted in good faith' should be a basis for violating the peoples' 4th amendment rights.

Regulatory capture sucks and seems like one of those problems that's deeper and more prevalent than people realize.

I'm interested in learning where it was actually _curtailed_ in some measurable way e.g. due to the public pushing back, or other reasons. If you know of resources/studies on the pushback story, assuming there is one, would be appreciated.

Not sure if this is common knowledge, but I learned booking.com does not necessarily integrate with hotel backends in the way you might expect given their name. Turns out they (at least sometimes?) just lie to you in the UI.

I know that because my dad used booking.com last year, but when he presented the booking.com printout at the front desk - 'Sorry sir, we can't recognize that.' He wasn't late or anything. Pretty sure he prepaid too. Total nightmare - you had one job, booking.com, GTFO.

Personally given the blatant deception, plus the way they took UK/Netherlands pandemic money and laid workers off anyway [1][2] I don't think I'll ever use it. Also, Barry Diller thinks working from home is a crock [3]. I'll take my business elsewhere, GL with that Barry.

[1] https://hospitality-on.com/en/concept/booking-holdings-repor...

[2] https://skift.com/2022/02/11/booking-com-to-eliminate-2700-c...

[3] https://viewfromthewing.com/expedia-boss-trashes-his-employe...