googl-free (u/googl-free)

googl-free commented on SciPy builds for Python 3.12 on Windows are a minor miracle labs.quansight.org/blog/b... · Posted by u/todsacerdoti

mattbillenstein · 2 years ago

Very naive question, but are the semantics of Fortran so different that it can't be translated to C first and then compiled using a C compiler? Perhaps maintained in C going forward?

I can't imagine there are a lot of Fortran folks around maintaining these old libraries - they must need maintenance no?

googl-free · 2 years ago

yeah, fortran has native arrays

googl-free commented on Oil and gas production in Texas produces twice as much methane as in New Mexico theguardian.com/us-news/2... · Posted by u/webmaven

tigerstyle · 2 years ago

My hunch would be that abandoned wells are more responsible for this issue than better regulated new wells. Old wells are more likely to leak, as shown in the link below, are often never checked on, and were often drilled and shut-in when there was a lot less regulation. They can be venting directly to atmosphere, and since natural gas is naturally odorless and wells are often in remote locations, the potential for them to leak a lot of gas for a long time is high.

Texas has a lot more historical production of oil and gas, which should result in a lot more old and abandoned wells. That doesn't give them a pass, but if this hypothesis is true, this flaring regulation would not have a major impact.

https://www.reuters.com/article/us-usa-drilling-abandoned-sp...

googl-free · 2 years ago

unfortunately this isn't really the case. the industry knows its throwing away massive amounts of methane from the active fracking based wells. texas railroad commissioner is on the record defending it as carbon neutral because if you leak it or capture and burn it, it adds the same carbon footprint. methane flares are permitted at huge volumes. and if you drive i-10 between el paso and san antonio, its starkly clear

googl-free commented on Things I wish I’d known before fulltime RVing (2017) wheelingit.us/2011/09/22/... · Posted by u/cf100clunk

seattle_spring · 2 years ago

Question for all the RVers here on HN: why do so many of you refuse to use designated pull outs? The ones specifically created for vehicles like yours to move over and let the dozen+ cars behind you pass so they can go more than 20 under the speed limit. Many RVs I encounter even go out of their way to prevent passing. I don't really understand it, and it seems like an RV-specific behavior.

googl-free · 2 years ago

If they're going as slow as you claim, then cross the double yellow and pass. Not that hard

googl-free commented on A mansion hidden directly under the Bay Bridge sfgate.com/obscuresf/arti... · Posted by u/thunderbong

CPLX · 2 years ago

San Francisco is the only place I know with this bizarre obsession that things shouldn’t be allowed to cast shadows on other things, as a general rule.

It’s just strange.

https://www.sfchronicle.com/politics/article/SF-supervisors-...

googl-free · 2 years ago

We have this in Austin too. Also the capitol view corridor, an inverted system protecting sightlines to the capitol building

googl-free commented on Cyclists now outnumber motorists in City of London forbes.com/sites/carltonr... · Posted by u/gcoleman

margorczynski · 2 years ago

Yes. But that doesn't change the fact that given current reality the safety of moving in a car is higher than when using a bike. How it could and should be is a different matter.

googl-free · 2 years ago

It's only safer on a per mile basis. Per hour and per trip, driving is more dangerous.

googl-free commented on There’s no such thing as a tree phylogenetically (2021) eukaryotewritesblog.com/2... · Posted by u/dynm

lukeasrodgers · 3 years ago

What do you mean their general systems theory is unmatched? Unmatched for what? I have read a bunch of D&G (as well as D on his own) and generally enjoy their writing, but I find it basically useless in my every day life and work (software engineering), my attempts to understand science and the world, etc. For example the "body without organs" is a cool idea that unites a lot of seemingly disparate phenomena, but other than that it kind of useless. It does not lend itself to making predictions, drawing causal connections between things. I don't think it's even a good intuition pump, in Dennett's sense. Most of the "use" of D&G's philosophy that I'm familiar with boils down to "oh hey this thing is kind of rhizomatic and look at how it antagonizes capitalist structures". Would love to be proven wrong, since I spent hundreds of hours and thousands dollars getting an education with a strong emphasis on this kind of stuff.

googl-free · 2 years ago

In software engineering, monkey patching and use-after-free are some examples of lines of flight. Broadly though, an ossified and financialized academy is never going to embody a rhizome. Check out the interview with the IDF commander who "use"s deterritorialization. If you want predictions, Nick Land was full of them

googl-free commented on PostgreSQL 15 postgresql.org/about/news... · Posted by u/jkatz05

CodeIsTheEnd · 3 years ago

This release includes a feature I added [1] to support partial foreign key updates in referential integrity triggers!

This is useful for schemas that use a denormalized tenant id across multiple tables, as might be common in a multi-tenant application:

    CREATE TABLE tenants (id serial PRIMARY KEY);
    CREATE TABLE users (
      tenant_id int REFERENCES tenants ON DELETE CASCADE,
      id serial,
      PRIMARY KEY (tenant_id, id),
    );
    CREATE TABLE posts (
        tenant_id int REFERENCES tenants ON DELETE CASCADE,
        id serial,
        author_id int,
        PRIMARY KEY (tenant_id, id),
        FOREIGN KEY (tenant_id, author_id)
          REFERENCES users ON DELETE SET NULL
    );

This schema has a problem. When you delete a user, it will try to set both the tenant_id and author_id columns on the posts table to NULL:

    INSERT INTO tenants VALUES (1);
    INSERT INTO users VALUES (1, 101);
    INSERT INTO posts VALUES (1, 201, 101);
    DELETE FROM users WHERE id = 101;
    ERROR:  null value in column "tenant_id" violates not-null constraint
    DETAIL:  Failing row contains (null, 201, null).

When we delete a user, we really only want to clear the author_id column in the posts table, and we want to leave the tenant_id column untouched. The feature I added is a small syntax extension to support doing exactly this. You can provide an explicit column list to the ON DELETE SET NULL / ON DELETE SET DEFAULT actions:

    CREATE TABLE posts (
        tenant_id int REFERENCES tenants ON DELETE CASCADE,
        id serial,
        author_id int,
        PRIMARY KEY (tenant_id, id),
        FOREIGN KEY (tenant_id, author_id)
          -- Clear only author_id, not tenant_id
          REFERENCES users ON DELETE SET NULL (author_id)
          --                                  ^^^^^^^^^^^
    );

I initially encountered this problem while converting a database to use composite primary keys in preparation for migrating to Citus [2], and it required adding custom triggers for every single foreign key we created. Now it can be handled entirely by Postgres!

[1]: https://www.postgresql.org/message-id/flat/CACqFVBZQyMYJV%3D...

[2]: https://www.citusdata.com/

googl-free · 3 years ago

Wait, did we also get trailing comma support in column lists?

googl-free commented on So You Want to Compete with Steam (2018) fortressofdoors.com/so-yo... · Posted by u/wetpaws

ninjinxo · 3 years ago

No, dota has a paid subscription ($5 p/m) which gates gameplay features, many of which would be really useful for newer players - ingame coaching, item suggestions, hero pick suggestions, death summary, live gameplay tips, avoid player list, ranked mmr double downs that can be used after drafting phase, exclusive modes, and live spectating (free users have to use discord streaming or spectate with 2 minutes delay).

googl-free · 3 years ago

Dota plus item and skill suggestions are way worse than the build guides. The only worthwhile feature is the avoid list

googl-free commented on So You Want to Compete with Steam (2018) fortressofdoors.com/so-yo... · Posted by u/wetpaws

ninjinxo · 3 years ago

You mean the company that pioneered:

Microtransactions, real money loot-boxes, gambling, NFT marketplace, battlepasses

doesn't milk it's users?

Dota used to have $35 "arcanas", a high quality skin for a single hero which were released intermittently - but that wasn't enough money, they're now placed $200+ deep in the yearly battlepass. If you played any of their games, you'd realise they're one of greediest in the business.

googl-free · 3 years ago

Their tournament organizing is piss poor for how much the battlepasses bring in

googl-free commented on Bikes, not self driving cars, are the technological gateway to urban progress nextcity.org/urbanist-new... · Posted by u/martopix

Eji1700 · 3 years ago

I do think this is a more complex problem than people give credit.

I've seen bike lanes added to roads, and almost no one is happy. There's always idiot drivers and bikers and every now and then someone gets hurt or killed.

Bike paths make infinitely more sense (especially since they dont have to follow roads and can take more direct paths), but cities seem loathe to adopt them vs just painting some lines on a current street.

Finally climate plays a huge part as well. I live where it gets over 100f in the suummer routinely. Even a 3 mile bike ride at that point means you're drenched in sweat, which is just not acceptable in a majority of environments. Showers can be added but water is already a resource we're flippant with when we really shouldn't be.

Finally its not a great solution for the elderly and has some risks. Yes they can ride an e bike, but when you screw up at 20 mph in a sedan you wind up with a very expensive bill and an insurance premium hikes. When you crash on a bike, even with saftey gear, you can wind up pretty seriously injured.

None of this isnt to say we should not build more bike paths/trains/subways/busses, but I dont think its a one solution fits all sort of thing.

googl-free · 3 years ago

If you're afraid of showing visible signs of sweat on a 100F day, something else is wrong.

I bike commute in Texas year round about 8 miles one way. 4-5 days a week. 104F or 22F.

For a typical day, it takes about 15 minutes of air conditioning for me to stop sweating, and I don't even change my shirt. On a more formal day, I'll arrive an hour early and bring my button down and pants in a bag, and the key is to completely stop sweating before you change. If you shower in the morning at home, a bit of sweat isn't going to make you stink. Office shower is a plus if you do cold showers though

I'm not a jock but being a bike commuter gets you more positive office cred than the anti-sweat pearl clutching gets you negative office cred.