Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

The screenshot section in the README seems to be empty. Would've been interesting to see that. There's many tools that do similar things like https://github.com/ankane/pghero or some tools here: https://gitlab.com/postgres-ai


I think it's probably just a large file, as I remember thinking the same thing but it was loaded when I returned to the browser tab with the readme later on.


Ah, you are right. I'm on a slow connection right now and it's a 22MB gif.

(https://github.com/nexsol-technologies/pgassistant/tree/main...)


> and it's a 22MB gif

Whoa... that's a lot of data for a README! But demos are pretty important, so I guess it's worth it.


A mp4 would be a much better choice instead of a gif and probably ~1.5MB.


    ffmpeg -y -i pgassistant.gif -c:v libx265 -q 55 -tag:v hvc1 -movflags '+faststart' -pix_fmt yuv420p pgassistant.mp4
That takes the GIF down to 1338973 bytes (1.3M) with (to my eyes) little loss of readability.


  __264516 Feb 12 11:44  pgassistant.gif
  22782965 Feb 12 11:46  pgassistant.gif.raw.gif
  _2120322 Feb 12 11:55  pgassistant.gif.av1-20.mp4
  __245780 Feb 12 11:56  pgassistant.gif.av1-55.mp4
wget -O pgassistant.gif.raw.gif 'https://github.com/nexsol-technologies/pgassistant/blob/main...'

ffmpeg -h encoder=libaom-av1

ffmpeg -i pgassistant.gif.raw.gif -c:v libaom-av1 -crf 20 -cpu-used 8 -movflags '+faststart' -pix_fmt yuv420p pgassistant.gif.av1-20.mp4

ffmpeg -i pgassistant.gif.raw.gif -c:v libaom-av1 -crf 55 -cpu-used 8 -movflags '+faststart' -pix_fmt yuv420p pgassistant.gif.av1-55.mp4

A place to start from at least, note the 264516 gif is what's currently on the landing page, with the wget command to grab the raw file.


Is there any benefit in using libaom-av1 over libsvtav1 nowadays?


Licensing, patents (as far as I've heard anyway).

NEARLY everything can use AV1 and you don't need your clients to install a licensed codec if their OS didn't happen to include one. https://caniuse.com/av1 Far more than https://caniuse.com/hevc


libaom-av1 and libsvtav1 are both AV1, the former being the reference implementation and the latter simply far faster


Submit a PR?


I'm trying but it turns out that it's impossible to submit a useful PR with a video embed in `README.md` because the only way it works is by uploading the video through the web editor[0] and using a static user-images.githubusercontent.com URL.

[0] Which puts it under your account, obvs., and is therefore not that helpful for a PR.


Maybe just open an issue and provide the ffmpeg command then


Yeah, did that in the end.


Good point.




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

Search: