skysight-inc/HackerNews huggingface dataset:
> It’s interesting how much SQL, a declarative language,

I think this is the main mistake. SQL is not declarative language, is a high-level DSL:

1 + 1 = 2 //most PLs
SELECT 1 + 1 = 2 //SQL
SET 1 + 1 = 2 //TCLish
[1, 2] | sum = 2 //Functional
<span>1</span><span>+</span><span>1</span> = NOT 2! //HTML, a TRUE declarative language!

The main issues that causes this is that SQL is most of the time a little piece disconnected here and there. You don't see how is so imperative and functional until you write manually a big .sql file.

Also, is crippled intentionally, so you don't use it for "regular" programming task (ie, not real way to do print("hello world")!.

I start with FoxPro/dBASE and never develop this disconnect because for me, in Fox, SQL was just another sub-dialect of Fox, that was a "full" programming language. So every-time I do:

SELECT * FROM customer WHERE code = 1
SCAN customer WHILE code = 1 //Equivalent Fox CMD
?customer
ENDSCAN

And similar how in Fox you know that your filters and sort depend on indexes then the same with SQL.

I still look SQL and see it imperatively and have a good grasp on how everything execute (ie: at least until the query planner disagree with me!).
I agree.

They haven't actually solved anything.
Was trying to draw the "Cross of Coronado" from Indy Jones, got 2001 - A Space Odyssey... There goes my artist career :)
This is often the first consideration after "does it match the behaviour of the original chip perfectly" when dealing with FPGA reimplementations of other chips.
It seems to work for flamewars and trollbait, but it also gets used to downvote opinions people disagree with even though the content itself is ok and that's a bit unfortunate.
This is not ready for prime time. This is not even ready to go up against infomercials at 4am on a Sunday morning.
Oh I agree completely. I think at the time many of us could read between the lines and see what was really happening: They were preventing a run on masks, and medical professionals needed all they could get.

I don't like being lied to, but in this case I think I have some forgiveness because the end goal was justified (at least in my mind). It's such a weird feeling though, I'm very conflicted about it.
It would be an interesting court case for sure.

Aldi don't pretend that their brands are the famous brands and they don't stock the expensive ones so making cornflakes look a little like "Kellogs Cornflakes" is probably more about customers spotting them on the shelves than trying to get customers to buy yours instead.

If Kellogs claimed trademark infringement, it would be hard for them to prove that they are losing out since Aldi would simply say that they don't sell Kellogs and people aren't in any way being tricked into thinking any of the Aldi brands are real ones.

caveat: I'm no lawyer!
What? Futons are not at all couches and great beds (for some people anyway, but I like’em). Do americans mean something weird by futons?
What if performance advertising is just an analytics scam?
It is difficult for most people to defend against weaponized anti-science. The reason is that no one can become an expert scientist in one day or even one year. First you learn elementary-school science, which by necessity involves some simplifications, and some things are left unexplained. Then you learn high-school science, which explains some of the gaps of the previous level, and improves some of its simplifications; yet it comes with its own simplifications and gaps. Then you learn undergraduate science... and after many years you hopefully become capable of understanding and evaluating the most complex scientific claims.

Weaponized anti-science attacks people with statements that sound credible at their level, and require higher level to understand the deception. This does not happen accidentally; it is constructed so on purpose. So the person with elementary-school knowledge reads the statement that seems to make sense from the elementary-school perspective (it does not contradict anything taught at elementary school), but a high-school students could see why it is completely wrong. So the person can only conclude: "as far as I can understand, it is correct... and there is this one guy saying that it is wrong, but his arguments I can't understand". Similarly, you target people with high-school knowledge with statements involving undergraduate-level deception, etc.

This is for me the most frustrating part of debating smart people who believe pseudoscience -- as far as they know (in my bubble that typically means undergraduate level of math, plus high-school level of everything else), the science often checks out. Someone who graduated in given area will be completely frustrated by hearing the "proof", because it contradicts many known and well-tested things... but to convince the person who is ignorant about it all (but is completely willing to trust his own Dunning-Kruger syndrome and Nassim Taleb's twitter over thousands of peer-reviewed papers), you need to hunt for the subtle error in the mathematical proof.
Artificial lightning zaps farm stink
Sounds exactly like a tontine to me and I should know. (Founder of https://tontine.com)
I'm old enough to remember the 2000-era of day traders, just as the internet took off and it was possible to enjoy the thrill of staring at a ticker from your own home. There was enough chaos that a minimum stake rule was made; https://www.finra.org/investors/learn-to-invest/advanced-inv...

And the seminal paper on the subject: http://www.econ.yale.edu/~shiller/behfin/2004-04-10/barber-l...

8/10 day traders in their survey lost money. But there were a few that made returns that not only beat the market but the transaction costs.

(I wonder how that's affected by fee-less trading, which instead tends to make money on PFOF and may have larger spreads)
don't grocery stores do this too?
>In a letter to Tesla, the National Highway Traffic Safety Administration told the electric car maker Tuesday that it must recall vehicles if an over-the-internet update deals with a safety defect.

Why? If a defect can be fixed with a software update over the net, it makes no sense to recall vehicles.

>“Any manufacturer issuing an over-the-air update that mitigates a defect that poses an unreasonable risk to motor vehicle safety is required to timely file an accompanying recall notice to NHTSA,” the agency said in a letter to Eddie Gates, Tesla’s director of field quality.

The risk in question is really really really low (12 crashes so far, all at least partly user error?). So I don't see how it can be seen as "unreasonable".
Wait until you hear about inherited stock...

https://www.investopedia.com/terms/i/inherited-stock.asp

Say the stock you borrow against was purchased at $10, and is now worth $100. That's a $90 increase. You get hit by a bus and die. The stocks cost for tax purposes is increased to $100 for the heirs, meaning that $90 increase is not taxed as a gain (not sure about how it's tax as inheritance).
Sorry I had to clarify that I meant in terms of budget, not headcount.
This is a terrible conclusion from a terrible experiment. From what I understand, they set up a condition where a subject had low control over an outcome (light being turned on) and then asked them to assess how much control they actually had.

Since the experiment was set up to provide low control, those with feelings of low control (depression) were more likely to be right. If the experiment was biased to provide a lot of control, the depressed would not be "realistic" - they would under-value how much control they actually have.

Maybe I am misunderstanding the experiment but that's what I see.

In reality, you have a TON of agency in your life where your attitude drives the outcome. Eg - if you are depressed and out of shape, you will believe "I can never get fit" so you won't bother getting off the couch and this your pessimistic prediction will come true. Meanwhile someone else can believe they can do this, get off the couch and start exercising. So they will then make their own prediction come true.

In the end it's as the serenity prayer says: G-d, grant me the Serenity
To accept the things I cannot change...
Courage to change the things I can,
And Wisdom to know the difference.

Nihilism and depression are no more realistic than mindless optimism. But if you had to chose one, chose action because it can drive change
> In a store there is only one vendor: the store.

By “vendor”, do you mean the one providing it to the customer? Because Amazon does that to with their FBA service.

The vendors I’m talking about are ones like Frito Lay, Nabisco, Coke, etc. The vendors deliver the product and (sometimes) put it out, but the store knows what’s selling and when. If the vendor wanted that information, they’d have to ask the store (through contracts), or watch the shelves themselves.

And despite what Amazon says, they’re a store. They just blur the line between store and marketplace. The “vendors” in Amazon’s case are the third party sellers. They pay Amazon a percentage of their sale for the ability to sell on Amazon.com. At the same time, Amazon sells stuff they buy and markup themselves (books for example).

In both cases, the product is commingled (white label next to name brand), and the customer doesn’t always know if they’re buying a vendor or a store brand. Amazon will tell you “sold and shipped by X”, but you have to know to look for that.
We now have forms of gambling in videos games for the last 5-10 years, a good way to teach kids from the beginning, that probably doesn't help either
Alternatively: it enourages brigading and group think. Controversial opinions, even wildly incorrect ones (think: conspiracy theories and ideological nutjobbery) are also heavily upvoted, and it's the discussion that gets buried, since the only ones voting on comments are the people invested in the discussion.

So it's routine here to find topics of general interest, and click on them to find some kind of broad conspiracist screed at the top of discussion, try to reply, and discover yourself rapidly buried.

It's a real problem. And, yes, it tends to have a decidedly partisan bent to it. There are lots of perspectives you just can't get in front of eyeballs on HN in a meaningful way, you just end up rolling in the slop with the pigs.
I would love to use MailChimp, but it was price prohibitive when I first got started. The site was using Mailgun when I acquired it, and I stuck with it after evaluating a BUNCH of options when I got up to around 30-50k users.

I don't recall what MailChimp's pricing was back then, but 50k users would be $640/mo today (vs ~$80 on Mailgun). I'm currently north of 300k users, which is up into the "contact us for pricing" range. It just doesn't make sense for a site with revenue sub-$10k (like, well sub-$10k).

I could've dropped that price by spending a shitload of time deactivating contacts and trying to keep my active users count lower, but email just isn't that profitable for me. I wouldn't say I'm great at email or attribution, but I estimate I drive ~$250-500/mo in sales through email (up from $0 when I started).

The other points are good ones -- even on Mailgun, I should've had different subdomains set up for IntroCave for transactional/campaign/newsletter blasts. I got "good enough" results doing it the lazy way, though. I still wouldn't have remembered to migrate the bounces, and this might have actually increased my bounce rate. Since bounce lists are per-domain and not per-account, a signup bounce wouldn't necessarily have prevented me from sending transactional stuff later (I've since added a bounced flag to my user model which would catch this).

(edit: actually the first point is pretty good. i disagree with the rest. list was mine, domain was warmed with a week of email before the ToS blast, and I manually ramped up volume on the ToS blast for the first 30 hours or so while keeping an eye on deliverability. This was entirely my fault, so I'm not sure what you mean by blame... I'm not happy with the customer support response, but the title of the post should make it pretty clear where the blame lies--me!)
> Independent assessors at the consultancy ADAS told BBC News that it reduces ammonia in slurry by 90%.

> The plasma process also reduces the emissions of methane – a potent greenhouse gas – by 99%.
I don't think that argument would stand up in Court!
Perhaps a law that no entity can own more than X% of a company, and outlaw hedge funds? Thinking out loud here. I wouldn't snap my finger to make it happen, but I think it's fair for the layman to questions the status quo "why do organizations exist that allow small groups of people to play the game of timing arbitrage on the market to amass billions of dollars".
> Single disks were never a recommended option for ZFS, it's a filesystem designed for arrays.

Not quite true IMHO. One of best features of ZFS is checksumming to ensure data integrity, where errors can be corrected if you have enough redundancy.

You certainly lose this feature with single disks, but you're not necessarily worse off than any other file system.

What ZFS gives you on a single disk is very convenient snapshots and very convenient (incremental) streaming of those snapshots to another system (via either a push or pull mechanism). Doing this with other file systems generally entail a lot more work and much less efficiency. btrfs can do it, but if you're using ext4, then you'll probably use rsync which has to walk the file tree to find changed files.

Also with ZFS and snapshots you can turn them into clones: writable copies. This allow boot environments were updates/upgrades can be done, and if things do not work out, you can boot back to the original setup:

* https://mwl.io/archives/2363

* https://vermaden.wordpress.com/2021/02/23/upgrade-freebsd-wi...
>The feds sets the prime rate...

Just to clarify, the Fed doesn't directly set the prime rate, though it does have influence on it:

>...Although the Federal Reserve has no direct role in setting the prime rate, many banks choose to set their prime rates based partly on the target level of the federal funds rate--the rate that banks charge each other for short-term loans--established by the Federal Open Market Committee.

https://www.federalreserve.gov/faqs/credit_12846.htm
The IT in my district was so bad the students basically ran it for my middle and high school. We did all the desktop repairs and component swaps for free. I don't even think we had an "IT guy." This was 2009-2014 for me.

On the bright side, we got comfortable with computers and ended up building our own little projects (in and outside of school). In 10th grade we souped up one of the engineering lab computers by consolidating a bunch of old graphics cards and played games on it, lol.
>If you're on a knitting forum and people keep talking about fantasy football, they deserve to be flagged.

That doesn't seem to be what the parent poster is talking about? I take his comment as talking about certain opinions (on a given topic) being flagged, not random off-topic discussion getting flagged.
That is an interesting point. As a privileged middle class person, I mostly use Facebook to argue. But I can see how it might actually be a good networking tool for those who need it for such.
This, along with @dang's link to his past posts about "expected value" (found in the discussion linked to above) [1], was like reading Bartosz Ciechanowski's post on internal combustion engines [2] but for HN.

Thanks for all your work, @dang. Good to see that there's a philosophical soul at the helm. Would love to meet you in person one day.

[1]: https://hn.algolia.com/?dateRange=all&page=0&prefix=true&sor...

[2]: https://ciechanow.ski/internal-combustion-engine/, which I learned about from HN
That's your line. Clearly this is not universally accepted as the best way to form a society.
My point was basically that you can implement the array abstract data type (creation, set value at index, get value at index) in a lot of ways, including by using ADTs (although it seems hard to get an O(1) implementation if you use ADTs, unless you have some clever compiler or language mechanism). But just because you can implement arrays in terms of ADTs doesn't mean that arrays ARE ADTs.

Now that I think of it a bit more, it seems to be a category error to say that a "set" or an "object" or a "dictionary" is an algebraic data type. Algebraic data types are types (values) constructed out of simpler types (values) in a certain way, and that can be deconstructed in a way that mirrors the way they were created. You can implement various APIs/interfaces on top of that, including dictionaries and sets and whatnot.

But my point was that you can do the same on top of just integers (assuming you have the common integer operations), and you could even package it up in a type safe way so that the fact that you used integers in the implementation does not leak out, assuming the language has some modularity/abstraction mechanism so that you can make stuff private to a module. But based on this it seems to be a stretch to say that dictionaries are REALLY just integers or bitstrings.

And just like you probably wouldn't want to bring "integer reasoning" to bear on dictionaries, you probably don't want to use ADT reasoning to reason about dictionaries either. Because then you are really reasoning about the concrete implementation details and generally speaking those details are hidden from clients of the dictionary (and subject to change at any time).
>Another group I'm in calls it an inflamed amygdala.

Is that medically speaking a thing? People who might be more emotional might just have an inflamed amygdala?
There are supposed to be 50GHz gallium-nitride FPGAs. Might not be big enough to host a 6502 and all its RAM, though. I gather they are mostly used in military SDRs.
I’m ordering the day the Thunderbolt expansion card becomes available. I just can’t make use of a laptop that I can’t plug my eGPU into.
> And you will get exactly what you paid for.

What are they getting though?

It's like saying when you spend $1,000 for a beanie baby (or a cabbage patch kid if you're older) you got something of transient value driven by cultural hype.

On its face, yes you are right: you got a doll for a lot of money, or a token for a lot of money.

But you weren't buying a doll, you were buying hype whipped up by con men that it will be worth more to another person who is conned. Dolls aren't worth thousands of dollars unless a critical mass agrees they are.

Its the Austrian economic theory why diamonds are worth more than water, when water is necessary for life and diamonds are just shiny rocks.

I consider that a scam too.

You are correct that words do matter. We need to call these what they are: scams and cons.

I think perhaps you are trying to partition a scam or a con into a "bait and switch", that is also a scam/con, at the expense of everything else. That's what it sounds like to me.
sure, but we all hold crazy beliefs and bad opinions, not just a decent chunk of us. the amazing thing is that if, instead of trying to convince each other so hard, we averaged all our opinions together, we’d be collectively right much more than would seem possible. politics literally opposes this astonishing natural phenomenon. politics and ego are the enemy, not the wrongness that pervades the opinions of individuals.
It's exposed (to the sun and the wind) and it's dull. Inviting pedestrian environments need a sense of enclosure. Can be sidewalk-abutting buildings, can be trees, can be parked cars, can be all three. And they need stuff to look at that isn't monotonous.
Stores are increasingly moving away from "their own sales data". Costco, for instance, demands a 6 month payment plan on inventory[0], which effectively means they are following the Amazon route by being a marketplace for inventory which the distributor still owns. Best Buy does this as well.

0: https://youtu.be/mvk5tVMZQ_U?t=7195
Or perhaps one method of recovering from depression is training yourself to honestly believe a fantasy about reality, and learning to see your previous, depressive worldview as inaccurate is part of that training.
> It’s not a legality problem it’s a philosophy one.

This is not a dichotomy. The legal aspect comes from the "philosophical" one that comes for lobby money.
There are many products that aim to fill this niche. I worked on one for years (Cloud Foundry). There is a lot of money to be made, but it's surprisingly stony ground.

Oblig. self-promoted thread: https://twitter.com/jacques_chester/status/14357388253476454...
Have you talked to a doctor about ADHD and possible treatment methods? The pharmacology behind prescribed stimulants work to flood our dopamine receptors greatly weakening that urge to check our phone for those sweet, sweet, notifications.
> An addiction has for sure its chemical reasons, but limiting to only that when dealing with it, it's reductive

Right, the point I got from this, particularly from all the examples pulled from pop science, is that folks are focusing on a reduced/mischaracterized biological mechanism instead of on the associated social behaviors. The social behaviors are the things we can (theoretically at least) actually change. Perhaps the author means to express that we should focus on whatever human behavior we think it problematic instead of "blaming" a component of the mechanism.
I'm totally not an expert on this, but my understanding is that Bach's work on MicroPsi is a follow on / extension of Dörner's Psi theory.
Step by Step Guide to Cellular Wardriving Attacks
In libjanet you can use a C call like janet_panic() that'll "panic" and throw an exception/error up in the active Janet runtime (so when something bad/unexpected happens in your C code you are providing an API to from Janet, you'd use this).
> She is the poster child for disingenuous skepticism

She doesn't seem at all disingenuous to me, what actions make you doubt her genuinity? To me it sounds like she may have some mental health issues to work out and that is an entirely different beast than this conversation.
It won't for them, because they've shifted culpability over to the hardware vendors.
With first Martian samples packed, Perseverance initiates sample return mission
Oh I can think of tons of failed launches from a technical/quality/user perspective. What I meant was the manager/executive lens.

Like at what point is launching anything ever seen as a negative because it seems even the people in charge of the biggest disasters seem to do fine afterwards and just move on to a job at the next megacorp no problem.
I don't think it's fair to say I was ignorant when you only now mention need it for work. You could use a second handset, or try asking your employer to move away from Google products, or even find a new employer. There's plenty of options here.

If you say that the best you can do is limit exposure, then do that!
I don't think it's fair to pick on psychological research, this is a phenomenon present in all reporting on science... and I think it's more of a reporting issue (they're incentivized on collecting eyeballs, not accuracy). I've often read the studies behind the articles to find that the study is much more realistic and less apt to draw conclusions beyond "one possibility is X, but more research is needed."
Show HN: Blindnet – a simple tool to limit data exposure in your apps