skysight-inc/HackerNews huggingface dataset:
"A traditional SQL SELECT query requires that requested columns be explicitly specified, with one notable exception: the * wildcard. SELECT * allows SQL to return all relevant columns. This adds tremendous flexibility, especially when building queries on top of one another. However, we are often interested in almost all columns. In DuckDB, simply specify which columns to EXCLUDE:"

It appears how this works is that is selects all columns and then EXCLUDES only the column's specified, the reason this doesn't exist in normal SQL is because it is a terrible idea. This is something that will break at many companies with large technical debt if it is ever used.
Starfield and Redfall Delayed to 2023
Ctrl + F "debt" = 0 results. How can you write an article about how Japan fell so behind and not address debt.

https://tradingeconomics.com/japan/government-debt-to-gdp

Late 80s, early 90s Japan was majorly in debt. That deficit spending in the 1980s didn't buy nothing. It bought tremendous GDP growth and huge innovation that lead to technological envy.

The thing is, government deficit spending isn't effective. best described as trying to put out a fire using a leaky bucket. It also leaves you up around 100% debt/gdp and when the inevitable next crisis hits. In this case the 1997 asian financial crisis did japan in. Japan's gdp basically hasn't been any better since. You get pushed over the 100% threshold and it's only upward for your debt. Your debt climbs and climbs but your gdp doesnt follow the same growth once you pass 100%.

Worse yet, their economy is basically in deflationary spiral but they are only managing to keep from collapse by more of what put them into the problem to beginwith. This is the "I will cure my cocaine addiction with more cocaine." tactic.

>The Personal Income Tax Rate in Japan stands at 55.97 percent.

#heartattack

Call an ambulance but not for me. Japan what the hell are you doing? You work for the government more than half the year and you get very little for it.

You have crippled your country for decades and have lost your envious lead. You have to pay the piper eventually. Why have you ruined more than 1 generation of your people by not balancing the budget?

You have a total tax burden of over 90%. So you can't tax your way out. You can print money and pay off the debt. Pull the wealth out of those holding onto your currency. Primarily retirees are going to be punished, they are who racked up the debt, yes silver crime will blow up, yes most of them have to go back to work. Yes poverty and unemployment will be very punishing.

Dont like this inevitable pain? Require your government to always balance the budget.
The relationship between actual utility/value and price is only vaguely correlated.
Many of the most useful things on earth can't be marketed, not because they're not worth the money but because people are extremely greedy for some kinds of domains and simultaneously are bad at realizing the impact on their lives.
E.g I have never spent a single dollar to access music despite being one of the few things in life that brings me intense joy
The war which is coming
Is not the first one. There were
Other wars before it.
When the last one came to an end
There were conquerors and conquered.
Among the conquered the common people
Starved. Among the conquerors
The common people starved too.

Brecht

I worry about people and US does not otherwise they wouldn’t be feeding it with free weapons, it’s a matter of power and influence, don’t tell me you care about The people when US killed kids in Iraq and jailed journalists reporting it, fuck US
It may also precess, so that the axis of rotation is changing with time. Previous galactic collisions may also have caused two holes to merge into this one, with a net spin not orthogonal to the Galactic plane.
This! I thought I was going insane, that nobody has mentioned this until now. "When did this start happening?", I thought. But looking into it, it seemed as if it had always been like this -- only of course it hadn't!

It is mind crushingly annoying, second in nerve-o-smashing only to useless mouse over popups all over a UI. "Here, let me just smack a popup over what you're reading because there's now about 0.2cm of the screen you can place your mouse that _doesn't_ do that. What does it say? Oh, it just repeats the name of the link it's over".
Hmmm

Well money isn't leaving the crypto space, its just in other more resilient stablecoins, so its ready to pounce or “ape-in” to anything at a moment’s notice. USDC and Tether have still $130billion collectively issued. Not moving much up or down.

In which case, popular things that sold off are still worth watching. I usually miss the bottom hoping for a steeper sell off.

Look for things that extract value, and accrue it to the token.

A cross-chain flash loan bot that shares with its community of stakers (distinct from and a subset of the token holders) could be fun. I haven't really seen one that shared.

Yield optimizers are still unperfected. Opportunity to compete with a better one there, that also involves the community better.

A decade is too hard for me.

But Helium had some cheap prices and their wireless network is robust enough with all the pieces coming into places for a recurring demand model to kick in.

Node software needs much improvement. But this is slow because there isnt a compensation path at the moment, a couple gitcoin grants have gone out that have resulted in major improvements, more likely that FAANGs will start doing contributions to node software, which will be the compensation path for developers as employment.

Lots of stuff on the private equity side, if you really want longer cycles and possibility of cashing out into a more mature financial market with regulated registered shares. Bear markets are the best time to build because your investors will leave you alone. As an investor you can make more onerous conditions to companies raising.
I have been sitting on cash since end of last year, I am finally seeing opportunities to buy at reasonable price: stocks and crypto.

Stocks, cryptos, houses: people kept buying no matter the price, even though, it was so obvious that those prices were not sustainable.

And we are finally seeing a proper correction. I think, houses are next in line.
Why not just use ctrl-alt-v to paste without formatting? Or right-click and select "paste special", then select "plain text"?
> I processed 176,178,986 unique comments that redditors left in years 2020 - 2021 and computed Jaccard Similarity between subreddits.

> Each dot on the map is subreddit. Two dots within the same cluster are usually close to each other if multiple users frequently leave comments on both subreddits.

More detail from the repo: https://github.com/anvaka/map-of-reddit
I think "crypto meme scheme" or something to that effect
I like that the first reply is to switch from zoom to google meet. Very helpful.
I've never broken a phone sober. I'm 27. I've now got a fairphone where I can replace everything but the mobo myself with official parts.
EFF likely changed their own title; "unconstitutional" is present in the url string. (I'm not OP)

edit to add:

https://web.archive.org/web/20220512173904/https://www.eff.o...
It doesn't have anything to do with mobile. The web client uses the same APIs.
He's very high up. He's not going to be suffering like the serfs below him. I've seen many let go with no severance or two weeks in a worse recession - including those who don't have a 8+ figure NW...

Don't be fooled - the guy is quite rich.
Not sure what he is proud of? Twitter did NOTHING for a decade. That’s why they’re being acquired. Zuckerberg was right about his “clown car” comment.
I am inclined to disagree on the reasonable part, I have a feeling that the difference between cryptocurrencies and say stocks or commodities is a difference in kind not a difference in degree.

Sure when there is risk appetite again cryptocurrencies will rebound along with other risky instruments.

But I just can't shake the feeling that cryptocurrencies in general is just a huge pyramid scheme.
This is really incredible. With a rooted android phone and these tools, plus a couple others [1,2,3], you can get a skeleton to implement a backend for any app you want.

[1]: https://github.com/koxudaxi/fastapi-code-generator

[2]: https://github.com/ioxiocom/openapi-to-fastapi

[3]: https://infosecwriteups.com/hail-frida-the-universal-ssl-pin...
I would just invest once it recovers again.
To be fair, his point is you can't fix a black box and the human mind is still more a discipline of philosophy than modern science.
Painful break fee - worth it in current market conditions though his equity hes putting up will have been reevaluated downwards too.
Totally disagree, primarily because Twitter offers nearly 5 months of paternity leave. I don't know when the Twitter's Head of Product originally left for paternity leave, but if it was a couple months ago, obviously the world has changed under Twitter's feet in that time.

A business can't just stop because someone is on leave. I would expect them to be treated fairly, and the same as if they were not on leave when it comes to personnel decisions. What would not be fair, to both the employee and all of their colleagues, is to say that when someone goes on leave that there is a moratorium on any changes to their status for 5 months.
It maximizes his chance of survival either way.

The probability that Elon is margin called by year end is roughly 40% according to option prices.

- 60% chance you get fired either by Musk or investors if you don't turn the ship.
- 40% chance you Musk is margin called and doesn't take over, but still might be fired by investors or acquired by someone else who may in turn can him.
The original comment wasn't about US citizens but non-citizens which is what my comment was based on.
It would be amazing, and not too unlike TE, if they released some of these features as updates to the original OP-1. I'm particularly interested in the new tape recording styles.
I’m not “taking a victory lap”. You have a tech that supposed to be digital cash with gold properties that is insanely volatile, often takes a long time to settle and features opaque gas fees, etc.

It’s a cool experiment, but it’s almost like Uber - something with great promise that delivered something lesser.
The severance is on top of the $20M worth of TWTR stock he already holds, according to public records. Plus whatever other assets he holds, which I would presume to be not insubstantial. I think he'll be OK.
Why would someone program an OS to do this when it's already connected to an access point? This is like me eating a sandwich and stopping mid-chew every minute to check the fridge.
Modifying CSF turnover is not particularly novel, but I do think it is generally overlooked. CSF production cycling is greatly reduced in the elderly and and there are a lot of connections to memory diseases such as alzheimers.

A few medical device startups have attacked the problem with promising results. Unfortunately, VC and national funding orgs aren't particularly interested in device based solutions because pills and injections are perpetually 5 years out.

I'm aware of at least one that was able to halt or reverse alzheimers in a 200 patient trial, but folded after they couldnt get funding to move forward.
Isn’t redeeming at Bitfinix not the same as redeeming at Tether? I don’t think what you do is what GP is looking for
Gallup data shows a strong upward trend. Finns are rarely partisan about matters of national defense, and we trust our elected officials that have access to classified information.
Interestingly, when I went to Security Preferences there was an icon to show that Apple Maps had used my location in the last 24 hours. This is in spite of almost never using Apple Maps on my MacBook, and certainly not in the last month. So this smells like some sort of background daemon or similar.
Crypto crash: Stablecoin collapse sends tokens tumbling
Peers review the paper. The purpose of peer review is to ensure that the paper clearly communicates the work of the authors.

In the process of doing so, questions and clarifications may better reveal problems with the underlying science itself, which can result in the paper being withdrawn or declined. But peers don’t independently validate results.

At the same time it should be noted that published criticism has to meet the same bar. “You didn’t do the experiment the way I would have” is not really strong criticism. Experiments or observations can always be done better; this is a central ethos of science.

The strongest criticism is usually to conduct one’s own experiment the way one wants, and then show that it produced better results.
Wave: A Case Study for Low Architectural Complexity
locationd probably wasn't tracking that state. Maybe now it is.
This may not always be the case, fortunately! I recall the Broadcom Wi-Fi 7 chipset announcement[0] in April mentioned a dedicated scan core which may well offload the network searches to a separate part of the chip, freeing the AP connectivity core(s) from having to do other tasks for a second or two each minute.

Here's hoping it works as I understand it and other chipsets start doing similar things!

[0] https://news.ycombinator.com/item?id=31060452
The EFF has really lost their way. They should not be defending Big Tech censoring the Internet.
My clipboard manager (flycut) also strips formatting which is really handy
I find it really fascinating how a completely different subset of Hackernews users answers to you than are present on other threads. As literary no sibling is voicing a dissenting opinion I feel compelled to present it:

Purely from the user perspective I hate electron, because of its RAM usage. The speed argument is a straw man: Of course V8 is fast. And yes, VSCode is a very good IDE. But the problem is real world electron application don't scale down. In my (of course biased) experience even simple electron applications use at least half a gigabyte of RAM, often a whole gigabyte. If you're on a beefy 32gb machine you'll never noticed the difference. But on the 8gb machines most people around me use, these electron apps really take up a huge fraction of RAM. And swapping is definitely noticeable slow, even on SSDs. The "think about the planet" argument comes to play, when I need to upgrade my PC because RAM is the bottleneck. And seriously what fraction of the population even has the knowledge to only upgrade the RAM and not buy a whole new PC.

If I had to advise you personally, I might even tell you to choose electron. But be aware that you are using the "defect" option in the prisoner's dilemma: as everybody around you is choosing the societally harmful option of wasting resources you are at a competitive disadvantage to do the right thing. And also: electron has stolen mind share off of better solutions, so the documentation there is also not in the best place.

And even worse, those people I reach with my argument, and thus put at a competitive disadvantage because they are going the extra mile to do the rights thing, might be those that I want to support the most, because they might be willing to the right (IMO) things at other topics I value as well, like the importance of privacy.

So what is the conclusion? I have no idea how to fix our collective resource waste and it is hard to assign individual responsibility and I'm deeply dissatisfied by the whole situation.
Betting?
You didn't really answer my question at all - you just went off on some side commentary about why you think people dislike him.
Transformer models have clearly demonstrated that you can convert anything into an input embedding and the AI can learn from it, even if the embeddings are from drastically distant domains.
Sure, if you trust the correctness of the computer's software with your life and the lives of any passengers. There are popular apps now that do some of what you suggest, especially trip planning.

I've seen enough bugs in my day job to want to at least verify the computer's work and have backup instruments, even if just my own senses. Aerospace software is known for relatively low bug counts[1] but also causing fatal crashes[2].

I trust my car controls to be correct and if they aren't I can brake to a stop if anything else seems off. (Unless of course the brakes stop working!) But since you have to take off to fly, you might not realize you can't control the plane until it's already at dangerous speeds.[3]

1: https://www.bugsplat.com/blog/less-serious/why-nasa-code-doe...

2: See https://en.wikipedia.org/wiki/List_of_software_bugs sections on Space, Military, and Transportation for examples.

3: Amazing story about an airliner that took off not knowing its controls had been reversed (a maintenance mistake). Pilots declared "MAYDAY plane is completely uncontrollable we plan to ditch" but eventually figured out how to fly the reversed controls and landed it safely—super impressive. https://www.youtube.com/watch?v=kIc8Rr-cKd8
Maybe I am totally mis-categorizing here, but I would say that Bucky Fuller's "Design Science Revolution" is solarpunk in spirit if not in fact. It has a similar techno-optimism with a radical non-violent revolution as it's stated goal.

> Fuller advocated the design science revolution as an alternative to politics, seeking to optimize planetary resources for the benefit of 100% of humanity. He coined the term synergetics to explain how design science could create rich returns, such as how "energy income" could be harvested from the environment. His main premise was that nature's existing and omnipotent order must be allowed to guide human designs, if they are to survive and thrive as a species. He wrote that humanity was approaching its critical test as a species, in which it would be determined whether or not man was a mistake of nature, or its greatest accomplishment.

https://en.wikipedia.org/wiki/Design_science_revolution

There's no one book, but his "Operating Manual for Spaceship Earth" might be a place to start if you're interested.

> The book relates Earth to a spaceship flying through space. Noting the lack of any user manual to help Earthians steward this ship, Fuller offers some reflections, prognostications, and guidance, based on contemporary concepts of linked relationships, that may help in the understanding, management, preservation, and sustainment of this ship. The spaceship has a finite amount of resources and cannot be resupplied.

https://en.wikipedia.org/wiki/Operating_Manual_for_Spaceship...
When I wrote that it was fine. Now it's not.
The law (https://capitol.texas.gov/tlodocs/872/billtext/html/HB00020S...) states:

--------------------

Sec. 143A.002. CENSORSHIP PROHIBITED. (a) A social media platform may not censor a user, a user's expression, or a user's ability to receive the expression of another person based on:
(1) the viewpoint of the user or another person;
(2) the viewpoint represented in the user's expression or another person's expression; or
(3) a user's geographic location in this state or any part of this state.
(b) This section applies regardless of whether the viewpoint is expressed on a social media platform or through any other medium.

--------------------

Viewpoint isn't defined, presumably intentionally vague to chill anything but the broadest compliance.

As well, you can't just filter out Texans to avoid complying with this law - your private company MUST serve Texans.

Ok, but how is it enforced? Are there new Texas Internet Rangers?

--------------------

Sec. 143A.007. USER REMEDIES. (a) A user may bring an action against a social media platform that violates this chapter
with respect to the user.
(b) If the user proves that the social media platform violated this chapter with respect to the user, the user is entitled to recover:
(1) declaratory relief under Chapter 37, including costs and reasonable and necessary attorney's fees under Section 37.009; and
(2) injunctive relief.

--------------------

Oh... it's another bounty-hunter law, like the Texas abortion law which rewards people with $10,000 big-ones for turning in their ex-girlfriend or coworker or whatever.
Gold is a worse inflation hedge than stocks.
Gold is actually bought to have quick liquidity when there is a market opportunity. It functions as cash but with less inflation but its not to evade inflation its just better than directly holding cash.

And yes it is a pyramid, almost all of the value come from the fact that central banks hold most of it and almost never sell to the open market and most of the rest is in jewelry with 2-3 generation turnaround time so essentially removed from the gold market.
> What's a phrase for when everyone is getting scammed, and not by any one person, but by an idea? Where there are no winners, only lucky and unlucky.

The phrase is "financial market"
"Philosopher's Stone" also refers to a relevant part of alchemy, whereas "Sorcerer's Stone" has no poetic or referential weight to it. Sad.
In this version of events, it's likely we'll be able to see how lean Twitter could actually be.
> You treat it as a strange mystic unnatural phenomenon unlike anything that has ever existed.

No, I’m treating a taxation scheme as an arbitrary invention because that’s what it it is.

Nothing mystical or unnatural about it. Just, in this case, grossly immoral.

> If there is a moral basis for rent increases in response to land value increases there is a moral basis for increasing the amount of tax charged for land value increases.

You’re rather breezily glossing over the fundamental difference — property rights.

I get that you dislike property rights and want to steal them from people living contrary to how you believe they should, but your wanting to steal what other people have isn’t a position I’m going to agree with.

> Property rights aren't magic that tears down the very fabric of reality.

Your invented scheme to force people out of their homes so you can redevelop their land isn’t “the fabric of reality”.
I recall registering on HN years ago and posting the URL to some side project I was working on. Since it was a new account, I triggered some shadow-banning mechanism, and my project got no attention whatsoever. It was very dispiriting. Over the next few months I toyed with some new accounts, and I got lucky: one of the accounts didn't trigger the shadowban, and I quickly posted my side project (It was a 'Show HN').

It got like ten upvotes, and 2-3 comments. And that was it. It didn't get to the frontpage and lingered in /newest for a day. Getting stuff on the frontpage is purely hit & miss, and nearly impossible to game since the mechanisms in place for HN in detecting voting rings works really well, alongside the moderation aspect, and the way the community flags obviously spammy content or political flame-bait.
It's amazing that Microsoft works so hard on this bs, but does zero to have Excel support copying newline separated (or comma separated, otherwise clearly dilineated) text pop into Excel properly on paste, something that would actually be useful!
Is it possible to do this on wireshark/tcpdump pcap dumps? Like for finding out hostnames, endpoints and request packets of HTTPS requests that an android app is making?
> Normal people losing all their life savings and a lot of them are contemplating suicide.

1) It's the internet (a subreddit no less!) - who really knows who lost what, and who is contemplating suicide.

2) If we take it at face value -- that people have lost their life savings and are contemplating suicide -- the real issue isn't a change in material circumstances, it's shame. Ashamed of their own stupidity and greed, they find it hard to imagine living with the knowledge that in their heart of hearts they knew better.

3) That is why the endgame will be the creation of a villian. Making people whole or at least providing some relief isn't the important part. The important part is helping people convince themselves it wasn't their fault. They were victims. The government, the banks, CNBC are the bad guys.
Are you aware of https://en.wikipedia.org/wiki/Brasyl ?

I've found it to be entertaining. It also fits into the dystopia/surveillance spectrum.