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.

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.

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

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 ... 

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

    
    
    
    ... main content here
    
    

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

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

You should have a low bandwidth setting that also uses new codecs.

Like 64kbit stereo opus is to my ears almost imperceptible to CD audio. I think listening tests by professionals recommend using between 64kbit to 96kbit for perfect audio.

Anything beyond is a waste unless we are talking about more than stereo.

Also if you want, you can use mpeg dash to stream video. Here you encode video into small series of chunks/files. When player can't handle high bandwidth, it can switch to lower bandwidth automatically, and vice versa. This is what YouTube and any professional places do. This will also help prevent users from easily downloading complete video. The trick is that you will need to ensure all videos are split on same key frame, so either use two pass encoding, or define that every ?3? seconds exactly is a new video file.

https://www.cloudflare.com/en-ca/learning/video/what-is-mpeg...

In chrome and firefox: Settings accessibility text size.

Also awesome to see comparison to EnCodec , which I think is one of the better ones available : https://ai.honu.io/papers/encodec/samples.html

Also, can you confirm if Opus decode is classical or with Lace or NoLace post processing filters that are available in Opus 1.5?

Also I don't seem to be able to access your page, so there might be error.

Finally, when doing opus comparison it's good now to denote if it is using Lace or NoLace decoder post processing filters that became available in opus 1.5 (note, this feature need to be enabled at compile time, and defying decode a new API call needs to be made to force higher complexity decoder) . See https://opus-codec.org/demo/opus-1.5/

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.

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.

* 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.

- 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.

App developers want consistent look of their application across various OSes, be it Mac/Win/Linux. This means developing with gtk for linux and winUI for windows is out of the window. Why do app developers want consistent look? because alternatively they would have to create documentation and screenshots for each os separately. And users wouldn't be able to help each other because Mac user would know different interface/look from Linux user.

OS developers, Apple/Microsoft don't have singular look. Microsoft didn't rewrite everything into WinUI settings , and anytime anyone needs to do anything serious they have to go through the win32 settings panels. This lack of OS coherency means that app developers don't feel need to stay consistent with OS, since OS itself is not uniform.

Additionally, in airplane mode it heavily doesn't want to translate, in my use case I have to go to saved translations as otherwise it won't even let me type what I need to translate.

Otherwise, someone sharing same data again, because it will be in different IPFS folder won't be actually discoverable as same data.