skysight-inc/HackerNews huggingface dataset:
The ISO8601 weekdate format[1] is tricky, but it can be done:

SELECT strftime('%Y', yyyymmdd, '-3 days', 'weekday 4') || '-W' || substr('00' || (((strftime('%j', date(yyyymmdd), '-3 days', 'weekday 4')) - 1) / 7 + 1), -2, 2) || '-' || replace(strftime('%w', yyyymmdd), '0', '7') AS yyyywwwd ;

returns ISO weekdate format ('2021-W10-6') the when the input column `yyyymmdd` is in year-month-day format ('2021-03-13'). Not pretty, but it works. The annoying part for me is actually that '%w' returns 0 for Sunday, 1-6 for Mon-Sat, rather than the ISO 1-7 for Mon-Sun.

If sqlite supported macros, we could have put the entire expression in a new "function". But you could (ab)use m4 or even the C preprocessor for that :).

[1] https://en.wikipedia.org/wiki/ISO_week_date
> Fuel efficiency is worse in older cars

On fleet-wide average, for sure. But not for all cars.

One of my cars (daily commuter pre-pandemic) is a late 80s Honda CRX, it gets nearly 40 MPG. Even in 2021 many (probably most) cars can't match that kind of efficiency.

(Energy cost per mile is lower than for my partner's electric Fiat 500e!)

The car that makes me sad and almost angry is the original CRX HF (mine is not an HF). This is a car that got over 50MPG with mid-80s engine technology!

https://jalopnik.com/1986-honda-crx-hf-393147

If Honda had continued developing the HF engine, what kind of mileage could an evolved 2021 CRX HF be getting today? We'll never know, but I'd guess over 70MPG.
Honestly I think the issue isn't with batteries or current technology. My lay view is that the technology to make PEVs attractive is already here. What is not here is the eco-system.

* Can you get the car serviced at an independent mechanic or do you have to go to the dealer and pay whatever they decide to charge you? No amount of battery innovation will overcome $1000 bills to replace a door handle. Check out Rich Rebuild's youtube channel for a description of the service costs of keeping a Tesla running out of warranty: https://www.youtube.com/watch?v=nq5c4jGR2gM&t=302s

* Is there a large eco-system of after-market parts and third party warranty issuers? This is required to drive repair costs down.

* Do we have good data on the lifetime of critical parts under actual use? This is required for consumers to estimate the operating costs over the life of the vehicle (whether or not they plan on selling it doesn't matter, as they will pay for those operating costs either in depreciation or in paying for repairs themselves)

* Is there a robust country-wide charge network that compete with gas stations?

* Is there a system to quickly get energy when you need it -- e.g. either very fast (10 min) charging or a swap-in battery system to give you a quick 100 miles of range.

These are not issues that require breakthroughs in solid state science. If the batteries don't last long, make it easier to service them or swap them out. If the range isn't so great, create a wider network of chargers. If the parts don't last as long, make them cheaper and easier to service by independent mechanics. Force a right to repair and diagnose for PEVs as we have for gas powered cars.

IOW, rather than waiting on breakthroughs in materials science, infrastructure upgrades can solve these issues, but lack of infrastructure can't be solved by breakthroughs in battery life. As long as Tesla is a monopoly provider of parts and service, and as long as the infrastructure isn't there, upping the power to weight ratio of batteries by 30% isn't going to do much to reduce ownership risk to consumers, and PEVs will remain a niche market dominated by wealthy consumers who can bear ownership cost risk better than middle class people.

* And of course, the electric grid needs a massive upgrade.

All of the above is well within the reach of existing tech. Whether it's financially feasible is another question.
Yes, but Bitcoin is special in that it aims to be as decentralized as possible. Ethereum aims to move fast, that’s why it needs a leader. Both are great projects, and both approaches have tradeoffs.
The video wouldn't be valuable, because it's trivial to duplicate.

However, should it be impossible to copy videos and the only way to do a video would be to capture the events as they happen, then perhaps your video would have value.
Is that a true story, and would that really have impacted Black Monday?
Extremely well stated.
People like to defend their political tribes.
Apple seems to have a long history of integrations of Mac OS (and the Mac user interface) and UNIX, starting in the 1980s and continuing through today: A/UX, AWS (Apple Workgroup Server), MAE, Rhapsody, OS X, modern macOS...

Not to mention the OS X-like variants for their other platforms: iOS, tvOS, iPadOS, watchOS...

Also consider the various Mach implementations on Apple hardware: MacMach, MachTen, MkLinux, OS X/Darwin...

Sadly it seems that the classic Mac API died when Carbon and 32-bit apps died, so you can't easily port old Mac apps to modern macOS. macOS (and iOS) seem to have a rather poor record for backward compatibility, and it's only going to get worse with the current architectural switch to Apple Silicon...
Let’s say the Ethereum main chain forks into two over contention over an EIP.

You are now effectively holding two copies on it on different blockchains and can transfer them independently.

Which one is “the real one”? That’s purely subjective. Just like with fungible tokens (“Bitcoin cash is the real bitcoin”)

The same principles apply when just making a copy on the other chain.

It’s data and signatures, the rest is just interpretation.
In my opinion, we are trying to solve the "EV range issue" all wrong. We are looking at gas cars, and asking "how can we do the same thing, but with electricity" - and we get a substandard result.

What we SHOULD do is: take a step back and ask "what do we REALLY want to achieve".

We don't really want long range and fast charge. We DO want worry-free power wherever we choose to go. It isn't a novel concept to suggest: inductive charging from the road into the car (as you drive). There are probably other more practical ideas, too, but - and this is critical- you have to start asking the right questions.
same role, across European banking sector.

Key theme is slimming down the mainframe to bare basics, then take out either batch, or DB2, and then see to pull the trigger on the rest, 6y horizon...
That was the joke
Re: the battery lifetime, I think you're mistaking lifetime for reliability. You can have something with a moderate or even short lifetime that still has high reliability during that lifetime. Lithium batteries certainly do degrade over time - even in storage they degrade. But during their expected lifetime they are very reliable, and you can expect them to need no maintenance at all. The same goes for the power electronics and electric motors: if properly designed and operated within their specs they can last indefinitely as there are hardly any wear mechanisms.

Of course, Tesla has had a spotty history in actually achieving that, with the flash chips being a good example. At least when I was doing electronics a few years ago, I ran into quite a few automotive grade microcontrollers and flash chips advertising expected lifetimes of 25 or even 100 years(1) if used correctly with sufficient wear levelling. In that case, Tesla obviously didn't.

1) http://ww1.microchip.com/downloads/en/appnotes/91072a.pdf 40 years retention over full temperature range, 100 years at 25degC.
How to set boundaries when working from home
When picking an enemy it's vitally important to pick one who doesn't exist, otherwise you could actually end up finding and eliminating them. Also, to pick one that you can manufacture if and when you actually have to show some results.
so, the principle of non-fungability is now rendered invalid. The whole point to a unique token is the trait of uniqueness. Moving it to another chain is just a derivative.
> I do think it's important to encourage people to dance with newcomers, but there's also the fact that it is -work- to dance with a newbie.

It's WAY more work for the newcomer. Even at an intermediate level, you are already running on a lot of habitual programming while the newcomer is processing the universe.

However, this also splits based upon lead vs follow.

Expert leaders have a fairly easy time with amateur followers. The lead can dial things down until the follower can cope. The follower can't force something on a leader.

Expert followers have a much more difficult time. The leader may very well need the follower to help but the ability to help well is a very rare skill. In addition, too many intermediate followers think they are better than they are. There is also the issue that dancing with an expert follower is like driving a super responsive sports car, you, as a leader, will find out just how sloppy and crappy your control really is.

To top it off, followers can get injured by amateur leaders. The swing community is especially bad for this. Even if we exclude idiotic people doing acobatic-type maneuvers that they shouldn't be doing, the pace of the dancing combines with adrenaline so that you can put far too much force in your lead as an amateur. A simple behind the back exchange can injure someone's shoulder when executed incorrectly.

As for the social dimension, if your group is well-balanced between leaders and followers, amateur leaders tend to get ignored. This isn't a problem if you have an excess of followers, but, if you have an excess of followers, your community is probably going to collapse shortly.
That's insane. Inductive charging is wildly inefficient.

On typical phone chargers efficiency is about 60-70% max..and it goes down with distance.
Usually the power jack breaks and it stops charging.

As far as I can tell, they make them flimsy and not replaceable on cheaper laptops on purpose. I shudder to think of the environmental impact.
I largely agree. I think the field is exciting and interesting, and like many crypto fanatics say, there might be parallels with the early days of the internet.

I think part of the reason it takes time for people to see the potential is that a lot of it just isn't ready for mainstream yet. The tooling is not uniform and easy, PoW really does not seem like the way to go, and scalability is largely missing. It seems many of these issues are getting solved now though!

There are other issues that still stop me from investing in this (though I would invest more time if I had). One is that I don't have a model for where this is going - I'm not sure that the most popular systems make most sense from a technical point of view. Bitcoin seems to lose out to Nano, for example, and I'm not sure why Ethereum would be better than Cardano. It could be that these technologies are just paving the way for something much cleaner down the road.

Another thing is that consistently the economics don't make sense to me, and I feel like a lot of the conversation about cryptocurrencies is sort of pseudo-economics. It doesn't make sense to me how highly Ether is valued (IMO its value should be the value of a transaction). And the idea of limited supply doesn't make sense to me in the form it is in now - I think a currency should roughly scale with the productive output that it represents, with at most mild inflation or deflation. Limited supplies of current coins only seem to serve early adopters.

I can totally imagine the existing banking system (which, I think, has a much better understanding of economics than the crypto community) adopting a lot of the tech that was developed here and fiat currencies ending up reformed rather than the world switching to community-run cryptocurrencies to a significant extent. (I would feel much more comfortable moving my money to a central bank blockchain than to Bitcoin or Ethereum.)
Andy Gocke put it on twitter better than I've ever seen it anywhere else:

'Developer tools seemed like a good industry to be in, "sell shovels in the gold rush" and all, but it turns out developers prefer to dig for gold with their teeth.'

https://twitter.com/andygocke/status/1017509689695715328?lan...
> We don't really want long range and fast charge

Yes we do. As the article demonstrates, they were making the same arguments 100 years ago.

Lack of range and charging speed is why electric cars lost out to ICE cars 100 years ago. ICE cars simply took you further, faster (and still do).
What's interesting textbooks andectures one can read on plasma fluid dynamics?
India is intentionally keeping its people poor/starving with https://en.wikipedia.org/wiki/Currency_in_circulation#Total_... and https://www.businessinsider.com/india-malnutrition-a-story-o...
The site is blocked in Russia. I wonder what American secrets it holds.
The value of that NFT is directionally proportional to people's recognition and trust in that block chain.

For example for someone who has not heard of the chain, the contract is meaningless and worthless.

I hope these two sentences highlights my feeling about this. That said I've been following some of those artists for years and I'm glad they're getting paid. I just feel bad for the other talented 98% who are missing the bus with their jaw on the floor drooling.
Nice. Never seen the original before.

The drop-and-slide of a square around 1:26 leaves behind some filled cells! I wonder if that's a bug or was it a part of the original gameplay.
Any chance of single-seat pricing? I would like to buy the font pack exclusively for personal use in editors on a work laptop, for myself only, on only one computer. It seems like the cheapest license is $50 for one font, 5 seats, and a limited amount product usage (not exactly sure what that is).

I understand if it's not practical to offer a smaller/cheaper license. This is the first set of fonts I've ever been interested in paying money for, so great job!
IMHO one of the greatest of all time games, thanks for the memories...
That’s true; we’re going to want a substantial improvement in charging infrastructure over the next decade.
We'll see after self driving is working and scaling. Tesla's plan is to have less car owners and more service users.
Look up for tetrisconcept.net and theabsolute.plus discord ( https://discord.gg/6Gf2awJ ). Several people have made attempts to recreate sophisticated clones of Tetris, and the absolute plus leader board is written in rust.
Amazing, love this idea!
The Holy Church of Christ Without Christ
I appreciate the article, but it would be really nice if the author could add a timestamp to his blog posts. Without timestamps, it's impossible to know if any issue described in the article body still exists.

I didn't read it, because it might present outdated knowledge.
Very few laptops also comes with screens worth reusing. It’s getting better, but only a few models of laptop have screens I’d consider using, even as a secondary monitor.
What happens when someone prints a replica of a Picasso?

Nothing.
That's not a good burn though.
I could be missing something big but to me the principle of nft seems to be to find a greater fool who will buy it, and the crypto part helps sell it to the greater fool.

For an ownership right to be meaningful, it needs to have some legally recognized meaning by your centralized authority. If I have a peice of paper that says I own a house or a car or whatever, it’s only useful because I can show that in a court and the people with guns working for the state will give it to me instead of someone else with a fraudulent claim. And if you have that, then the distributed crypto part is redundant... It gets more complicated with art; especially like the jpeg that was just sold at an auction. What does it mean to own that digital image? What value/ rights does ownership give me? But, fundamentally the ownership being tabulated in a blockchain doesn’t do much a piece of official looking paper doesn’t do, except sound more exciting. I think of it is as notarizing a title to something, but in a new cool way associated with getting rich off Bitcoin.
Ah, I understand now. I misinterpreted "no thread overhead" as meaning "I'm not running things in multiple threads", like the current node.js/javascript obsession, where we just run code in one thread and use a bunch of async to "parallelise". Sorry!

I've (badly) written code like you describe -- usually by abusing fork to do my initial data structure setup, then using C pipes to pass jobs around. I suspect there are much better ways of doing it, but that parallelised well enough for the stuff I was doing. I'd be interested to know if there are good libraries (or best practices) for doing this kind of parallelism.
The conflict between Ctrl+C Copy vs SIGINTR could be resolved by making the Escape key be the interrupt key which would actually be the correct behavior from user standpoint... but everyone would have to relearn it.
It seems on the same level as a vaccine being a “kind of memory.”
I see. So then among the (enumerable) number of blockhains that people trust, the first token (not exactly sure if "first" is as simple as it sounds) = the "real" one, and the rest are replicas?
What a well-written and interesting piece that gets to the point!

Compared to all the religious texts I've read about Rust, this is a huge breath of fresh air.

Thanks for sharing! Bookmarking this.
There is a lot of really funny analysis of the state of... computer science things in his description.
They are 100s of years old. Kids off any age were aware of death.

It is our modern kids who do not get it.

I read my kids the originals and it works as fine as the disney versions.
The whole point of NFTs is that the provenance is 100% traceable. The value is derived from a market created by the artist, not the fact that it exists on the chain. The blockchain simply provides a way to prove that it is authentic and trace its ownership history. So if you copy one to another chain, you've created a new piece of art that will only have value if you can create a market for it. It might be a bit-for-bit copy of the original, but it won't have come from the original artist, and therefore won't have the same value.
Not nearly enough. Solar panels, under absolutely perfect conditions (perfect angling, no clouds, etc) produce about 15w per square foot. Even if you covered every bit of the upward facing surfaces, including the hood, with panels, that's going to peak at about 1kw of input - and since you'll be off axis all the time it'll be less than that.

A Tesla battery pack is 100kw/h. So under perfect conditions you'd need 100 hours of charging to get one charge.
NFTs are representing ownership of physical or digital objects.

As far as physical ownership goes, it comes from what ownership record keeping system are you going to trust? For land, we have trusted state provided system so far. This can change with NFT like technology, provided people including the state trust it to manage those records.

For digital items ownership, there is literally nothing that prevents others from getting a copy of your item. You just get to claim the ownership rights to it, which doesn't mean much when everyone can get a copy of it, like you do. It's essentially reduced to bragging rights, claiming you own it, on a record keeping system which people trust. But would people even care to trust a system for ownership when literally anyone can hold a copy of that digital item in their possession? If someone else copies it over to another record keeping system, what difference does it make? Not much. There isn't much value in bragging rights to ownership, as much as it is in possession, which in digital items isn't securely feasible in this manner.
The entire point of an NFT is to act as a sort of proof/certificate that this is the Real Version of a given piece of media. Someone could create a new NFT on a different blockchain for the nyan cat, but it wouldn't be Your NFT. As a result, it could be said it's not the Real NFT, and thus doesn't have the same value.

An artist selling their art as an NFT would probably say "hey This NFT on this chain is the real NFT for my art, anything else is a fake". A fake would never have this announcement, and there wouldn't be a record of the original artist owning/creating the NFT on the new chain.

So it's not so much that one blockchain is the defacto NFT implementation, but it's up to the creator to specify the blockchain that has the defacto NFT for that piece of media. They could even announce their own signature, and point out the transaction by their signature that created the NFT. Or something along those lines
Not anymore, hah: https://github.com/Jimbly/regex-crossword/commit/0e603975f21...
How much more space efficient is a pixelated video using pure text like this?
Who was your medical tourism agency? My Gmail username is the same as my HN username if you prefer to answer there. Thank you cryptoman!
> Why not pay someone else to change the battery?

You can of course always pay for service if you don't feel like doing it.

But that's missing the point. With older cars you have a choice of DIY or pay someone.

With newer BMWs or example, even something as trivial as changing the battery requires dealer intervention because the ECU is coded to the battery (for no reason whatsoever, other than proprietary lock-in).

Today, there are still independent BMW-certified mechanics who have access to the proprietary tooling to do these operations so if you make friends with one, you can still change a battery yourself. But nothing prevents BMW from cutting them off someday and then you're truly stuck with a dependency on the dealer. And what happens when BMW decides your model is no longer supported because they want you to buy a new one?

No thanks. I'll have older cars which can be fixed mechanically without any DRM nonsense.
Yes native date and time handling would be awesome. I dislike dealing with them as strings.

And then temporal tables. And natively versioned tables. I can dream...
I suppose one could make the same argument about bitcoin. Why not just make your own cryptocurrency with its separate blockchain? You certainly can and many people have.

But in order for your forked bitcoin to have any value you need to give people some reason to prefer it over the existing bitcoin blockchain. If it really is just a clone of something that already exists, no one will value it very highly.

The same is true of NFTs. If an existing NFT is tied to an established blockchain like Ethereum and you fork it, then you would need to come up with a compelling reason for someone to prefer your forked blockchain over Ethereum.
Nothing stops you from minting any "art" as an NFT. What it comes down to is whether it is an officially sanctioned NFT by the artist or not, as that is what will give it "value".
This is gold. I have seen a lot of "cool" startups that failed, and "not-so-cool" startups which do the dirty work for their customers so that their customer don't have to succeeded.
You say "miners" like they're a union with a spokesperson. They're not; they're thousands of people spread across the world, with different agendas.

Miners who refuse to adopt the new PoS system have the right to not upgrade to it. At that point, the system "forks" (the article calls it a 51% attack, but I think that's a little inflammatory). This literally already happened with Ethereum and Ethereum Classic; Bitcoin and Bitcoin Cash. It isn't a new situation.

The reason why some miners are dissenting this change is, first and obviously, because they disagree with it. So, why not just fork? Because no one talks about Bitcoin Cash; they talk about Bitcoin. They want to stay on PoW because it will return the best revenue for their mining operation, but if they're busy mining a coin that has little value, that also hurts their revenue. In other words, the only way for them to win is to get the community against the change, which is a losing bet because the change is widely supported.
They’ve joined RedHat in pouring a big bucket of sleazy business behavior onto the open source movement.