adamzochowski

Makes perfect sense .

NaN is a special type indicating one can't reason about it normal way.

It is an unknown or value that can't be represented.

When comparing, think of it like comparing two bags of unknown amount of apples.

One bag has NaN count of apples

Other bag has NaN count of apples

Do the two bags have equal number of apples?

I wish all languages used nulls the way SQL does.

Not a referral issue. Doing ctrl-click or middle-click or open-in-a-new-tab all are broken too.

Most likely it is just a typical broken spa.

Most web apps, are shut for the websites. They ignore and badly processes the url because things like linking to content, ctrl-click, bookmarks, sharing with friends are afterthought and not on forefront of developers mind.

This depends on the join type.

    select ...
    from table1 
        left join mytable2 on ... 
    where ..

If you move contents of where clause to the join/on clause, you will change meaning of the query.

If someone has a complex query or complex performance, they could do either subselects

    select ...
    from ( select ... from table1 where ... ) as table1_filtered
        inner join mytable2 on ... 

or CTEs

    with table1_filtered as ( select ... from table1 where ... ) 
    select ...
    from table1_filtered
        inner join mytable2 on ...

BMP supports compression, but its basic, RLE style, so only line art compresses well.

Why not use server side includes? Most web servers support it, and it dates back to one of the early features of webservers.

    <!--# set var="pagetitle" value="Main page" -->
    <!--# include file="00__header.html" -->
    
    ... main content here
    
    <!--# include file="00__footer.html" -->

Can you expand on this? How is having

    WHERE 1=1
    AND ...[usual-where-clause]...

A performance and security compared to doing

    WHERE ...[usual-where-clause]...

Why not change font zoom for old.reddit.com domain?

In chrome and firefox: Settings accessibility text size.

If it were on GOG, there would be no DRM or third party accounts required. With potential exception for online play. But most GOG games are single player offline games. Even online games would be more of the type where you run local server and connect with you friends by sharing IP:port combo.

Please, keep lossy compression. Web is unusable already with websites too big as it is.

What should happen: websites/applications shouldn't recompress images if they already deliver good pixel bitrate. Websites/applicates shouldn't recompress images just to add own watermarks.

> The Crew does not seem like an example of this since it is a multplayer game.

One can play The Crew single player, it has a whole campaign. There have been tons of games that are single player with multiplayer elements. This is same as GTA5 or The Division or any other game which is single player and multiplayer

> That requires that it was ever a single binary in the first place

Or release all binaries / source code. The whole docker swarm config, or the terraform or whatever was used to run the stuff. Not sure if server side is two binaries out of a sudden it is impossible.

> Sure, that's an alternative but it still takes time for them to do it.

Why? release all the docs+source code as you have them, and call it a day.

> There is something to be said about as a consumer understanding that an "online game" will eventually shut down. This should be well understood.

Why? I had played tons of online games that were not shut down. Dooms, quakes, warsaw, etc. This is a relatively new thing that companies are both, not allowing single player run without a server, and shutting down the server part. I think in the past we had similar thing when GameSpy was shutdown, and recently Games For Windows Live which microsoft stopped supporting. However, these are mostly DRM cases with some bypass possible.

I want to add, I suspect Blizzard has complex architecture, but people managed to reverse engineer the server to run custom diablo/starcraft/wow servers. Now blizzard as they have not shutdown their services has been actively fighting these efforts of custom servers. All the ask is that companies that do shutdown their services do the opposite. Help community run the games longer.

In case of The Crew, the shut down was a deliberate push to get people to buy The Crew 2.

I would add

* ability to confirm email validity by logging into my bank and seeing same email in their communication queue with me

My bank sends me emails, and I have no way to confirm that the bank really sent them.

Aren't there two arguments for why this is bad?

- db will generate new plans as necessary when row counts and values change. Putting in hints makes the plan rigid likely leading to headaches down the line.

- as new Postgres comes out, it's planner will do a better job. Again forcing specific plan might force the planner into optimization that no longer is optimal.

In my experience developers almost never comeback to a query with hints to double check if hints are really needed.

Famously oracle has query hints that don't do nothing no more, that are ignored, but oracle can't remove them from query language because that would break too many existing queries.

I like Postgres stance that if query planner doesn't do a good job, then dba should first update table/column statistics, and if things are truly bad, submit but to Postgres so the query optimizer can be updated itself.

Saying all that, hints support through an extension to Postgres is a good compromise. Postgres developers don't need to bother with hints, its a third party feature. And dba/users, if they really need hints, now they have them.