skysight-inc/HackerNews huggingface dataset:
It would return the same value, but the approach to obtain it would be different.

`user` would be a property defined as a User object on the Book model, so accessing `book.user` will cause the framework to fetch the entire user model (even if we then only fetch the id).

On the other hand, `book.user_id` is the auto-generated database column, generated to make the above property definition possible. But since this `user_id` is directly defined on the book object, there is no need to query the user table.
There are literally hundreds of FREE stockfish packages with frontend all good to go. To ask 99$ and lie through your teeth when it comes to authorship and performance is a ruse to rip people off, with the help of a famous name, plain and simple.
The only value I see is the metadata generated by the rifle sent to the manufacturer
Princeton astrophysicists re-imagine world map
Yeah, I also got heavily invested in tt++ scripts but never fully automated. It was great back in the day but there were definitely some eccentricities that made advanced difficult - lack of proper lists, awkwardness dealing with empty strings, weird scoping and special variables, no dicts.

I recently dusted off my old files and tried to get it running in the latest version but there were so many breaking changes that I just gave up trying to fix it.

It would be fun to try to make a proper fully automated bot, though as you said, there are so many different contexts and possible text prompts itd be difficult to make it truly reliable. I wonder what the best approach would be - some kind of classic AI goal system or newfangled ML?

(If I had the time to start over, I’d probably use Mudlet since it uses a proper scripting (lua) instead of something that got hacked together over time. Though it’s a bit GUI-reliant for my tastes)
Because when you are acessing .user you are asking for all its properties, not just the id.

Django does provide relatively easy ways to get over the N+1 issue, though. If you do Book.objects.select_related('user'), only one query is made.
For the same reason referring to anyone with the wrong pronouns is, I would assume. Isn't that offensive? I didn't realize this was up for debate in 2021.
Is this new? I read a book years ago about lucid dreaming which described experiments in which lucid dreamers were able to communicate with awake observers through pre-arranged eye signals.

I think the book was Exploring the World of Lucid Dreaming, which came out in 1991.
There is a particularly fascinating episode of timeteam where it became apparent that the whole thing had been a con by the owner of the land. Instead of just canning the episode they decided to carry on, because the process of working out and proving that it was a con was a great demonstration of how all their techniques work to build up a picture of a site. In this case the picture they were building made no sense, which is when they realised someone was trying to trick them.

Time team was such a great programme. I struggle to think of a programme at the moment that put smart, knowledgeable people front and center like this.
The title is quoted from the paper version (https://arxiv.org/pdf/2102.08176v1.pdf)
It's not a bug, it is the same value. Only instead of using `first_table.foreign_id` to fetch the entire record from `second_table` only to use `second_table.id`, if you only need the identifier itself you already have it in `first_table`.

A similar concept called covered queries exists whereby you index a table by foreign key, and a few additional columns that you do not expect to use in join conditions, but you do expect to frequently retrieve. Depending on your database, requests for only columns in the index (some being the join condition, some subsequent columns being in the set of popular additional columns) means faster access to those popular columns only. In the context of ORMs, you would need to do something to avoid a default behavior of "select *" in order to exploit this index.
The Cryptosat Project
I agree that the Standard Deviation is a good measurement because of the big outliers.

We also focus on these during retro. What made us remarkably slow? You want to drive down these issues.

This investigation can help you in future work. I worked with another team that was consistently slow if they would need to build new pipelines or get connections up and running to third parties(heavy regulated environment). This insight helped us in planning.
This is a great lesson. However, I'm afraid for you're designing your product to be good for the people who are being paid peanuts and are new to the business, but those are not the people who are buying your software. They're just the users of the software. Oracle put basically no thought into their UI but put a lot of money into promotional videos and sales, and they sold their software to giant international banks because the people buying the software experience it only through videos and salespeople.

I'm terribly afraid that you're going to be punished for focusing on the right things.
The #1 project on that list appears to be implemented in rust? What does GO being "low-level" have to do with performance of serving requests? I'd imagine its bottlenecks would be due to something fairly arbitrary, like its garbage collection or how it represents strings or something.
I was so sad to see Reia being abandoned by the author. I think that a Java/C looking language like Gleam (and Reia) has a much better chance than Elixir to migrate really big numbers of developers to the BEAM, because of familiarity. And don't forget PHP, another language with curly braces and many developers. Disclaimer: I make more than half of my money out of Elixir so I certainly love it, and yet I'm not optimistic about it taking over the world. Too unusual looking, not as much as Erlang but more than Gleam. Then it's more about community building than technical excellence. Good enough and a large community is all it takes (eg: PHP and any BASIC.)
If you've got the best design in the long run there's nothing to worry about. That said, it takes a while to find it! And the target is always moving.

2.0 definitely looks like a step in the right direction. Can't wait to use it with psycopg3 and the latest Python. Thanks. ;-)
It may save transports though. Trucks and associated infrastructure takes space. Not sure how the equation works out though.
People will study for interviews as long as interview performance has significant impact on your salary, no matter the field and no matter the interview.

When people say that other engineers don't study for their interviews what they are actually saying is that other engineers can't get a better job than they currently have no matter how hard they work. If they could get a better job by showing that they are great at their job in an interview they would study to be able to show that side and get that salary increase. Instead the interviews are just formalities and you get hired and your salary is based on your resume.
This doesn't really surprise me the least. My company has a lifetime license for TeamViewer and in December we got an email from them stating that the version we use will cease to function later this year. But we get a free upgrade to version 12 and also a 2-year free-of-charge trial of version 15 (the current one).

Doesn't sound too bad at first, does it? Now what they didn't tell us (and you have to dig really deep to find out), our "free upgrade" to version 12 is just another trial which ends the same day as our version 15 trial would.

But even if we were able to use the version 12 upgrade indefinitely, it's no longer possible to create a branded / custom QA client for it. TV only allows that for the most recent version.

So our options come down to paying the rather insane yearly subscription price, or not using it at all anymore. Well, we opted for the latter and are now shipping Anydesk instead with all future installations.
"Mostly". I recall trying a BusyBox from FreeBSD ports. Seemed sorta like a gimmick. Not really needed.

Wikipedia confirms my memory.

https://en.wikipedia.org/wiki/BusyBox
Online Event – Scrum and Jira Alternatives Self-Hosted – March 2, 2021
This would actually work for text editing in general. When I’m writing essays, sometimes things don’t come out right and it helps to compare them with newer attempts.
Mailscript, the Programmable Email Platform
And also people on networks that won’t deliver their providers messages. I can’t sign up for Twitter for example.
It sounds like you are a software engineer. My advise for you being confronted with these metrics is to look around a bit at other workplaces. I am not saying that you should quit, but it doesn't need to be this way.
Generation of Illiterate Developers
I live in Greece and what you describe is very much applicable here too.

Especially the part about government trolling us.

Fuck this reality.
Crypto-yank – a clipboard crypto stealer that monitors and replace addresses
Indeed it’s one of the reasons why I’m staying with JetBrains products. It’s really efficient, we can compare side by side the local history to understand where it went wrong all while keeping the git history clean.
Because while I could do the same manually with git, when I’m in the flow thinking about/building/debugging a particular piece of code, moving out to select files to add to git and then filling a message for that piece of code that isn’t working and doing that every few minutes to preserve intermediate state is a nightmare for my productivity.

It can and should be done automatically by the IDE to enhance developper productivity by getting out of its mind. There is no reason why I should be thinking about that, isn’t that all the point of using IDE and tools to develop ?
Seems like using git for that is still re-inventing the wheel
Auto AI Chrome Web Highlight
On a daily basis, we do a lot of research. We found this process very time-consuming and inefficient. We needed to read all or a big part of an article to get the important infos out of it. So wouldn't it be great to have a web extension that automatically highlights the most important sentences of a website for you? All to get a quick overview what the article is really about? Well, we developed a web extension that does exactly that. Using the latest AI technology to analyze a huge amount of text in milliseconds and highlights automatically the most relevant sentences for you. All to save time on your web research and being effective in gathering the insights you actually need. We would love to get your feedback on that. Check out this FREE Chrome Extension here http://bit.ly/2M8oPMq
If there was it was long before I was born (think segregation-era USA or earlier) but it would not surprise me. There's definitely been some anti-Catholic sentiment during my lifetime but that's largely been football related and largely confined to Glasgow I think. I know Catholic does not necessarily imply Irish, but this is the closest I can think of. I really don't know about England, they might have experienced something like this where many Irish people lived (Liverpool, maybe?).

Since we're talking weird discriminatory signs though there is a sign in a bar called the Clachaig Inn which says "No Hawkers or Campbells". This goes back to the Glencoe Massacre in 1692 where members of Clan Campbell slaughtered the Glencoe McDonalds overnight, and which some people still hold a grudge about today. I hope it's just a historical curiosity though, I don't imagine they really forbid service to anyone with the surname Campbell.

edit: come to think of it I now remember another HN'er (arethuza) talking about discrimination against Catholics in Scotland being more of a thing in recent history than I had realised. I can't remember the time period in question or whether they said it was better nowadays (again, I hope it is).
I think the psychological toll of the lockdowns in different countries is highly underestimated.

I myself have no real economical shortcomings due to the lockdown, but even as a person who is normaly a total loner and who can spend weeks completely alone on a excessive hiking trip i am slowly going crazy...
For my wife, who is a highly social character, its even worse.

And i am not the only one in this mindset... what i hear and see in my region let me believe the mood is slowly turning into some sort of "Torches and Pitchforks" way...
We're gradually removing our ORM usage to avoid active objects. They look too much like VSTs, but subtly make foreign network calls when you least expect it, which makes it very hard to write effective, isolated tests or replace the database layer by something else, like a service call or a cache lookup.
Does anybody have any insight on what are the incentives for a politician to pursue something like this? (in general or even specific to Scott Wiener).

I haven't heard about him before, but looking as his wiki page [1], it look like he has a history of involvement in "cool"/progressive projects, so it could just be the fact that he truly thinks this is a good idea.

But, like any other politician, I assume there must be some other non obvious reasons why he's doing this other than "I think it should be done" or "if I do this, people will vote me".

1: https://en.wikipedia.org/wiki/Scott_Wiener
Ibuprofen is also extremely dangerous if you repeatedly take the recommended dose for too long. Although it's not as likely to kill you in a single overdose like Tylenol can easily do.
This is similar to an approach I proposed in 2012.[1]

Microsoft: "Rather than changing the run-time representation of a pointer in order to support bounds checking, in Checked C the programmer associates abounds expression with each_Array_ptr<T>-typed variable and member to indicate where the bounds are stored. The compiler inserts a run-time check that ensures that deferencing an_Array_ptr<T>is safe (the compiler may optimize away the runtime check if it can prove it always passes). Bounds expressions consist of non-modifying C expressions and can involve variables, parameters, and struct field members. For bounds on members, the bounds can refer only to other members declared in the same structure."

Me: No array descriptors are generated by the compiler. The programmer tells the compiler the size of the array as an expression, and that expression is evaluated at the point in the program where the relevant declaration appears.

The Microsoft syntax is very Microsoft. It involves many leading underscores and long keywords. What I proposed involved adding C++ "&" references, and making lengths explicit in the places in C where you can write "[]". This is more concise. The basic idea is the same, though. Arrays have a length, which is defined by some expression on nearby variables, such as other fields of the same struct or other parameters in the same function call. C programs that work usually have a length around somewhere, but the compiler doesn't know where it is. Make that explicit, and you can check.

If you add ranges and references to C syntax, and provide length information, you can deal with one of C's three big questions - "How big is it?" (The other two big questions are "who owns it?" and "what locks it?")

This area is 10% technology and 90% politics, so you need sizable organizational support to make much happen.

[1] http://www.animats.com/papers/languages/safearraysforc43.pdf
On mobile Chrome on iPhone, adjusting the sliders doesn’t seem to have any effect.

I must be missing something?
you cant do it on a first go. i write a draft of what has to happen. often i draw drafts of the solution on a4 sheets of paper(my own blackboard, the best tool i know to make software). i do research and update the drafts to a point where i type in the code. code is the last thing i do. i laught that i make coloring books and not coding :) i am quite fast and i have little problems with switching contexts. the code is much better as i "see" the whole solution. i have much better abstractions. in a recent task i have found with this way of coding, many places with bad code and made them better as they didnt fit the cleanliness of the soulution. they just stand out like the eifel tower in paris.
Yeah I have no problem using GA for work stuff, but I’d be interested in reasons against it.
Stevie Wonder to ‘move permanently to Ghana’
Former NASA administrator Dan Goldin was obsessed with getting rid of the worm. He even wanted to have a "Meatball" logo sticker applied on top of the worm during a Hubble service mission apparently.

He was reportedly prone to fits of rage when he saw a worm logo. Very Dilbertian.
A more common scenario I see is that people start with a monolith that ends up inheriting all the conceptual debt that accumulates as a project evolves. All this debt builds up a great desire for change in the maintaining team.

A champion will rise with a clean architecture and design in microservice form that addresses all high visibility pain points, attributing forecasted benefits to the perceived strengths of microservices. The team buys into the pitch and looks forwards to a happily-ever-after ending.

The reality though is that the team now has multiple problems, which include:

- Addressing conceptual debt that hasn't gone away.
- Discovering and migrating what the legacy system got right, which is often not documented and not obvious.
- Dealing with the overheads of microservices that were not advertised and not prominent at a proof-of-concept scale.
- Ensuring business continuity while this piece of work goes on.

I would propose alternative is to fix your monolith first. If the team can't rewrite their ball of mud as a new monolith, then what are the chances of successfully rewriting and changing architecture?

Once there is a good, well functioning monolith, shift a subset of responsibility that can be delegated to a dedicated team - the key point is to respect Conway's law - and either create a microservice from it or build a new independent monolith service, which aligns more to service oriented architecture than microservices.
The time people will study is based on the ROI of doing well in the interview. Software engineering has huge salary incentive for interviews so people study a lot. Mechanical engineering has mostly flat salaries based on seniority and manager level so ROI for studying for interviews is 0, so nobody does it.
Eclipse has the same thing.
The flipside of this is that SQLAlchemy teaches people about pooling, threading, processes etc. .... but yes, by painful trial in some cases.
100% All-Natural Safe and Fast Fat Burner and Weight Loss Supplement for Women
Store wine is more sugar than grape. It is disgusting.
They have a nasty habit of sending out verification codes
A very large Sports Direct cup

A table and chair on my balcony

Spotify

Honestly synchronisation was quite easy for me. Making my workspace comfortable required more thought.
Rust is great but it’s a very different experience writing Gleam. Rust is much faster but more complex and more challenging to learn, Gleam is designed to be more approachable. It is like Go vs C++
It seems like you could face swap your real face into the meta face to make it a little better.
Most homeless people doing drugs are doing drugs because they're homeless and need a break from life, not homeless because they did drugs.
That's lovely for you. I hope you enjoy your video chats.
Beware of experimenting with psychedelics. I spent my youth in a time and place where magic mushrooms, when fresh, were legal and sold over the counter. These things can screw you up in a way that you don't even understand at the time, and only becomes clear to you decades later.

Anything that changes your state of mind through a low-effort action can be habit-forming. Anything that effects your perception can create a feedback loop where you change your usage behaviour based on that change in perception, particularly when your tolerance increases.

Whether it's escapism you seek, or the heightened sense of perception. Whether you think you're in control because you're microdosing or because you've got a great job and everything is going well.

Be careful.

Your mind is delicate.
That’s a possible cause for punctuated equilibrium evolutionary theory
3-line CSS to make Hacker News narrow for Safari's custom style sheet
table#hnmain {
padding: 0 -webkit-calc(42.5% - 21em);
}

Preferences > Advanced > Style sheet
Yep there's a weird anti-Polish thing that popped up through the 2000s as Poland joined the EU. I never really understood it or saw anyone in my friends/family holding this belief so I hope it's not too bad.
Now that sounds like an accessibility nightmare :P
Oh, it's in Elm. Cool! I'll definitely read the code later today and hopefully learn something. Did writing this reveal any interesting pros/cons regarding event sourcing in contrast to a stateful implementation?

Minesweeper is such a cool exercise when learning new stuff. A co-worker challenged me to write this crude implementation on a flight from Heathrow to NYC while I was learning Go: https://gitlab.com/joyey/kakkamiina
Scheme has #; which comments out a single expression. This covers most but not all use-cases. (It doesn’t help for commenting-out subsequences, like if you wanted to remove the top half of a begin block.)
Well, it is the same value, but the ORM doesn't handle book.user.id any differently than it does book.user.name where it isn't the same value, and thus the only option is to fetch the second table. So it's not a bug, it's really just the ORM being consistent in how it handles queries, thus missing out on a possible optimization in this special case, where a simpler query could have given the same result.
And the industry's experts who are famous for writing "idiomatic C" keep making mistakes constantly that result in new CVEs.
Absolutely! I have mild red/green issues and could barely tell those lines apart.
Exciting news. A little hard to believe the rotation of the wheel would be enough to power a tire pump, but would be happy to be proved wrong!
The NYSE was opened in the 1790’s and even in the 20’s stock volatility was significantly smaller compared to bitcoin, DJIA “only” grew around 5 times between 1920 and 1929 (so comparable to the decade between 2009 and 2020).

To find something on a similiar scale to bitcoin you might actually need to go back to the 18th or 17th centuries (see the “South Sea Bubble” or the “Tulip Mania”).
When sending international transfers to a different currency, you often get unreasonably bad rate, banks kinda give you the exchange rate they see fit.
Which often turns out to be like 4% fee.
Paypal is the worst at that, but many normal banks are also bad.
If you send 1 mill, you end up paying 50k just for exchanging eur to usd for instance
You missed a key point that was crucial in what is basically a cascading failure:

Texas (like other states) relies on gas plants for electricity plants (about half of them) and is also a gas producer. The increased demand on gas because of people heating their homes contributed to shortages. This then leaad to issues with gas production sites in texas that need power. This was then aggravated by pipes icing up (water vapor in the gas). That's a cascading failure. Wind power was also affected of course but not nearly as much as the gas supply issues.

Texas needs to reconsider its over-reliance on gas and diversify its grid. Ice proofed turbines are a thing. Solar is still a relatively minor part of production in what is obviously a state that has plenty of potential for that.

Additionally, it should strongly consider connecting to the rest of the country. If only to enable the export of the ample supplies of wind and solar it can produce normally. It's just good business sense. Then, it should probably start incentivizing people more to do sensible things like putting solar on their roofs, installing batteries in their homes, insulating their houses, and consuming off peak power (e.g. by charging their EVs). All these things collectively should make blackouts a lot less likely.