skysight-inc/HackerNews huggingface dataset:
1. Picking a random sub-range is not the same thing as random sampling. See other comments here and all over the Internet.

2. To truly random sample k out of a set of n rows it's needed to know the set first.

3. Walking the rowid B-Tree should be relatively fast (and necessary because of 2.)

It may be the case a sub-range is good enough (e.g. the table is quite disordered relatively to the properties looked after). But this is very unusual and you should warn the users of this data because later on they might change

Imagine your sub-range picks rows created over the weekend or some other particular time-frame. Or an import from some other legacy system. This will not be representative of the full set in many ways.

If the system needs to do a lot of sampling queries, perhaps it would be better to make overnight an auxiliary table. You can make many sample tables and compare which ones deviate less from the actual table. This table will be small and could even have materialized views pre-computed with the most expensive computations.
This is less about the practicalities of "what currency are they charging me?", which is rarely if ever a legitimate concern of a customer. This relates more to the presentation of the menu itself, where excluding the dollar sign is something posh restaurants do, and many others imitate. As for why they do so, I don't know of a reason beyond the appeal of minimalism
I'm not sure it wouldn't be as barbaric at least if that word means human suffering and death. But I agree it's the future of war.
No facts, no numbers, just opinions and vague insinuations. I’d like to see a real breakdown.

In my home state of Maine our power grid is owned by a Spanish conglomerate which seems to be engaging in cost cutting and price gouging. We’re trying to convert it to a consumer owned utility; we’ll see if that helps.
It's still possible!

It'd help us to open the watch, naturally, but we can still rely on pics. Make no mistake though — the watches can be 99.5% perfect, but (at least for the watches we're handling, which have high values) the compromise in manufacturing processes is spotted one way or another

It's worth pointing out that the discussion about replacing pieces of a fake watch with authentic pieces (making a so-called 'franken' watch, as rep watch connoisseurs call it) is a totally separate discussion
> Our government's ability to bail out the economy, protect its most vulnerable.

How did the bailouts in 2008 help the vulnerable people who were subjected to predatory loans and lost their homes?

> Nevermind the fact that cryptocurrency is destroying the environment. That's just a minor detail.

Can you back this up with any data? Just went through a paper published on this topic by a couple of environmental researchers and the methodology was quite awful, and the authors did not understand mining.

I'm happy to discuss any data you have.

I'm a bit pessimistic because you don't sound open to the idea that cryptocurrencies have any value at all.
I don't want to have any non-maximized windows on my screen. I despise overlapping windows, and I want every single application I run to be full-screen, just like on a phone.
The username would seem to provide a golden path for harassment. The reason, though, makes sense.
No they aren't. I got two pairs of jeans from the same (house) brand in the same store at the same time. I tried on one of them in the store, and naively assumed the other would fit too.

There was a 5 cm (2 inch) difference.
You can already do that with Android.
Lots of fakes on eBay

They started efforts to curate that, but it's far from cleaning eBay 100%

What you're saying happens, more often than we wish it'd be the case.

That's why we never considered charging for our guides, even something as little as $1 → The point was to allow people to inform themselves about fakes, with as little friction as possible

That way, if we bump the % of people who get scammed by even a few negative points, we'd still be happy for a positive contribution
At least oilprice.com wears its bias on it's sleeve. The calmatters article is pretty light on actual analysis too. Here is the actual report from the California Public Utilities Commission that both these articles are based on:

https://www.cpuc.ca.gov/uploadedFiles/CPUC_Website/Content/U...

It projects an increase in electricity rates slightly hither than inflation over then next 10 years.
How do they have nothing better to do than this???? Who is directing them to put resources towards this? How is protecting entrenched academic journal profits a priority for the FBI?
You're defo smart with what you're saying

But the challenge would then be to explain something like this to the average non-techie who's just buying some expensive sneakers because they're cool
If you use the cascading Application Menu widget, Win -- Arrow Down -- Arrow Right gets you to the recent files menu.
When we have >90% renewable energy, or maybe lots of peaking solar that goes unused, and desal plants driven by that renewable energy, I will happily support incentivizing chip fabrication.

But until then I have other priorities.
> Check your math again: this isn't true

I used data from 2018, which I understand can be outdated now. But then you can split China in four parts, the argument doesn't change. If the problem is the total amount emitted by any political division of people, then splitting it in multiple parts should solve the problem. It doesn't.
It's exactly what we aim for!

That's why we never considered charging for our guides, even something as little as $1 → The point was to allow people to inform themselves about fakes, with as little friction as possible

That way, if we bump the % of people who get scammed by even a few negative points, we'd still be happy for a positive contribution
> but double-blind peer review and a culture of publish or perish has lead us to things such as the reproducibility crisis

The "reproducibility crisis" is that we recently realized that ~half of published results in many fields fail to reproduce, presumably because many of them are false. My impression was that this goes back as far as you care to look, and that old results are just as likely to fail to reproduce. So the only new thing is that we noticed this, which is a step forwards, not back. Is there reason to believe that older studies tended to be more accurate?
Show HN: Ghostmark – Postmark newsletter service for Ghost
The important bit with imitating a site like HN is not imitating the UI...but the UX. I don't visit this site for the page layout but because it loads 10x faster than every site trying to copy it. Don't implement loading animations, when the site is fast enough you won't see them anyway.

So basically the trick is to take a site like the new reddit.com, looking at it very carefully and then doing everything the opposite way.

(I think the overall design is fine though)
Thanks for sharing! I do think that reverse situation is an often overlooked problem; though, one that I've never found to affect me personally.

I honestly don't know enough about Snap or Flatpak to really comment on them and their advantages and disadvantages. I've always shied away from them because I can't shake Xzibit in my head, "Yo dawg, I heard you like package managers so we put a package manager in your package manager!"
Yeah it's a bit of a shame that there's not more investment into tech startups here. Bristol seems to attract much more of that scene. Swansea seems to have more than Cardiff, possibly because it's slightly further from Bristol. I think there's pretty good support for starting your own small business here, but there's a bit of a gap after that which I imagine restricts the opportunities somewhat.
The disparities are certainly a big concern to be rectified, but the overall cost analysis -- as usual -- neglects the unpriced externalities of carbon emission on the state. Obviously that's a bigger problem than the state itself can solve, but all cost analyses will look bad if you don't include the cost of what's broadly happening to California's climate due to past and ongoing carbon emission.
/u/not-math put it perfectly in the reply
Is some of that olive oil adulterated with other cheaper oils like sunflower oil? This is the thesis of the book Extra Virginity: The Sublime and Scandalous World of Olive Oil
Not a fan of furry, but wouldn't mind as long as they keep that stuff in their personal life outside of work.
Part of the reason might be the low usage of electricity in California, especially as a percentage of income. I think it's number 48 or so of the states.

Perhaps low (by comparison) use of A/C? still high use of natgas heating?

Between electric cars and the ongoing push to make natural gas verboten, perhaps this will change.
> 2% cheaper

Unless it's a really big ticket item, going to another store to get it 2% cheaper would almost certainly be a net loss (due to the time involved) vs. just buying the first thing you see at a slightly inflated price.
Dragging windows is extremely slow.
> Apple always does what is in the best interest of Apple. Everything else is just marketing.

I don’t truly believe Apple is interested in user privacy as a core value but it is a hell of a differentiator compared to Google. On this topic, my interests and theirs happen to align for the time being.
Elsevier is a pretty big company offering lots of different products and services[1]. I suspect even Elsevier is smart enough to see that the current publishing business isn't sustainable and are trying to pivot into something else. The profits from their publishing arm (which is undoubtedly a lot more than 38%) is no doubt financing a lot of that pivoting

[1] https://www.elsevier.com/solutions
Why do you assume the customers are offended? Why is it necessarily the case that people are insecure and sensitive and can’t tolerate jokes about themselves. One of the most beautiful things in the world is a roast where people bring on the onslaught of attacks.

It’s the same reason most animal play and often wrestle; the simulation of fighting in a safe ways cultivates skills, strength and confidence for the eventual and inevitable real fight. It’s not possible to go through life without being mocked or criticized. We could chose to see this as a valuable catalyst of resilience a d fortitude.

- sincerely
Seymour Butts
> find these small town gems in the US

Often the local subreddit is a great place to look. Also, old trip advisor Q&A threads if it is moderately touristy. (But not reviews)

I really like the Eater guide. Especially their posts where it is popular local chefs talking about their favorite restaurants. These posts aren't usually highlighted to you have to go digging a bit to find it.

Local youtubers are also great resources, if you know how to find them. The fewer subscribers the better.

Yelp can work sometimes. Yelp's top restaurants are usually 'mass appeal' places. If there is a top rated restaurant that looks totally out of place, it is very likely a local gem.

If nothing works then go for the classic combination: "Locally owned - Long queue - Fast service"

Special green-flags:

- Ethnic restaurant has more ethnic people than white people.

- Asian restaurant only has photos and no English menu

- Indian restaurant is full + a 3 star rating on Yelp

- Ethnic restaurant does not have the name of the home country or cuisine in it.

- American restaurant that's open for only half the day, or till supplies last
I love going into my local Ace Hardware stores. I have found that these are usually staffed by older/retired guys that have been there, done that, and they are eager to assist. In fact, one guy would recognize me and ask what "crazy" thing I'm trying to do now. This is all because the first time we interacted I was attempting to build a "portable" 25' long suspension cable system for a camera rig. We probably spent 2 hours looking at all of the doodads they had available (of course he'd help other customers when needed). However, we did spend a lot of time just chatting about random projects. At the end, he asked if I'd show him the result of it when finished. It was sad day when I learned he had passed away. Kind of like losing a distant relative.

Show me where Amazon or whatever online shop can emulate that.
From the article:

> Forget lasagna, pizza, spanakopita and lamb souvlaki -- they are not on the daily menu of those who live by the Mediterranean seaside.

> The true diet is simple, plant-based cooking, with the majority of each meal focused on fruits and vegetables, whole grains, beans and seeds, with a few nuts and a heavy emphasis on extra-virgin olive oil. Fats other than olive oil, such as butter, are consumed rarely, if at all. And say goodbye to refined sugar or flour.

> Meat can make a rare appearance, but usually only to flavor a dish. Instead, meals may include eggs, dairy and poultry, but in much smaller portions than in the traditional Western diet.

> However, fish, which are full of brain-boosting omega-3's, are a staple.

That's definitely not today's Mediterranean diet. Maybe it's what Mediterranean diet used to be 70 years ago, but as Mediterranean countries became richer, so did their diet.

Refined flour bread is present and consumed with almost every meal. Meat is very regular too. Foods like lentil soup and bean soup are eaten with lots of bread, cheese, and other side dishes that make it much less healthy.
The price of energy is low using nuclear power.
Despite the name, the Linux Foundation covers a whole lot more than Linux these days, including a variety of industry vertical orgs with both industry and vendor representation including (off the top of my head) motion picture, finance, healthcare, energy, automotive. So this is actually a pretty good fit. The general idea is to start out an org like this as essentially an MVP and iterate and grow over time.
I was under the impression that flax just gives you ALA not EPA/DHA, so you won’t get all the benefits of fish/krill oil with flax. The latter two are the ones that give the biggest benefits.

Eg https://www.nordicnaturals.com/healthy-science/is-eating-chi...
Honestly I just 'hamstered' all the material I could on the most popular items.

In the beginning, in those first 10 guides I mention in the article, I just curated all the splintered bits of info* from the internet into one mega-guide, and added what I found after analysing fakes

* bits of info from as little as a forum thread comment, lost on page 48, to a full-blown attmept at a guide that, to me, wasn't exhaustive enough

In time, it refined to partly what I did in the beginning, and partly our own research which got better with exercise

Package all that info in a free, properly formatted guide (with some imperfect English, I admit, as we're not natives), and that gives us the traffic figures I screenshot'd
I think it was him being a bit tongue in cheek - and maybe assuming food on menu's = less good.
> What is it is shown millions of the victims are actually just kids that idolize musk

Just to be very clear, even if everything about your argument was correct (which I don't grant), you're talking about hypothetical future victims, in a hypothetical crypto crash, because Dogecoin (along with the rest of crypto) is at a dramatic all-time high.
Especially when one of Apple's main points is that the app store ensures a secure environment for their users to download apps. If they ended up verifying this many unsecure apps, then what's the point?
That's actually interesting.

You have to wonder what low-hanging fruit is coming up by combining mass sequencing with medical (and other) history.
No self-respecting Greek mom buys anything else other than Extra Virgin Olive Oil.

If it does get adulterated illegally, I don't know. But haven't heard of any scandal like that.
i see nothing wrong with this.
I can't imagine eating olives without some focaccia or ciabatta to dip in the oil. With balsamic vinegar, naturally.

HN = Hanger News, today.
One store I frequented was owner operated with probably their daughter as an employee. They would walk around with a cordless phone on their hip so as to not miss a call. If there's enough interest, people find a way.
Spaniard here. This is the exact situation in Mediterranean Spain, at least. At home, we only have olive oil, which we buy in 5L bottles.
Windows/MSVC has _byteswap_ushort(), _byteswap_ulong(), _byteswap_uint64(). (note that unsigned long is 32 bits on Windows) It's ugly but it works.

Boost provides boost::endian which allows converting between native and big or little, which just does the right thing on all architectures and compilers and compiles down to a no-op or bswap instruction instruction. It's much better than writing (and testing!) your own giant pile macros and ifdefs to detect the compiler/architecture/OS, include the correct includes, and perform the correct conversions in the correct places.
OP here.

A pretty fair model if you ask me! I think generally we move more towards that model as the internet progresses

To me, before starting this, it looked like all the ones who made a noticable bump did it this way. It's why we hate Instagram gurus, I'd say
Yeah but MS could actually call this library what it is, not leave it to multiple levels of inference.

And don't call me Shirley!
all the "string theory" means is that you cannot parse html completely or check its validity with a SINGLE regex based on a standard nfa or dfa.

the reason why is that standard nfas and dfas cannot implement arbitrary counters for the purposes of keeping track of recursion depth or "how many open parens are currently open right now in the parsing?"

there are a few subtle points here:

1) you CAN parse and validate non-regular languages by using regular expressions for subsets of them that ARE regular and then validating the whole. this is exactly what most parser generators generate.

2) you CAN use regular expressions to manipulate text in regular languages if you are careful. however, you should be extremely cautious, as non-regular parts of languages are often those that are used to support escaping or quoting or recursive sections of languages and subtle bugs in these sorts of things can sometimes have unintended consequences in terms of security.

3) you CAN use regular expressions for simple search and replace but see #2. if the language allows escaping or quoting, your regexes will not respect it on their own. this may have the unintended consequence of things you expect to have escaped not be escaped or vice versa. depending on other assertions in your project, this may or may not matter. in the worst case, it could result in a hard to track down or security critical bug.

4) regular expressions are implemented by simulating nfas and dfas. sometimes when implementing these simulations, programmers take advantage of the fact that they're programming and just slap counters in there giving their implementations the ability to support some non-regular languages.

as a rule of thumb, if i'm dealing with untrusted input, i'll use a proper parser.

so yes, you can use regular expressions, but you should understand their limitations if you do so. (which also means understanding your input language)
How to Buy Network+ certificate online without exam?
Babashka tasks: a task runner inspired by make, just and NPM scripts
If you're ever in London I'd definitely recommend it, interesting history, it's a private members club now (the restaurant is open to public bookings though) and the building has a storied history, being a brothel and the one time abode of Karl Marx at certain points.
Is Comcast having an “ad hoc CM Crisis?”
Received a boilerplate customer agreement email from Comcast Xfinity. There's not much point in even reading these, but today's had an interesting query string:

https://www.xfinity.com/Corporate/Customers/Policies/SubscriberAgreement?rid=666&mid=20210508_Adhoc_CM_Crisis_UpdatedResiSvcAgreement

Are they having an "ad hoc CM crisis" we should know about?

(p.s. I redacted and replaced the original rid value, since I suspect it's PII.)
Using an analogy, let's all wave "Defund Healthcare" banners!
Is it worth anyone pointing out that early termination of life is a sufficient punishment; and it does not need to be painful.
Apple is claiming that their App Store is secure and rigorous. If developers (maliciously or not) were able to add code like this to their apps then doesn't that mean someone was able to hack the App Store verification process? And if they were, is it not Apple's responsibility to inform their users that their devices might have malicious apps?
> The code the compiler generates must have the same final result, but it doesn't have to actually work the same way.

You're obviously correct, but I think this ignores downstream costs of sufficiently magical compilers. If my compiler tunnels into a parallel universe, executes the code there, and returns the result, that's fine, but it's going to be enormously painful to debug.

Obviously very few developers (including myself) have an appropriate mental model of highly complex, speculative processor architectures that end up executing their code, but I do think there is at least some benefit to having a correspondence between the code you write and the code the compiler generates.

Maybe it's not a problem with the compiler, but a problem with languages. Maybe we just need better languages?
Why would it have evolved a response to communicate to a predator species that one of the predators living in a dwelling is going to die in a fashion that would expose itself to a large chance of becoming prey.

Here is a far simpler explanation. Our brains are evolved to find patterns even when they aren't there. Look how weak the correlation is. His family simply discarded all the times the correlation failed to apply and remembered the one time the bird cried not on the day his grandfather died but merely that same year.
Direct PDF wasn't working for me. Here's the page with summary and link to PDF: https://www.brookings.edu/research/what-lies-beneath-evidenc...
I wasn’t able to find a way to your customer experience/UI workflow the first time I read the article (which is odd - you have some words that seemed to clearly be intended to be links to it, but they were dead to me). Second time, I just went to your footer to your holding company, and was able to figure out the actual product from the list there. I didn’t download it though. I also figured out that some of your links ARE live, just not the ones I expected, and will take me to the app. Despite being interested at the beginning, I lost momentum and stopped.

You clearly have a viable product, and have already started doing some solid sales despite having no sales (or marketing) expertise - which is great, and you’re in an awesome place!

The next challenges are finding and scaling more ways to reach customers, conveying the value you can provide them in a way they can understand at scale, and converting those ‘take my money!’ potential folks into actual orders. Then executing on them at scale, of course.

The sales and the execution side are separate sets of expertise. Managing people from those backgrounds to get what you want is also a challenge for most execution/technical founders. Most folks with your background and having done what you have, will be quite comfortable with the execution side and people who also like it.

If you think of it as a computing system, you’ve got a great 32 core machine with an awesome GPU and 32GB of memory. You’re bottlenecking on the 80’s era Amiga tape drive you somehow managed to boot off of.

If you get yourself even a halfway decent 20GB drive from a decade+ ago, you’ll be doing leaps and bounds more business. If you find a modern SSD, even more.

There are a number of books out there for how to do sales as a technical founder, I can try to dig one up if you’re interested.