15 ms·

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

dewey 2y ago
A mp4 would be a much better choice instead of a gif and probably ~1.5MB.
- zimpenfish 2y ago
  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.
  - ai-christianson 2y ago
    Submit a PR?
    - zimpenfish 2y ago
      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.
      - ai-christianson 2y ago
        Maybe just open an issue and provide the ffmpeg command then
        zimpenfish 2y ago
        Yeah, did that in the end.
  - mjevans 2y ago
    __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/media/pgassistant.gif?raw=true 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.
    - kirici 2y ago
      Is there any benefit in using libaom-av1 over libsvtav1 nowadays?
      - mjevans 2y ago
        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 https://caniuse.com/av1 Far more than https://caniuse.com/hevc https://caniuse.com/hevc
        kirici 2y ago
        libaom-av1 and libsvtav1 are both AV1, the former being the reference implementation and the latter simply far faster
- ai-christianson 2y ago
  Good point.

dewey 2y ago

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

zimpenfish 2y ago
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.
- ai-christianson 2y ago
  Submit a PR?
  - zimpenfish 2y ago
    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.
    - ai-christianson 2y ago
      Maybe just open an issue and provide the ffmpeg command then
      - zimpenfish 2y ago
        Yeah, did that in the end.
- mjevans 2y ago
  __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/media/pgassistant.gif?raw=true 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.
  - kirici 2y ago
    Is there any benefit in using libaom-av1 over libsvtav1 nowadays?
    - mjevans 2y ago
      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 https://caniuse.com/av1 Far more than https://caniuse.com/hevc https://caniuse.com/hevc
      - kirici 2y ago
        libaom-av1 and libsvtav1 are both AV1, the former being the reference implementation and the latter simply far faster
ai-christianson 2y ago
Good point.