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

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


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.


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

Search: