skysight-inc/HackerNews huggingface dataset:
If I can find a question that matches mine exactly, sure. Otherwise due to the imprecision of searching on google, I'm often left to filter through results, and then in each result that seems relevant filtering through each answer that seems relevant, sometimes never getting a perfect match.

ChatGPT does offer user feedback of a kind though -- e.g. I can tell it "no, not like that, more like x" and it will take that into consideration.
I've been using PugSQL to write SQL in Python [1].

With this package, you write the SQL inside SQL files so you can benefit from syntax highlighting, auto formatting, static analysis, etc. At the difference of writing strings of SQL inside Python files. I'm surprised this is not more popular.

[1] https://pugsql.org
Yeah I meant in general. Of course I know there are use cases for NAT that are valid regardless of IP version in use.
With an explicit error you get from validation (like Zod, as used in tRPC), you could notice that your client is out of date and either refresh automatically or prompt the user to refresh[1].

The benefit from validation is that the error is easily recognizable & can be handled nicely, even in just one place. Without validation, you get things that Typescript claims are impossible, for example exceptions on code paths that look like they cannot throw, and you can't easily tell why any of that happened -- that's a recipe for miserable debugging. Of course, with less busy, less critical, sites you might not notice or care.

[1]: Refresh could cause loss of user input (e.g. text just entered), depending on the app that might matter and need browser-side storage or something along the lines of the "local first" manifesto. Easy kludge for simple apps with smart users is to make the user copy the text, click refresh, paste.
> Google search was 1998. Google Maps was 2005. Gmail was 2004. Android was 2008. Youtube was 2005. Chrome was 2008. Docs was 2006.
> Yet in the last decade, they really haven't had many successes

I don't think this kind of analysis is really giving a good answer. I mean, by these standards, look what a disaster of a dinosaur legacy vendor Apple Computer is! Haven't had a successful product launch since the iPad 13 years ago! (Perhaps with the exception of Apple Watch - 2015).
I had a similar experience.

I purchased 1 year of MuseScore PRO+, March 2022 and stopped using it a few months later, but forgot to unsubscribe. I'd get an email or two from MuseScore every few months, but usually just marked read and forgot about it.

MuseScore hid the upcoming renewal reminder at the bottom of a newsletter styled email, two months early and then essentially said 'we reminded you about this change' later on.

An email titled "Your new year of MuseScore PRO+" arrived Jan 29th 2023 - quite a length email with lots of blue buttons telling me to read more about customer success, values of the products, how they've added x amount of new music scores to my subscription yadda yadda.

Then it goes on to fill up the screen with 'top scores' with images, more buttons to explore - where to go for help, discover new music........ blah blah, typical new year new company email. Except the very, very bottom of this email stated 'Oh yeah we're going to be renewing in March'. I had no emails from MuseScore between this newsletter and the renewal. So it fell completely off my radar until I had a 'Payment Received' email.

I then tried to refund, knowing that you have 14 days from subscription - and was offered a discount. The same style as the article, except the offer was 45% not 35% - heavily pushing how this was the best they could do in my really unfortunate circumstance. I thought, that doesn't sound right - and stumbled across lots of articles on Reddit about just quoting their own terms.

I emailed back, quoting the TOS and then received a very robotic 'prorated refund of the amount.. has been issued to you" email.

Since unsubscribing I have started to receive sales emails - that I could block but find it amusing to see how long it goes on. I count, between March 2023 to today:

12 'Spring Sale' emails, ranging from 65%, 70%, 83% off annual plans
4 '[Last Chance] emails, same discount range
1 'For your eyes only' 70% off
11 'Summer Sale' emails, some of them 'special summer sale'
1 'BLACK FRIDAY SALE'
1 '[Last Chance] Summer Sale'

Promotional emails 2023 by month:
March - 1
April - 2
May - 7
June - 9
July - 8
August (to date) - 3

I'm just interested to see if the rate of emails continues to grow or will hover around 1-2 per week. Has also become ritualistic to clear MuseScore emails from my mailbox - which is quite therapeutic.
Exactly my point: the same company wrote Rosetta and the new Settings. Clearly not the same level of talent and commitment in those two teams.
There’s Meaning in the Ordering of the Web’s Tech Stack
I've found contributing questions or answers to SE/SO to be a lot of like hanging out in IRC channels dedicated to C -- a lot of blowhards tend to hang around the watering hole, berating people for lack of knowledge for some reason or another, expressing it in a variety of in-group approved ways.

It becomes tiresome to wade through the self-important moderation to get to actual content. That said, spam and unmoderated channels are clearly worse too. I'm not sure how to get to something in the middle of that Laffer curve.
> The result is that courts and the police both can and will raid offices, seize materials etc.

The police can and will do all kinds of illegal things, regardless of the law. It's up to the courts and DoJ, etc, to sort that out after the fact, there's not much anyone can do before it happens.
You can give it context, and it will incorporate the context into the text of its response.

Good luck figuring out if it incorporated the context in the content of the answer though.

The internet already had too many low quality, misinformed pages. With Chat GPT, it now has an infinite number of pages like that. I’m not sure that makes a qualitative difference.
If the expense and lead time for the redesign now that more reliable and precise position (and first derivative thereof) are available from GPS via ADS-B are to be considered, it's fair to ask "well, what are the downsides as compared to using altitude for separation as today?" and one of them is "a higher percentage of aircraft are transmitting mode-C than will be transmitting ADS-B out".

Given that the clear priority is now to follow a TCAS RA (resolution advisory) over an ATC instruction, I think that the current TCAS approach is good enough to cause aircraft to miss each other and that a GPS-based redesign is unlikely.
Isn't the title itself editorialized, care of our propagandizing media?
Yeah, ppl on the ring road of Amsterdam live 10 years shorter afaik, for instance
Finland and Iceland also have some of the highest suicide rates in Europe. It seems that the correlation between happiness (or well-being) and suicide is complex.

Which makes sense: it can be isolating if everyone around you seems to be thriving and you aren't.
it seems appropriate for heavily armed and armored mall-cops (i.e., normal private citizens with no police powers) cosplaying in gravy-colored military gear
haha yes, I called it Tiny Snitch at first, but it's too close.
You really don't have much leverage here unless you're also on the board or have an unusual pull with the board.

I've been in this situation a couple of times. In both situations the board ended up replacing the founder. The first time, the entire investment team and board were what I think of as "vanity VC"—basically a group of angels who knew each other, and while they were all good at their day jobs, they were just as bad at running the company through their replacement as the founder was, and the company, while still around the company is basically treading water.

In the second situation I joined a startup and its founder CEO was replaced about a year after I got there. At first we were all pretty on edge over this, but overall I think it was a good move—the investors are legit, and the replacement CEO is experienced, with a couple of exits in the sector under their belt. I believe this one is going to have a good ending.

Bottom line, the only leverage you've got is your time and where you spend it. If you believe in the mission but not the founder, your best bet is to find another company in the same vertical and spend your time there... but vet the management team carefully! (as always...)
Google's massive distributed build system also runs tests and so most projects run their dependent tests in parallel on thousands of machines.
Denver and SLC are reasonably big cities. If you need, for example, a big-city childrens' hospital, they have them.

Then you start to drive out of town, and there is N O T H I N G. I mean, from SLC, there's Ogden and Provo, maybe Park City. From Denver, there's Colorado Springs and Fort Collins. Once you get past those, it's a long way to the next anywhere.

So are they isolated? Depends on how you define isolation. Does that particular kind of isolation affect depression and/or suicide? No clue.
Pretty excited to launch this to the world! Have heard on multiple groups where people are trying to find various grants and credits programs. Hope this serves as a ready reckoner.

Please feel free to contribute.
> Shipping confidence
We can define “shipping confidence” as the feeling a mentally sane developer has when they know their code is about to be deployed to production (whether it can be updated over the air or not).

A bug which must be fixed in production is much more expensive than a bug fixed during development.

People here complain when you bash Microsoft, but their phylosophy was (and still is) let the users test the product.
I just don't think any of that is related to the economic system. It's pretty clearly the result of China having a lot more subsistence farmers when they industrialized.
+1 a total failure on the PR/comms side of the situation.

Even some of my technical friends don’t understand the issue and solution which is worrying. I like to explain it like this:

Imagine you a driving down the highway and step on the accelerator to give the car more gas, but there is an issue with the engine. The worst thing for the engine control unit to do is to cut off the engine while you’re driving at 60mph, this can be dangerous and cause a safety issue.

Same with phones, you could be in a situation and need to make an emergency phone call, or need the last bit of juice from your device to check maps/GPS to get you out of the woods before dark. The worst thing here is for the phone to shut itself off when you need it.

Car manufacturers will turn on a big red engine warning light, put your vehicle into failsafe/protection mode (but still let your drive it with reduced power) and tell you to get it serviced ASAP.

This is what Apple failed to do correctly.
The Internet That Wasn’t
"they can still live on as Linux machines. I have an unreasonable level of affection for that old box of mine."

So funny you mention that. That's exactly what happened to my older core-i5 machine. It's a media PC in the livingroom running on Ubuntu after I ported the Windows license over to my current machine ;-)
They are very interested in stories like this because this gives them the chance to work themselves into high dudgeon about a shitty little paper no one cares about. This way they have something to point to when they pull their "50 intelligence officials said this is russian disinfo" bullshit. "We're not unprincipled, self-serving, corrupt morons look how huffy we got about this tiny paper in kansas!"
> Validate your strategy before building it. If there's a senior engineer in your team who nitpicks your code, get their buy-in before writing it.

I think this hits the nail on the head. Code reviews have been adopted by most of the orgs I've worked at as a way to reduce any technical barrier to starting a project. Technical planning is moved from the start of a project to the end (or more accurately, to what has now become the middle). I'm certain there are code review processes that are done well, but they don't appear to be common.
Do not host podcast feeds behind Cloudfare
The mountain West is the most highly urbanized part of the US.
Ah, true.

That said, some of these are going back up. Java and C#, for instance, are clearly trending up again, as is Swift. Python's down, but by 10%ish, not 40%. And JS is down a lot but that's the one language you'd expect ChatGPT to actually be the best at "helping" with, given that it's the web's own programming language, so it being trained disproportionately more on JS than anything else would be hardly surprising.

And then there's languages for which ChatGPT might as well not exist: Lisp, Go, Rust, etc. Heck, if we were to look at Rust, for instance, ChatGPT did literally nothing. Its rise has been, and continues to be, meteoric. And if we look at arduino questions, you might even conclude that ChatGPT was a factor in driving people to Stackoverflow, not away from it.

Data science is hard, and certainly much harder than most folks (especially those with a programming background) think it is.
This article: https://thehandbasket.substack.com/p/a-conversation-with-the... contains a detailed interview with editor of the raided newsroom. When asked about pulbic support, the publisher said he had a lot of support from out of town, but the locals... well:

"They're afraid. They're really afraid that the police power is unchecked, and that they can be punished like this."
The hidden fee costing doctors millions every year
YMMV but i work at a place where

* code review is expected responsibility, so everyone participates in every part of it regularly, so they are also incentivized to keep the process sane

* we have an auto linter and we recommend saving on fix specifically so no one argues about useless style nits

* CR back and forth is measured in minutes or hours so you are not waiting days to resolve someone’s drive by comment

* CR feedback always has a specific action item that is easy to address

* reviewees submit smaller CRs which are quick and easy to review for reviewers
The typical F-150 is about 2000 lbs lighter. After a quick glance, it looks like the standard tires for the Rivian aren't as heavy duty as most truck tires. (I suspect Rivian wants a more comfortable ride vis-a-vis a standard work truck)
Nuclear is an absolute loser in this country. Forgetting the astronomical price tag it's just not fast enough. If we started building nuclear today the first plant wouldn't be ready until at the absolute soonest 2030. We need clean energy now, that means solar and wind.
I think it’s a great habit and an effective method for consolidating what one learns … at least until someone cheats themselves using GPT to write up a TIL essay.
SDR: Digital Adventures in Shortwave Radio (2020)
> of course you can't say that.

Oh you can absolutely say that.

It's just a dumb take. Because there are already languages which have a solid type system, a functional bent, and a GC. And you can probably bang out one yourself if you want.

If that was what Rust was, it probably wouldn't have existed in the first place, Mozilla would not have been interested in it in the second place, and no community would have gelled around it in the third place. Hell, it was specifically dragged further downstack by the people who coalesced around its potential in that space.
See a related concept in product development, ‘jobs to be done’. In a sentence: people don’t pay for products, they pay for jobs to be done. There’s a famous example about milkshakes (YouTube).
This is correct, thank you. I'll fix it shortly.
That's a Denial of Service.
Only a computer can get stuck in a loop or a person who is insane. It's not like if you ask a person to divide by zero they will fall in to a coma or sit there computing.

I 100% believe that ChatGPT can output absolute garbage but for the same reason you don't cite Wikipedia/Google you won't be citing ChatGPT. Just like Wikipedia or Google It's just an excellent starting point to rapidly get a working draft going.
Though Amazon is known to hire people just so they can fire them during the next cycle of rank and yank, so they'll probably just fire those people and let the people they actually hired to do work stay full-remote.
This is pretty cool. Thank you for sharing.

Do you mind if I share some on my newsletter[0] about AI prompts (with proper credits given)?

[0] https://promptmonthly.com/
At least in what regards you seeing yourselves "exceptional", and the vicious antirussian propaganda, effectively encouraging to kill, maim, religiously persecute and take away human rights from the russian people (openly in Ukraine, less openly in Baltic states and eastern europe, not so openly, but nevertheless actively, in the rest of the world), I would say that there is a stronger analogy between the nazi Germany and you.
Emphatically not. Every chunk of space, propagation direction, and polarization has its own spectrum. Draw a box, count the photons. If you point a satellite dish at different satellites, you see different signals, even if the frequencies are the same.

The same trick works for "virtual antennas" built out of phased arrays of real antennas, except you can steer them in microseconds and without any motors. MIMO leverages this.
The Google Trends graph stuck out to me. You're comparing something that didn't exist before December and had broad appeal, to something that people arrive at generally by searching a question. They aren't at all comparable. (I imagine you'd see the same graph if you compared ChatGPT with Facebook. Doesn't mean ChatGPT is replacing social media.)
> ...virtual analogue...

Fake truth, dry wetness, empty fullness.
Pet peeve: There's an anticorrolary though, which is that tests written solely for the requirements of an elaborate CI system tend to hurt and not help. Tests need to be trivially executable and inspectable by developers running on their own systems with minimal support. If they aren't, then all you know is that "It's Broken!" and not how to fix it.

Good CI is good because it easily integrates "one-off bespoke tests", not because it outlaws them.
Yeah, it's not so much the lease liability that's the issue. It's the right of use asset that was recognized. It's a book loss, not impacting actual cash flow.

https://assets.kpmg.com/content/dam/kpmg/xx/pdf/2021/07/impa...
> I fear this will be another egregious violation of the Constitution ignored under qualified immunity.

The police officers, individually can have qualified immunity. The governments that employ them do not.
UI being mobile-first is a beef you have with the designers and product owners who are neglecting the desktop experience, not with the techonology.
I mean usually you can, but if you have a printer and packaging tape, boxing it up yourself means you can drop the package off at a box and skip the store(and possible line)
Yes, but also it's been a long time since I've had any reason to do this, and had gotten "managed = False" mixed up with abstract classes. Abstract classes won't let you do this, but you probably want "managed = False" to prevent migrations from doing stuff in the database, if it's going to be a reporting-only query that doesn't have a backing table.

Also you need to return an "id" column since Django needs a primary key.

On the flipside, you can put that query in the database as a VIEW and point the model at it, also with "managed = False".
3D Scanner Uses a Sensor You Might Not Know About
Isn't it time to stop using "grandparents" as a stand-in for "naive user"? I know a lot of grandparents who are more tech-savvy than their grandchildren.
I have a full time job so writing 52 technical articles a week would be too much. To give you an example of the type of articles I've written, here are the last 10 articles I've created.

1. Berkeley’s Digital Legacy: The Evolution of BSD and Its Influence

2. Tracing the Lines: From the Telephone to Unix

3. My experience with Pop!_OS Linux Distribution

4. Enhancing Emacs Efficiency with Xah Fly Keys

5. Learning to Touch type again

6. The Complexity of Open Source and AI

7. Racket: The Lisp for the modern day

8. The XML Connection: How docx and odt Share Common Ground

9. An Ode to Emacs. The Greatest Operating System

10. How to Fine-Tune Your ChatGPT Interactions for Better Results

I try to create a backlog of easier articles that I can queue up. Then when I have a few weeks worth of articles in the pipeline, I can work on one deeply technical article that will take more than a single week to write. I've been pretty busy these past few weeks, and am about to go on vacation so I'm working on some lighter stuff. I just finished two back to back posts on Operating Systems (Unix and BSD). The next one will be on Plan 9, but as that one will require more extensive research it will be put on the back burner for a bit until I get through the rest of August.

I read a lot of stuff on Hacker News, Substack, and Lobste.rs, Tech Twitter, and Mastodon, so those are great sources of things to write about. I have also spent the last couple of months updating my Emacs, switching up my keyboard, and focusing more on ergonomics, and those experiences ended up being articles. Once you get into the flow of it, you start seeing all sorts of things to that you can write about.

> "Here is the 5001st article on how FastAPI routers work", "Here is how z-level in HTML works!" or something.

I have done articles like that. An example of that is my article "A soft introduction to working with XML in C#" I've found that the people that are subscribed to my newsletter enjoy my "voice" and the way I write thing. They don't mind a simpler article every once and awhile. I wrote that article around the time I was working with XML in C# and I refer back to it every time I need to refresh myself. It's great because all the tutorials work for my workflow and are in my words so it's those articles end up being the easiest to follow!
Well first of all there is. California now requires new houses to have solar. But residential solar is much more expensive because you need roofers to install it. Massive solar farms are much faster to install and much cheaper.
If you ask a bad question on SE (leave "bad" to be defined separately), you waste time of people who try to answer it, and of people who stumble across it hoping that it relates to them and solves their problem.

If you ask a bad question to ChatGPT, you waste no one's time but your own.

If answering SE was a job where you got paid, I would expect a lot more hand-holding (and some amount of kindness, to keep the revenue stream coming back), but instead, the people who answer questions do it more-or-less for fun. Having someone waste your time isn't fun.
Show HN: Defendera – Chrome extension protecting from scams
Hey HN!

I'd like to show you Defendera - a Chrome extension (other extensions are planned) which checks any visited website for scams and threats. The detection includes all kinds of (secret) automation, AI detection of suspicious patterns, and even a manual review from an on-call person when needed. Defendera cannot use any personal data, because it doesn't collect or save any information about your browsing activity, while still reviewing it all for your safety.

While the scammer can catch off guard anyone, the most vulnerable are less technical people still spending time online - like parents or grandparents. Defendera is designed to make the setup trivial - send a sign-in link and Defendera guides you through the rest.

Any feedback will be greatly appreciated!
Review can also effect maintainability; the code should ideally be parseable by other people on the team with little context of the specific project. And it should ideally spread knowledge of the code to at least one other person.
Amazon is rolling out a generative AI feature that summarizes product reviews