Hacker News new | past | comments | ask | show | jobs | submit | zkomp's comments login

Just the ability to query postgres itself using the duckdb engine is an amazing feature


identity probably refers to the ’IS’:

SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array w/o UK?" FROM (VALUES ('[{"a":"1"}, {"b":"2","b":"3"}]')) foo(js);


Will not happen. ”green” energy is not green- it consume massive amount of resources, it is expensive, short lived, destabilize the grid. I’m super happy my country is finally waking up from the horrible green hypnosis.


It doesn't matter if it consumes resources what matters is that it's less than what it replaces a.k.a. better for the environment.

I see this manipulative arguement used all the time with lithium mining.


How are going to mine resources that doesn’t exist? There is not enough of the metals needed to go full renewable.


Ridiculous claim. What are the assumptions?


False. There is no shortage of any of the materials needed to go fully renewable.


It’s Time to Wake Up - The Currently Known Global Mineral Reserves Will Not Be Sufficient to Supply Enough Metals to Manufacture the Planned Non-fossil Fuel Industrial Systems

https://www.gtk.fi/en/research/time-to-wake-up/

"No matter what minerals will be needed, we will need large quantities of them as the renewable power sources like wind and solar, require extensive mineral resources to manufacture the infrastructure for fossil-free energy.

And there is a challenge. Given the estimated required number of Electric Vehicles (EV’s) of different vehicle class, it is clear that there are not enough minerals in the currently reported global reserves to build just one generation of batteries for all EV’s and stationary power storage, in the global industrial ecosystem as it is today."


To put it nice, I would be careful to use that report to back any argument whatsoever. To come up with their conclusion they e.g. basically assumed LFP battery chemistry does not exist. (To be more accurate, they assumed that there is a set amount of nickel/cobalt you need to produce a kWh of lithium batteries) The conclusion also requires that no significant new reserves are found after 2018, which already now is proven false. (Lithium reserves have increased since 2018 by more than what a single generation of EVs need.)


Olympic Dam SA is the world's second biggest uranium mine.

For every 0.6 kg of Uranium it produces, it produces 20kg of copper and 4.5g of silver.

Monosilicon PV is made of sand, copper, silver and aluminum.

A kg of uranium going through a pwr produces about 500GJ (with 3-10% of that being required for milling and enrichment). The 7.5g of silver in the ore that produced that kg of Uranium will produce about 200GJ in its lifetime with technologies in the pipeling that will push this to 400GJ. This silver usage is going down faster than production is increasing. There will be a huge surplus of copper from this source.

The silver is recyclable.

The uranium will require special storage for millenia or reprocessing at a cost not even massively subsidized programs are willing to bear.

The solar energy can be stored in a battery made from sodium, carbon, iron and aluminum. This is basically the composition of dirt. These are being mass produced now and full industrialisation of the supply chain is expected by 2024.

The nuclear reactor requires large quantities of zirconium, molybdenum, chromium, silver, cadmium and many other rare metals. Much of this is radioactive waste at eol.

The nuclear reactor requires more steel than the solar panel requires silicon, and more concrete than the solar panel requires glass and concrete.

A uranium mine can provide nearly as much energy from PV as it does via fission, and will soon produce more. Let that sink in for a bit.


I was curious and searched uranium for breeder reactors: I see that 1KG of Uranium will produce 86000 GJ in a breeder reactor.


The point isn't that PWRs are prohibitive. The point is that renewables are fine in any world where the only existing kind of full scale grid generating nuclear reactor is fine.


Does this take into account recycling? Regardless of if recycling is occurring now.


If there’s not enough minerals to cover all needs, let alone for EVs and power storage only, how is recycling going to help, even if 100% efficient?


The total amount of cars needed each year is a combination of people getting one for the first time and others who are replacing one. That car that is replaced, assuming it's not being resold, is material that could reenter the system.

Also moving pulling back this debate to more general topics:

1.We don't need to replace all cars, many older gas powered cars will still be on the road for a long time which buys time for points 2-4

2. There are other types of batteries, like NiMH, which don't contain lithium. Although these aren't as efficient many hybrids use them, I think the new Mavrick hybrid does (or some truck hybrid)

3. There could be new battery technology that will be invented

4.New technology has helped Tesla make more energy dense batteries and have them last longer

A 2016 model s with the 70kwh battery pack has a 200 miles of range

A 2022 Model s performance with a 98kwh battery pack has a range of 326 miles (this is a touch comparison because the new performance has much more power)

sources: https://www.caranddriver.com/features/a15104936/tesla-model-... https://electrek.co/2016/11/01/breakdown-raw-materials-tesla...


Fine but zerohedge is not really one author or one agenda, it is an aggregate of many different views and you can’t trust all of them equally…


It has a fine sprinkling of Russian state information talking points for some weird reason.


I dont find it weird, just mildly disturbing having to sift through.

Still worth it.


The have exactly one view - that of a pro**nda bureau of a certain country.


I disagree, and that is fundamental point. It is not just one view, you can pretty much check the different authors or find the original sources and they are not in agreement.

Propaganda is useless, but calling bullshit on another certain countrys propaganda, that is refreshing.

It is all your loss disregarding and hating on it


No it should be more like: I guess we should not put peanuts into vaccines without serious consideration.


Nitpicking but San Andreas does have AI where police chases work and NPC do not feel completely brainless, and cars do not only follow tracks, it does not feel empty and lifeless.


San Andreas was also, what, the third GTA game in the GTA III engine? It's a comparison between the first urban game in an engine (and the first ever for the developer) to the third game in an an engine that had years more polish (and at least the fifth urban game from the developer).

It's interesting how many of the current comparisons made to Cyberpunk are to sequels and much later iterations in various franchises (GTA, Saints Row, Crackdown, etc) and people have rose tinted glasses of the launch issues and bugs of some of their first titles.

"It's like they jumped back in time X years ago" should be the expected case for any game series because the games industry is one that notoriously doesn't have a lot of knowledge transfer, nor shared source/shared libraries, between developers and intentionally reinvents the wheel over and over again with almost every game/new game engine.

If gamers want a steadier sense of progression from game to game, studio to studio, they want a different game industry that reinvents fewer wheels between games. Expecting a single developer to somehow side step that industry problem is counter-productive to that goal. CDPR had no way to call up Rockstar and "borrow a cup of sugar", nor would they have probably been interested in doing that even if it were possible because it's less of an interesting problem full of engineering challenges to be "passionate" about to answer "how do we build Cyberpunk 2077 on top of the GTA engine?" than "how do we build Cyberpunk 2077 on top of the Witcher engine where the fastest vehicle is a horse?"


Esc key vs touch bar does not influence how you can use vim?


And if you ask me, It has not been enough touch bar bashing...

I’ve opted to buy a 2015 Mac Book Pro this year, it might be easier to get over apple than the touch bar even...


Generally agree but not that they are deterred by punishment alone, no. They will do whatever they get away with. Which would imply - “the right thing” must also be objectively better to the individual, not only backed by moral+force, for it to work generally.

(Not to mention the sociopaths are already present in politics and police. Drawn to power)


When they are small, and if you only go by your own memory I'm sure it can happen...

"Destroying angels are sometimes mistaken for edible mushrooms such as young puffballs, button mushrooms, and meadow mushrooms."

https://www.mushroom-appreciation.com/death-cap.html


I mean all of those at least look vaguely like amanitas in their full or immature form. Whereas inky caps look NOTHING like amanitas in any form.

It's more like confusing a grapefruit with a kitten or something.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: