skysight-inc/HackerNews huggingface dataset:
Sure, with SQLAlchemy Core you might start out by adding some `conn.execute` statements where necessary. But, inevitably, you'll want to use some queries in multiple places. Some of them you'll even want to use in multiple different files. Your schema will surely change over time, and your queries along with them. It would be a shame if you needed to hunt for queries across all of your files and make the necessary changes to each copy of your queries which need to be change.

It seems much more convenient to have some part of your code base, a separate module, which is dedicated to communication with the database.

The rest of your code communicates with that module through function calls and doesn't need to worry about how it's implemented. Realistically, you'll probably always use a database, but this does make it much easier to switch between databases, or decide you want to use a flat-file instead, or even use dynamodb for some high-traffic part which doesn't need much consistency.

Once you have a module, it's incredibly natural to de-duplicate queries. Instead of writing out each query once for each time it's called, you can stick it into a helper function and call that function from many places. You can organize queries by their purpose or which tables they use, making it easier to change all the queries impacted by each schema change.

In a world where you have large queries SQLAlchemy lets you give meaningful names to subqueries and different expressions in the larger queries, making them easier to understand. If you share some subqueries between queries... that module dedicated to working with your db starts to make a lot of sense!

In all, I can think of a lot of situations where "hides your queries away from the developer" is a cost out-weighed by many other benefits.
Mozilla tech brought value right? MDN bright value right? Wasm, rust etc, brought value.
But no profit.

Could it be that profit isn't synonymous with value? Just a thought.
Typically functional programming isn’t considered to be CPU friendly. Specifically typical functional programming allocates memory all over the heap, especially given the prevalence of things like linked lists and so on. This obviously makes for crumby cache performance and memory pressure. I’m not sure in what sense FP lends itself to columnar data structures, but those would obviously have still better cache and vectorization properties. I’d be curious to learn more!
Posting like this is not allowed on HN. Please read https://news.ycombinator.com/newsguidelines.html.

For more please see https://news.ycombinator.com/item?id=24145915 elsewhere in this thread, as well as these past explanations:

https://hn.algolia.com/?dateRange=all&page=0&prefix=false&so...

https://hn.algolia.com/?sort=byDate&type=comment&dateRange=a...

https://hn.algolia.com/?sort=byDate&dateRange=all&type=comme...
In NYC the boxes are already bundled and left on sidewalks all over the city, I think because they are required to make it as easy as possible to collect/separate.

Whenever I move I usually walk around a few blocks and snag a few bundles to assist as packing material. Little did I know I was actually committing a crime
I have made something similar couple of years ago, but I took down the video that I recorded doing it cause I was afraid it could turn back on me.

These days I usually try to write an email to the abusar and to the hosting services. I also did a bunch of this "flags" on Instagram ads.

Instagram is the worst, cause they open a website in their app, hiding the true URL of the phishing site. I sent a complain to them about that. Never heard back.
> Given the treatment the members of the various Abrahamic faith's have given each other over history

Quite a non-realistic view of history and people's behavior. People will do bad things regardless of (and in-spite of) religion, and we have seen it (WWI/II, the massacres of the Uyghurs, the Holocaust, etc.). Humans are bloody creatures after all.
> If you could assure them that giving up those regions would guarantee peace, you would win an election.

Eh. Are you sure you thought this through? There are about 800 thousand Israelis living in occupied and annexed territories. That's 10% of the country. Do you think they would vote to leave their homes? That people would be happy to see house and land prices skyrocket?

Come on, let's not kid ourselves: land is monstrously valuable, Israelis are reaping enormous gains from the occupation. You're pretending it's indifferent, that Israelis just want peace. But for the meanwhile they'll just keep getting more free land, thank you very much.
There’s been a fair amount of discussion and speculation here lately on what’s happening with the USPS. Now the quiet part has just been said out loud. Perhaps a useful bookend to speculations.
Great project - more power to you for driving it so far.

My 2 cents. I think rust-analyzer offers a great new dev onboarding experience. issues labelled with has-instructions usually have a a link to the relevant snippet of code in the repo and sometimes even the stub of a failing unit test. While it might be obvious to you, the author, how and where to find the necessary code, it enables a great many people to send patches.

Witness the number of contributors with <10 commits
https://github.com/rust-analyzer/rust-analyzer/graphs/contri...

If you want to increase adoption, please borrow as many dev experience tricks from rust-analyzer as possible
Huh, I knew GitHub Packages supported npm, NuGet and Maven, but had no idea it supported Docker images too.

My guess is a lot of people don't know this. If it becomes better known, I can imagine something of an exodus from Docker Hub to GitHub Packages for OSS projects.
It feels like a large amount of that research went into creating a marketable product name.
>"You should rebuild images every 6 mo anyway!" - have you ever worked with an enterprise company? They do not upgrade like we do.

No, but they've got cash and are not price sensitive. Wringing money out of them helps keep it cheap and/or free for everyone else.

Enterprise customers might as well fork over cash to docker rather than shudder Oracle.
The funny thing is this is just straight-up competition. If these guys can generate money from taking it away for free, why am I paying the city to take it away for me? Hell, if I owned a business I'd happily deliver the cardboard to these "thieves" than pay a waste management company.
It's just easier to edit in Emacs and copy and paste into Word.
Contact Form Spam n/more: WordPress
Article fails to point that Ecoembes in Spain its a defacto recycling monopolistic mafia, in Europe usually you get paid for your bottles and trash, here you have to paid a insane tax and then they sell the trash on top getting even more profit

https://www.metropoliabierta.com/el-pulso-de-la-ciudad/medio...

https://www.productordesostenibilidad.es/2016/02/ecoembes-no...
We've banned that account but please don't make the thread even worse like this. We want curious conversation, not boilerplate battle.

https://news.ycombinator.com/newsguidelines.html
Could it be that you didn't like the article because it didn't confirm your biases?
Agreed that self-hosting registries should be way more common than it is today and maybe even standard practice.

It's crazy easy to do; just start the registry container with a mapped volume and you're done.

Securing, adding auth/auth and properly configuring your registry for exposure to the public internet, though... The configuration for that is very poorly documented IMO.

EDIT: Glancing through the docs, they do seem to have improved on making this more approachable relatively recently. https://docs.docker.com/registry/deploying/
At various times in their history where AMD was behind in core design, manufacturing, or both, they cranked power (and thus heat) up to fairly obscene levels to attempt to compete with Intel. That's not the case now with Zen and TSMC 7nm - you cant really compare an AMD CPU now to one even 5 years old, much less 20 years old.
How Can I Work Better with My Product Manager, as an Engineering Lead?
I consistently recommend Hennessy and Patterson's Turing Award Talk[1] as a good overview of the past, present and future of chip performance.

[1] - This will take you directly to the meat of the discussion: https://www.youtube.com/watch?v=3LVeEjsn8Ts&t=28m10s
Very much this. Anyone who has tried to sell better defensive products to the market knows that the issue is not with the difficulty of doing things better, it's the interest and will of the market.
To the parent commenter's credit, none of those companies own the rights to the GCC/CPython/Ruby trademarks like Mozilla does with Rust.
Not a lawyer - but the act of putting something on the street doesn't make you stop owning it. If you leave a bike unlocked and someone takes it they still stole it, even if you were unwise not to lock it up.
Ask HN: How has the US-China tensions affected you?
With the US push to ban certain Chinese technology like Huawei's 5G and the announcement by Foxconn, a major subcontractor that makes Apple's iPhones, that they will move some production out of China into other countries, have you been affected?

Has the rift between US-China affected your purchasing decisions? For example, is your company concerned that TP-Link routers is a Chinese company or is your company thinking that the rift will blow over and relations will return to normal?
But it's not just 50k for a domestic property, it's 50k to dig up a road, and tunnel under a stream.

I wasn't aware that electrical connections were done for free - Citizensadvice [0] calls out that for gas if the connection is far enough away you'll have to pay for it. I've heard anecdotal costs of <£1000 for a straightforward connection that doesn't involve digging up a road.

[0] https://www.citizensadvice.org.uk/consumer/energy/energy-sup...
That's not what that report says. At all.

"Chinese scientists report evidence of an oral-fecal transmission route for COVID-19 viruses and show that, in hospitalized patients, viral RNA was found in anal swabs and in blood samples."

I.e. you find RNA in anal swabs & blood. It leaves your body that way. Which is a well-known fact, and might be very useful in population-level surveillance. It also means you should put the lid down before flushing, lest you create something lovingly known as a "toiled plume".

It does not mean you get infected via the anus.
Charging at night isn't great for using solar power without storage. Ideally, we'd incentivize people to use their car's battery to store excess solar power during the day and smooth out the duck curve (perhaps slowly recharging again at night)
A lot of cardboard has no recycling value because it is contaminated with other materials.

For example, used pizza boxes soaked with grease are not recyclable. If you're lucky and your city has a municipal composting program, they can be composted, or some places incinerate stuff like this for energy, but otherwise they end up in the trash, or worse, discarded in the forest.

That doesn't stop people from throwing them in the recycling bin though.
Finally a good use for that raspberry pi idling in the corner
Cory Doctorow has the “worst hours” of his life thanks to Find My Phone
It could potentially be theft in a legal sense, under s.1(1) of the Theft Act 1968,[1] depending on whether the jury finds that the conduct of the "thieves" was dishonest from the perspective of a reasonable person.[2] Although I do not think a jury would make such a finding in most cases, nor would the owners support a prosecution of those who provide what is essentially a free service.

1. https://www.legislation.gov.uk/ukpga/1968/60/section/1

2. s.74 https://www.bailii.org/uk/cases/UKSC/2017/67.html
You still need to protect from getting updated by errors or malicious code. For apt you have utilities to edit the keys you don't edit a test file by hand.
> It seems much more convenient to have some part of your code base, a separate module, which is dedicated to communication with the database.

That module doesn't have to be .sql file. You can organize your code in whatever language to achieve what you are describing. And have IDE help with Jump/Peek definition.
Hello, we're in the middle of switching our mailing list to google groups and I just fixed a seting that should let everyone see the mOS developers group page at https://groups.google.com/g/mos-devel/
Sorry about that, and we (the mOS team) would like very much to hear from you ;-)
Rolf
All of the money was coming from Google's antitrust lawyers.
I forgot my password, went ALL the way into my email inbox to reset, and then had to think of a new password. It was a lot, as you guys understand, for my tiktok length attention span.

But it was worth to say love the builder spirit and what you created. I'm going to try it out. Keep up the good work!
> Even malware, that should be way easier to detect and stop , way easier than to stop a pop-up asking for your credit card, pass thru their system

Ah yes, one of the scarier trojans to hit your phone: click-jacking for ad fraud.

> The apps communicate with a known command and control (C&C) server to simulate user interactions in order to fraudulently collect ad revenue.

I'd download this malware any day over the actually-malicious Android malware that's out there: https://forensics.spreitzenbarth.de/android-malware/
Doesn’t make any sense at all to go with dot net if the rest of your app is in C++ and something easy like this exists.
I'm not so sure that's a bad thing. I've never heard of it until now and just by looking at the Getting Started guide, I'm kind of excited about it: https://romefrontend.dev/#getting-started
> If the tools are there, they will be used for evil.

I use a stronger (more specific) form of that heuristic that seems to hold up well in practice:

If something evil is within technological possibility, and there is economic gain to be had from doing it, someone will end up doing it.

(Note, by "within technological possibility" I don't mean "there are COTS tools available for doing that", but closer to "physics doesn't prohibit it, and we have a good grasp on how it could be done in theory".)

I actually first figured out this phrasing of my intuition during Snowden revelations, to explain to myself why my initial reaction was a complete lack of surprise.
The Apple homepod discount: $100/£80
How much is that due to a lack of investment? How fast could we build that storage if we really wanted to? A fraction of $700B a year seems like it could really change that quickly.

Many of the problems related to storage don't seem like a technology problem. They appear to be a commercialization problem. We're not waiting on some fundamentally new tech. From elevated water to liquid metal batteries to compressed air, many technologies are all being commercialized right now. It feels like we have the ability to really push that forward in a big way.
The following distros package LXD:

* Void Linux

* Alpine Linux

* Arch Linux

* NixOS

* openSUSE

* Gentoo

There could be more. None of those distributors are using Snaps for LXD.
Why so? It is not Mozilla going around rewriting random projects in Rust.
Instagram could face $500b fines alleging it illegally harvested biometric data
> Oh and bandwidth isn't free.

But neither is storage

> have you ever worked with an enterprise company? They do not upgrade like we do.

I'm sure someone somewhere is going to shed a tear for the enterprise organisations with shady development practices using the free tier who may be slightly inconvenienced.
It's a long time since I looked, but profiling my code not much time was spent parsing / serializing JSON. Most of the time spent was manipulating dicts/lists in Python which cPython is already pretty good at since the whole language seems to basically be implemented in terms of dicsts. I don't think PyPy has the hidden class optimizations of JS engines which are able to find speedups in these types of cases.
So true, and I think it's important for developers to look up documentation on sites like MDN (consider it sites that are authorities on a subject) rather than blindly googling and ending up on sites that have a massive variety in quality. I see that all too much.
My workloads are more of an outlier when compared to the general PC user crowd, but I do keep an eye on my CPU usage and it is often between 25-100% CPU usage, depending on the situation.

Workloads, where more cores really help out, are:

* re-encoding video files to save disk space (it's amazing what speeds I can reach with my Ryzen 5 2600X here!)

* IntelliJ (startup, indexing)

* running tests (can be configured to be very parallel)

* running JS heavy sites, like Jira (you would be surprised at how resource intensive websites can be nowadays)

* running more than one Electron based app (Spotify, Slack are surprisingly CPU intensive, especially if you have poor/no GPU acceleration support)
Sometimes I manage to extract a little more performance by shutting down virtual cores to get lower thermal stress and better cache hit ratios. It's a very YMMV thing that depends on pretty much everything from the CPU microarchitecture and built-in power management all the way to the size of the fan, whether you polished the heat spreader on the CPU to the programs you are running and what the data they are processing looks like.
i wonder when the other shoe will drop. maybe as part of the ARM and iOS/macOS consolidation.

There’s no other shoe. There's no known technical reason why all the major browsers shouldn't be available natively when ARM Macs start shipping in a few months.
If it’s deleted from the App Store it will still be on their phones.

Either way I don’t think there’s a legal precedent for a class action
Large game have a different cut, imagine Fifa paying 30% on all the FUT transactions ...
Traditionally Intel's "nm" measurements have always deviated a bit from their competitors, ala TSMC and Samsung. In short Intel 10nm ~ TSMC 7nm and Intel 7nm ~ TSMC 5nm. But with the recent announcement that the 7nm will be delayed, it means TSMC will for sure take the node crown.
https://en.wikichip.org/wiki/7_nm_lithography_process

I think the most notable is part is that Tiger Lake will be a minimal CPU improvement (Sunny Cove ~ Willow Cove cores), and the main selling point will be the Xe graphics and support for Thunderbolt 4, LPDDR5, etc. Superfin seems to be marketing hype but will see when benchmarks come out.

The main question is, will Tiger Lake will enough for next year? AMD's Renoir follow up is reportedly retaining the Vega graphics but will further improve the CPU microarchitecture from Zen2 to Zen3. Techspot just published an apples-to-apples comparison that shows, if all things equal except the CPU, the AMD 4800H is 10-60% faster than the i7 10750H...that's a huge chasm.
https://www.techspot.com/review/2075-same-laptop-different-c...
C lacks the information given to the compiler to do this. It can't be added without adding that to the language. So no linter can do this alone, without language changes.
> The 10900k is better than the 3900x for gaming, but its also a ~$120 up-sell

Is it correct to think that compared by work-done-by-watt AMD is currently better than Intel? (in this example Intel's 10900k uses 250-300W [1], AMD's 3900x uses 140-170W [2]?)

In my case I use often many threads/processes (generated by databases and/or my Python programs that usually spawn as many subprocesses as possible without overloading the CPU) and as my PC/server is next to my desk then if the performance difference is not too great my priority is usually for a CPU that gets less hot/is more efficient (because the fans have to work less therefore the box is less noisy, additionally the room heats up less which makes me suffer less during summer).

[1]: https://www.tomshardware.com/reviews/intel-core-i9-10900k-cp...

[2]: https://www.tomshardware.com/reviews/ryzen-9-3900x-7-3700x-r...

Thx
those 52kwh are a few hundred kilometers of driving. wouldn't assume that to be the daily norm. say you only do 30km, you only need to charge a fraction
that's not really abrasive, it's critical sure, but something like "gates is a pompous prick" is an abrasive way of saying he's a narcissist
TFW ProductHunt Adds nofollow/noindex to Your Launch Page
Maybe add a link to the site?
Handmade Web
https://www.blog.google/around-the-globe/google-europe/prese...

https://en.wikipedia.org/wiki/BrowserChoice.eu
The protests against police violence in Portland have continued every night since George Floyd was murdered. There has been a lot of attention at times and crowds swelled to the thousands. There is no organized money behind this, especially now that the groups are much smaller (and the police brutality and intimidation has risen to new levels).[1]

Pretty sure the ruling class would prefer for these protests to go away as quickly and quietly as possible.

[1]:https://twitter.com/r2020PB/status/1293553869470015493
If someone is really going to deny the existence of an extremely obvious financial incentive for a company to lie about idea that it pushed out the CEO, then I am not sure what could be possibly told to convince that person of anything.

Someone would have to be completely and entirely lost, to not be able to see the clear and obvious motivations for a large corporation to lie about the idea that it pushed their freaking CEO out of the position.
Supercapacitors from Standard Bricks
> "We'll just ping the image very 6 mos" - you have to iterate and discover every image and tag in the accounts then pull them, retry if it fails. Oh and bandwidth isn't free.

Set up CircleCI or similar to pull all your images once a month :)
Attacking another user in this way is explicitly against the site guidelines:

"Please don't post insinuations about astroturfing, shilling, brigading, foreign agents and the like. It degrades discussion and is usually mistaken. If you're worried about abuse, email hn@ycombinator.com and we'll look at the data."

Please review https://news.ycombinator.com/newsguidelines.html and don't do this again.

In reality, the community is simply divided between people with very different views. Accusing someone else of being a spy or provocateur simply because they expressed a view you disagree with is pouring poison into the community. Lots more explanation here:

https://hn.algolia.com/?sort=byDate&dateRange=all&type=comme...
Maybe you find it cringeworthy, but I find it on topic and very relatable. The role of a speaker is to make their material easy to digest for their audience. For this audience in particular, I would argue that this example is statistically likely to resonate with most of them. So your parent commenter is strongly incentivized to use this example and conduct themselves this way, so of course they did so.

I don't think your comment contributes much to the conversation. If anything I feel it stifles the conversation. If you had shared that the parent's comment made you uncomfortable then that is a contribution that we could explore. Instead you decide to decree from the top of your high horse that his speech wasn't acceptable. I don't like what you did one bit, and I think you did it just to make other people uncomfortable and put yourself in a position of power over them.
Man, I hope MDN never goes anywhere. I've pinned a tab of MDN on my web dev machine's default browser, next to npmjs.com. As far as I'm concerned, it is the documentation for the 3 main open web technologies, and I know many would agree.
Text Augmentation Using Bert, GPT2
PrintDemon is dead, long live PrintDemon