Hacker Newsnew | past | comments | ask | show | jobs | submit | adamzochowski's commentslogin

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


Because that requires a server with the proper config and this is an HTML file. So it works in every environment, like locally on your machine, or GitHub pages.


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


If you use it in the same way you use trailing commas. Fair. But the site says to make it easier to add dynamic conditions. Which is a terrible idea in maybe not all but many SQL engines.


Last 3 years I traveled extensively and had limited and flakey bandwidth.

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


there are audio-only and 360p versions. in addition to 720p and 1080p.


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

In chrome and firefox: Settings accessibility text size.


I’m on Orion on iOS. I’ve glanced at if it’s possible, but frankly I’m fine with Reddit being a PITA to use. That just means I use it less.


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.


Since Ballard's codec is "AI" based, can you add google's lyrav2 ( https://github.com/google/lyra ) and Facebook's/meta EnCodec ( https://github.com/facebookresearch/encodec ).

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/


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

Interesting, do you have javascript turned off? Can you access this page? https://html.non.io/TSAC-Comparisons/


The page works, earlier when I tried I got a login page. This page is good.

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 added EnCodec, but wasn't able to get the prereqs working for lyra2.


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.


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

Search: