skysight-inc/HackerNews huggingface dataset:
SQLAlchemy looks at you and wonders what you’re talking about. ORMs can be pretty amazing, but like any tool, you have to know how to use them. If you want to use an ORM (or straight SQL!) to shoot your own foot, nothing’s stopping you.
Which reminds me, being in Germany of one night I dropped such an order into the bank mailbox to pay my taxes as this exceeded the online limits. Where it then likely was retrieved and the information on it was used to wire 5000€ to the U.K. where probably a money mule was forwarding it. Bank eventually returned it.
Citymapper | London, UK or similar timezone | REMOTE, VISA | Various roles

We are focussed on building mobility solutions for cities.

Citymapper is a > 10 year old award winning mobile and web app for transport users and is available in over 400 cities around the world. However our main focus is on building Consumer-grade SDKs & APIs that are ready to go and used in many 3rd party apps.

We are a small-ish engineering team of < 50 and are looking to expand the team to build out features of our consumer app as well as B2B offerings.
- We have multiple backend engineering vacancies (main tech stack is Python on K8S/AWS) as well as iOS (Swift) and various other vacancies.

Your first round interview will be with one of the engineering leads, and we will keep the interview process short and interesting for both sides!

Apply via https://citymapper.com/jobs or reach out directly to me at marius at CM.
Isn't this a violation of planning law (zoning in the US)?
This tool really improved my Windows 10 experience and lowered the idle load to 5%

https://github.com/ChrisTitusTech/winutil
I'm not religious, I find those ways of thinking idiotic - but his line of thinking is childish and arguably is what has lead to a lot of current societal decline.
In my experience MSIX is the typical MS Windows project where it sounds really cool and looks well documented and supported until you actually try to use it. If you're on the beaten path, like a mobile app port for the windows store, it's probably fine. But if you're trying to do anything out of the ordinary you have to start doing Microsoft archaeology to figure out why something doesn't work.

For example certain build configurations would cause the runtime runtime to be somehow slightly different from the build runtime and it would trigger control flow integrity to immediately kill the app on startup which was very difficult to debug.

Also from documentation it looks like it's possible to install a background service and communicate with it over a named pipe from another application in the same package but in practice I don't think it's actually possible, even in a full trust app.

I think the goals of MSIX and the App SDK are good and I applaud them trying to make it flexible to support every kind of app, it just hasn't had the time or resources put in to be really worthwhile over just using NSIS at present.
Show HN: Hetzner-k3s v1.0.1 is out with autoscaling support
This is the newest update to my CLI tool to quickly create cheap Kubernetes clusters in Hetzner Cloud.

This update adds autoscaling support, so clusters created with this tool now can behave similar to managed Kubernetes clusters, which I think is awesome.

I received a lot of feedback since the last update so I hope anyone interested could try the new version as well.

Thanks a lot for the feedback so far!

The repo: https://github.com/vitobotta/hetzner-k3s
Many people who believe themselves to be anti-capitalist are in fact blinded by the capitalist myth that money can take the place of historically reliable pro-social behavior. "A good, prosperous life" is the result of many people collaborating in a trusting, honest environment, not "a community of fairly compensated people".

People playing games with social justice seem to think that they can simply pay away problems like theft and ignore the ensuing consequences of large scale societal distrust that occur afterwards. When you leave they'll be more unhappy about the loss of your money than they will about the loss of your predictable, nonviolent daily habits.
Exactly this. Combine with Bullet[1] to detect problems early.

[1] https://bhserna.com/tools-to-help-you-detect-n-1-queries.htm...
> People's associations are part of their actions and a relevant part of the context of their writing

Yes, but it's not relevant to the correctness of their argument. Are we here to talk about the argument or the author?
>Give the phrase "There's mud all over the shop." a try. //

In which dialect of English is that an idiomatic expression? Never heard it before (en-gb native). What's the interpreted meaning??
I really wish this been originally called the “1+N problem”, not “N+1”. That naming makes it much clearer to me.
Society seems to value the appearance of effortlessness whether it be skills, fashion, knowledge, social graces, etc. Grandparent's criticisms are just more specific versions of calling someone a "try hard". Presumably they are punching down on people who appear to be trying a little too hard to be funny.

It's a shame. Being entertaining is a skill that has to be developed and sometimes it's going to look like quite a lot of work and won't be entirely successful. The audience isn't sympathetic, though, and will cry "cringe" and muse about whatever deficiency you must be making up for.
Tell HN: I found a correlation between chess rating and depression
I'm not sure if I'm totally correct but that's a fun fact.

I suffer from mood ups and downs, and but everyday (usually when I eat) I play blitz.

The thing is that the rating that I have, quite a lot depends on my mood. Which is maybe obvious, but I can see it on this chart:

https://share.cleanshot.com/480sYN5Z

By this chart it's possible to understand my mood, concentration, cognitive things and all that.

When the rating swing in a range +- 50 it's okay, but when you loose 200 points it's usually due to something wrong with you. For me it's certainly depression.

That's it, just a random fact that probably true. Probably not. Not scientific. But recently I coulnd't get from 1730 to my previous 1900+ for weeks, loosing all the time
This is specifically just a problem with all ORMs. They attempt to solve the object-relational mismatch and fail because these two concepts (sets of tuples and graphs) are completely orthogonal.
Do the textbooks for any real science have examples of this kind of propaganda, or is psychology special in its need to lie to undergraduates?
If you asked the early Europeans coming over from Europe to North America if they regretted leaving I'm sure many would say that they did, and in fact many did return. That doesn't change the fact that a substantial number of those early arrivers did stay for the long run.

There may even be failed attempts where everyone dies in an accident as there were failed colonies.
> Hmm ... in any state or locality, the same terminology is used

Within the locality maybe, and not necessarily even then. State AGs bring suits all the time, how many news articles can you find referring to those suits as the government suing someone? I think none.

These are typical examples

https://www.businessinsider.com/donald-trump-eric-trump-dodg...

https://spectrumlocalnews.com/nys/capital-region/environment...

https://www.bizjournals.com/seattle/news/2022/11/01/ag-fergu...

https://bringmethenews.com/minnesota-business/ellison-sues-t...

Sometimes you might refer to "the state" (Which USVI isn't, so that doesn't make sense), but generally you will speak of the AG by either their name or "New York AG".

> And how often does anyone anywhere refer to the USVI attorney general?

If you search news.google.com for "epstein jp morgan", you will find that they generally do so every time. Even local USVI news don't speak of "the government".

Besides, this is USVI litigating in federal court. In that context USVI obviously can not be "the government", even if they might be in USVI courts.
"at some point growing population is unsustainable"

This is a logical fallacy that has been bounced around, in catastrophic terms, for centuries. (see Thomas Malthus [1], "The Population Bomb" by Ehrlich [2], etc.) Ehrlich went as far to say that in the 1970s, HUNDREDS of millions of people would starve. Did that happen? No. These ideas about some theoretical limit on food or resources of the Earth are alarmist and do not benefit the public discourse.

Sure, maybe the Earth has a limit to how much population it can support, but it could easily be 100 billion. Who knows? Do you know that the entire population of the Earth can fit in an area the size of the state of Texas, in single family homes? [3]

In contrast to the disproven "unsustainable growing population" idea, depopulation and the aging of the population will have severe consequences within the next few decades, and already has had negative consequences in places like Japan [4], Italy [5], and many others.

We definitely need to deploy policies to increase the number of births to address these issues.

[1] https://www.britannica.com/biography/Thomas-Malthus
[2] https://en.wikipedia.org/wiki/The_Population_Bomb
[3] https://theblogmocracy.com/can-you-fit-the-entire-world-popu...
[4] https://www.bloomberg.com/graphics/2019-japan-economy-aging-...
[5] https://www.bloomberg.com/news/articles/2020-02-12/italy-is-...
> On the other RGGI never describes how the money they are taking are actually reducing CO2 anyplace on their website, the last I looked. It is all about trading credits.

Yet 1 click from your link took me here:

https://www.rggi.org/investments/proceeds-investments

> Released in May 2022, The Investment of RGGI Proceeds in 2020 report tracks the investment of the RGGI proceeds and the benefits of these investments throughout the region. The lifetime benefits of RGGI investments made in 2020 include:

> $1.9 billion in lifetime energy bill savings

> 6.6 million short tons of CO2 emissions avoided

> These benefits are limited to the direct benefits arising from specific 2020 projects, and do not include larger macroeconomic effects that may occur as a result of the RGGI cap and market signal.

But, even if that wasn't true, the mmain purpose is to efficiently allocate the diminishing amount of GHG releases in the economy. That's why some carbon taxes just get returned to the individuals.
Going forward, when I hear the critique that Linux "has too many things to customize," I am going to point people at these comments. I am so glad that I got off this rollercoaster.
Basically, what you're asking is if we plant a time bomb, does it become morally neutral at a certain, sufficiently long time value, whereby it doesn't kill anyone who is alive today?

That time could be a lot shorter than 150 years. Say a one-year-long time bomb kills someone's newborn infant, and only that infant. When the bomb was planted, that infant hadn't yet been conceived. Of course that bomber is going behind bars.
one of the things I continue to find hilarious is how much we got recruited at my uni for work in financial industry. My school is in St. Louis, and D3 sports. Every year someone from one of the trading firms up in chicago would roll down (and started to be alumni) and talk to all of the business athletes. They'd go after the ones with good but not stellar grades. They didn't talk to engineers as they figured they had jobs already. I eventually asked... WHY do you show up every year.

Turns out they needed smart kids who could deal with pressure and who were PHYSICALLY LARGE. Why not the smartest? they already had good offers elsewhere. Why large? because they trained them up and tossed them in the pit. They loved the 6'5" kids from football and basketball. They took our football center who was 6'9" 375 and had a 7' wingspan and could box out like no body's business. He told me later it was easy once he got the math. He'd just stand in the middle of the floor, he could see everyone on the walls, and when surrounded, could make space but also just reach 3-4 levels of surround deep to other people and hear them more easily as well.

"This is their entree into a career, use what you got kid".

I don't know why but I just get a chuckle out of seeing my giant buddies in suits, but also of a place that physical attributes actually help in a mostly mental activity.
> an expanded social safety net would make it significantly less risky to pursue art

Paraphrased: workers should be taxed so that we can 100% subsidise some other people’s dreams.

Fuck that.

I accept our society should subsidise some: art (I do like the BBC, especially so because I don’t pay for it), or music (I like CreativeNZ videos), or sports, or hobbies (HAM radio spectrum), or open source (yayyy), or even subsidise sitting around doing nothing (society should not demand all our time just for us to survive).

But the idea that society should subsidise everyone to follow their dreams is simply unworkable. And if you want to start ranking which dreams are worthwhile, well, society ends up with systems such as we already have.
I was inclined to say "speak for yourself", but then that would have been rude and your username indicates we are living half way across the planet.

Things are different on this side of earth, rest assured.
I have paid extra every single time.

Further, there is always things like "parking available", but then either its not free of charge or always busy or its....public parkings.

Same with internet access. Available, if you pay and if its tourism months.
And the internet you get comes from a router in the hallway and is shared and at times it seemed like it has the capacity for one concurrent user.

Airbnb enables hosts to publish such things in the name of revenue.

But if a host gets in trouble, they have a half arsed wannabe collection team which will drop them like a hot potato soon.

There are no reviews of truthfulness of the offers etc.

If you have had a good experience, then irs thanks to the host, not thanks to airbnb.
Right, with the smart dampers I dream of they would just be placed as register covers throughout the house, and would communicate with each other and the furnace to regulate house temp. So they would never try to close many at once, it's more like the cold room opens wide and the rest close a little bit.
Apparently, even outside of US since it mentioned non-US employees in the benefits section.
In any day and age, education for the elites is only in part about what's actually useful. The other part is there to segregate itself from the hoi polloi - and it actually makes more sense for it to be something not immediately useful precisely so that it's a clear marker of status: "I have time and money to learn this, of all things".
In a language like Rust or OCaml with exhaustive pattern matching on algebraic data types, the initial example is the recommended approach, because you will never miss a case, it forces you to think through all possible cases, where as the later refactored example in the article do not have such a constraint.
The Mac Studio is what the Trashcan Mac Pro tried to do. Only through efficiency will you get something that almost gets everything right of what the trashcan tried to do.

Putting two GPUS in a tight spot and the limitations of the time basically doomed it to failure but now we have much better data rates and better iGPUs.
Working on an evidence-based 8-week intervention around values & meaning-making in the style of MBSR:

nosmallplans.io/mindful-values

Mostly non-tech projects for me this year :)
I might use this in a VM, where I typically only want the bare minimum of features. But this won't block all of the ~spyware~ telemetry built into Windows, and I definitely wouldn't run it on a real machine.

Right now I'm using Windows 10 Ameliorated[1] in VMs, which is much more lightweight than the official builds. I haven't done any deep inspections to see if itself introduces some spyware, but it works fine for my purposes. Has anyone done any research into this build and know if it can be trusted?

[1]: https://ameliorated.info/
Regarding frameworks: Things like frameworks have utility in large scale web applications where you need to manipulate a lot of data on screen on the fly. Using the right framework for the right thing can make development and maintenance fat cheaper and faster.

That said, using a framework because other companies are using frameworks is definitely an unnecessary layer of complexity, and most websites don't need to be using React or the like.

Regarding UIs and Designs: companies want their sites to look nice and so they hire designers who may or may not be trained to design for the web. Print design and web design are very different disciplines. You can end up with really strange and poorly performing sites when a design doesn't match up with the reality of browser rendering.

Regarding sites that have huge payloads: this is almost always a product of management/marketing input, and payloads end up ballooning when someone says "can we just add an X pixel" or "can we try this one new piece of tracking software." Is the complexity there necessary? Probably not, but when multiple stakeholders have say, this is probably going to happen.
Many inland Antarctic bases are effectively unreachable for months in Winter. Flying a plane to the station in total darkness many thousand of kilometres in -80 C is a good way to end up with more people killed than you are trying to save.
Definitely not new- when I purchased the home, my attic had a box with HOA board member documents from the 1980s.
Ok now this is impressive and absolutely new to me.
One of my Iranian colleagues back when I worked in an office had many entertaining phrases, like:

"I go make some shoppings"

"Time for go"

Naturally, the rest of the gang picked them up and used them. I still say them to the consternation of others.
This is just senseless hating IMO. What is wrong with KMail? KolourPaint? Konsole? Ktorrent? KSudoku? These are all straight forward and descriptive. Nobody bats an eye at "Gmail" but KMail makes people lose their shit apparently. Come on.

And of those that aren't plain and descriptive, most of them seem inoffensive. What makes Kate such a worse name for a text editor than "Vim", or "JOE"? What's so awful about a PDF reader called "Okular", when the competition is named named after southwestern construction materials and trapeze artists e.g Adobe Acrobat? At least 'Okular' suggests the program is for viewing something. Corporate brand can be as bizarre as the strangest KDE names, the only difference is what you're acclimatized to.
Love kdenlive. (I've been pronouncing it kay-den-live, but ymmv.) Terrific video editor that I've cut lots of footage with. Just keeps getting better, too.
Ah, that’s more clear, yeah. Thanks for clarifying!
Thanks! It was the first time I gave a public talk to programmer peers so I was quite nervous :)
I'm a inetcpl.cpl man myself
Foreign currency can be less straightforward.

Admittedly a number of years back, a Canadian company paid me for a photo of mine they found online that they wanted for an article.

Ended up having to go to a human bank teller to deposit it.
All they'll get is a strong ID on your exit node. That node is, of course, shared by a ton of people and so trying to pick apart the traffic is going to be very difficult
Our 2022 Waterloo co-op term: In which organising words is a labour of love
Ask HN: Anyone else regret leaving an old job for a new one?
I just recently joined a new company for about 15%+ pay and full remote (old job wanted me 1 day a week in the office) and I feel a bit of regret.

I miss the comfort of knowing everyone in the company and miss having all the relationships I built over time there.

I miss just being able to disappear for 2-3 hours midday with no one really being bothered by that.

Anyone else with the same feeling? What should I do in this situation?
We could've afforded one or two more, but we stopped at two because it was a good balance for us between work, family, and personal interests. Neither one of us wanted to be a full time stay at home parent, and neither one of us wanted to subsume ourselves and our lives to the basic biological imperative just to have a bunch of kids.

Kids are a big commitment and a lot of work. I feel like having two gave us enough leeway to have the time and energy to devote to them as individuals when they needed it. In a larger family, that might not work out as well.
why would a store exist if you didn’t have to pay for stuff in it?
Samsung takes on Apple and LG with its own 5K display for creative pros
> he claimed that because MonetDB focuses on read-only OLAP workloads, then MMAP was good enough

ClickHouse has switchable IO engines:
- read;
- pread;
- mmap;
- pread_threadpool;

The best performance is achieved with the combined method, named 'pread_threadpool'. It uses the `preadv2` syscall to check if the file is in the page cache.

More details here: https://github.com/ClickHouse/ClickHouse/pull/26791

There was also big research of performance on HDD, SSD, and Optane, comparing various methods: https://clickhouse.com/blog/a-journey-to-io_uring-aio-and-mo...

And there is a pull request adding io_uring: https://github.com/ClickHouse/ClickHouse/pull/38456 - Unfortunately, it's unfinished and cannot be merged because the CI has found bugs. Nevertheless, the advantages of io_uring for analytical databases are negligible.

The `mmap` method is still useful. For example, for data import. See here: https://github.com/ClickHouse/ClickHouse/pull/43927
Chances are they won’t block IPs in the countries they have employees, and/or they’ll require a VPN for them.

I’m honestly a bit surprised to see so many people attempting to counter the idea that some businesses don’t need to be accessible from every region in the world.
Some pretty good stuff leading to work on computing that can survive societal collapse.
Same as everything grifters do: grift.
That hasn’t been my experience. Most people around me seem to have mental checklists, and new things get added to the bottom of those checklists, not the top.
Careful with how you're enabling the space heater, many smart plugs aren't designed for space heaters (or other high amperage devices). Though there are plenty that are.
BRB, increasing Bitwarden vault iterations.
It varies from time to time. You can also switch to the few-shot mode to try machine translation, code generation, or other tasks involving longer responses
A while back I built a linux box for bioinformatics and was happy with the performance [1]. You might need to look for suitable main boards to support your RAM requirements, though.

[1] https://www.ecseq.com/blog/2020/Whole-Exome-Analysis-on-a-Ma...
I'm no expert either, but I consider the likelihood of distilled water being neutral-to-good to be pretty poor. I can't really imagine naturally-occurring freshwater sources without minerality of some kind, and so I thus expect evolution to "expect" that minerality in water at the organism level.
And you can do it with a state monad in Scala too.

But Odersky's point is that (at least in Scala) it is even simpler (and thus should be preferred) to do it with raw (but still local!) mutation.

https://www.youtube.com/watch?v=QRcD9Zc7eq4&t=943s
A cartoon I saw years ago shows two men sitting at a table in a café. There's a book or two on the table. One says to the other: "Why you be not happy with me as translator of books by you?"
You're still trading O(1) by O(N)... SQLite still has to read from the disk, it's still multiple orders of magnitude more expensive than a memory lookup.
> I know this will be an unpopular take but property crime like shoplifting is not a "victimless" crime against evil "corporations" and when it allowed to occur unchecked it creates an over all unsafe condition for everyone.

I have trouble taking anyone seriously who claims those are "victimless crimes". There's little common ground I can find because their fundamental facts tend to be so backward. Shoplifting ruins people's livelihoods and corrupts the social contracts of a society over time. It gradually erodes the living standards of people living in an area.
Show HN: AI generated conversation starter with Siri