<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Hacker News: googie</title><link>https://news.ycombinator.com/user?id=googie</link><description>Hacker News RSS</description><docs>https://hnrss.org/</docs><generator>hnrss v2.1.1</generator><lastBuildDate>Fri, 17 Apr 2026 10:13:31 +0000</lastBuildDate><atom:link href="https://hnrss.org/user?id=googie" rel="self" type="application/rss+xml"></atom:link><item><title><![CDATA[New comment by googie in "DaVinci Resolve – Photo"]]></title><description><![CDATA[
<p>For those seeking quick solution for missing codecs, here are bash scripts that use ffmpeg to convert any input clips (including these problematic h.265/h.264) to format acceptable for DaVinci<p><pre><code>  #!/usr/bin/env bash
  
  set -euo pipefail
  
  INPUT_DIR="${1:-}"
  TARGET_FPS="${2:-30}"
  
  if [[ -z "$INPUT_DIR" ]]; then
      echo "Usage: $0 <directory with clips> [target fps (defaults to 30)]"
      exit 1
  fi
  
  if [[ ! -d "$INPUT_DIR" ]]; then
      echo "Error: directory does not exist: $INPUT_DIR"
      exit 1
  fi
  
  OUTPUT_DIR="$INPUT_DIR/conv"
  mkdir -p "$OUTPUT_DIR"
    
  EXTENSIONS=(
      mp4 avi wmv mpg mpeg mov
      mkv m4v flv webm ts mts m2ts 3gp
  )
  
  shopt -s nullglob nocaseglob
  
  for ext in "${EXTENSIONS[@]}"; do
      for file in "$INPUT_DIR"/*."$ext"; do
          filename="$(basename "$file")"
          name="${filename%.*}"
  
          output="$OUTPUT_DIR/${name}.mov"
  
          echo "Konwersja: $file -> $output"
  
          ffmpeg -y -i "$file" \
              -map 0:v:0 -map "0:a?" \
              -vf "fps=${TARGET_FPS}" \
              -vsync cfr \
              -c:v prores_ks -profile:v 1 \
              -pix_fmt yuv422p \
              -c:a pcm_s16le -ar 48000 \
              "$output"
      done
  done
  
  echo "Results in: $OUTPUT_DIR"
</code></pre>
and then converting final exported video to h.265:<p><pre><code>  #!/usr/bin/env bash
  set -euo pipefail
  
  INPUT="${1:-}"
  CRF="${2:-21}"
  PRESET="${3:-slow}"
  
  if [[ -z "$INPUT" ]]; then
      echo "Usage: $0 <input file> [crf=21] [preset=slow]"
      exit 1
  fi
  
  if [[ ! -f "$INPUT" ]]; then
      echo "Error: file does not exist: $INPUT"
      exit 1
  fi
  
  DIR="$(dirname "$INPUT")"
  FILE="$(basename "$INPUT")"
  NAME="${FILE%.*}"
  
  OUTPUT="$DIR/${NAME}_h265.mp4"
  
  ffmpeg -y -i "$INPUT" \
    -map 0:v:0 -map '0:a?' \
    -c:v libx265 \
    -preset "$PRESET" \
    -crf "$CRF" \
    -pix_fmt yuv420p \
    -tag:v hvc1 \
    -c:a aac \
    -b:a 192k \
    -movflags +faststart \
    "$OUTPUT"
  
  echo "Ready: $OUTPUT"</code></pre></p>
]]></description><pubDate>Tue, 14 Apr 2026 11:00:22 +0000</pubDate><link>https://news.ycombinator.com/item?id=47763966</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=47763966</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=47763966</guid></item><item><title><![CDATA[New comment by googie in "DaVinci Resolve – Photo"]]></title><description><![CDATA[
<p>You encouraged me to try again and somehow, blackmagically ;) it works this time. It may be that recent DaVinci version has made some improvement. I'm so happy!<p>Installation still requires workarounds and codecs support is limited, but having that aknowledged and accepted, the application is finally usable!<p>PS. I don't know where the h264 (and other codes?) limitation come from, since ffmpeg has full support of it. Or is it just business model? Weird.</p>
]]></description><pubDate>Tue, 14 Apr 2026 10:05:41 +0000</pubDate><link>https://news.ycombinator.com/item?id=47763538</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=47763538</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=47763538</guid></item><item><title><![CDATA[New comment by googie in "DaVinci Resolve – Photo"]]></title><description><![CDATA[
<p>Thanks, but as far as I read it, it's all about the library file names mismatch, which is mostly covered by guides I mentioned earlier. I've done that and I got my DaVinci running. It was just audio output that did not work, despite hours spent on trying to get it work.</p>
]]></description><pubDate>Tue, 14 Apr 2026 09:13:30 +0000</pubDate><link>https://news.ycombinator.com/item?id=47763152</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=47763152</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=47763152</guid></item><item><title><![CDATA[New comment by googie in "DaVinci Resolve – Photo"]]></title><description><![CDATA[
<p>I wish they (authors of DaVinci Resolve and the Photo Editor) paid more attention to Linux platform. Theoretically DaVinci Resolve runs on Linux, but getting it run is a very bad experience on Ubuntu/Kubuntu 24.04. I even paid for the DaVinci license, as I read somewhere that for Linux it's necessary in order to have all codecs supported. It did not help. Fortunately there were no problems with refund.<p>There are whole guides online how to walk around these issues and even then I could not get the audio working. Somehow it relies on some old ALSA API, which is no longer maintained/supported on Ubuntu/Kubuntu, or I'm just too stupid to make it work. AI assistants could not provide working solution for me either.<p>I've moved back to Linux a year ago after around 10 years of Windows (and I used to use Linux Slackware for ~15 years beforehand). I am amazed how big progress the KDE made and whole Linux ecosystem. Gaming these days is just as easy as on Windows, which was my primary reason to switch to Windows. My printer just works now. Even music production is excellent on Linux now. There is plenty of great software options to choose from and they just work - as I would expect from the mature ecosystem.<p>This all feels so good, given how Linux is not pushing trash into my computer (OS-bound spyware/bloatware), has excellent, customizable UI. Full freedom. I do feel that I own my hardware.<p>Yet I miss DaVinci Resolve. For now I use Kdenlive, which is nice for simple editing, but feels unfinished, or I just don't know how to use it correctly.</p>
]]></description><pubDate>Tue, 14 Apr 2026 08:49:02 +0000</pubDate><link>https://news.ycombinator.com/item?id=47762973</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=47762973</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=47762973</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>I've got your file and I see where the problem is. I've created an issue to track and improve it for upcoming release.</p>
]]></description><pubDate>Tue, 26 Nov 2024 22:10:47 +0000</pubDate><link>https://news.ycombinator.com/item?id=42250621</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42250621</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42250621</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>Okay, never mind. I managed to reproduce the situation from your description. That's a tough one, but I will try to do something about it.</p>
]]></description><pubDate>Tue, 26 Nov 2024 19:09:19 +0000</pubDate><link>https://news.ycombinator.com/item?id=42248860</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42248860</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42248860</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>...or if you didn't mean the import() SQL function, but in general importing functionality (through Import Dialog) and it's still slow there, then please contact me and I will see what can be done to improve it - <a href="https://sqlitestudio.pl/contact/" rel="nofollow">https://sqlitestudio.pl/contact/</a></p>
]]></description><pubDate>Tue, 26 Nov 2024 08:34:44 +0000</pubDate><link>https://news.ycombinator.com/item?id=42243667</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42243667</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42243667</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>In few days there will be another 3.4.x branch release (3.4.7), which addresses this exact problem - <a href="https://github.com/pawelsalawa/sqlitestudio/issues/5119">https://github.com/pawelsalawa/sqlitestudio/issues/5119</a></p>
]]></description><pubDate>Tue, 26 Nov 2024 08:14:56 +0000</pubDate><link>https://news.ycombinator.com/item?id=42243567</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42243567</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42243567</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>Yes, please! You can contact me directly through email, or through github discussions or issues. Details are at <a href="https://sqlitestudio.pl/contact/" rel="nofollow">https://sqlitestudio.pl/contact/</a></p>
]]></description><pubDate>Tue, 26 Nov 2024 08:11:55 +0000</pubDate><link>https://news.ycombinator.com/item?id=42243547</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42243547</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42243547</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>Weird behavior indeed. I don't observe it myself on MacOS 10.11 and I had feedback from couple of other Mac users, where it worked fine - even on older MacOS than yours. I really cannot imagine what could cause your MacOS to log out. Sorry.</p>
]]></description><pubDate>Mon, 25 Nov 2024 17:22:33 +0000</pubDate><link>https://news.ycombinator.com/item?id=42238079</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42238079</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42238079</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>The file you linked is around 388kB in size. Are you sure it's the one you intended to link? I've checked it anyway and I see no problem for SQLite to open and query views from that db file.</p>
]]></description><pubDate>Mon, 25 Nov 2024 17:07:52 +0000</pubDate><link>https://news.ycombinator.com/item?id=42237935</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42237935</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42237935</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>You can right-click and run from the context menu, in which case it should start.
Contributions are welcomed.</p>
]]></description><pubDate>Mon, 25 Nov 2024 14:26:45 +0000</pubDate><link>https://news.ycombinator.com/item?id=42236550</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42236550</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42236550</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>Actually the project is much older. It started in 2007. More details on this can be found at <a href="https://sqlitestudio.pl/about/" rel="nofollow">https://sqlitestudio.pl/about/</a></p>
]]></description><pubDate>Mon, 25 Nov 2024 08:47:44 +0000</pubDate><link>https://news.ycombinator.com/item?id=42234407</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42234407</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42234407</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>Author here. I'm surprised and honored to have my pet project here ;) As mentioned in another comment, I'm currently in the process of bugfixing/polishing 3.4.x branch. Then I will focus more on 3.5.0, which will bring many big features. One of them being ERD (read & write).</p>
]]></description><pubDate>Mon, 25 Nov 2024 08:45:44 +0000</pubDate><link>https://news.ycombinator.com/item?id=42234398</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42234398</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42234398</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>For example it has context-aware syntax autocompletion, easy D&D for tables between databases, and many more - you can see longer list at <a href="https://sqlitestudio.pl/features/" rel="nofollow">https://sqlitestudio.pl/features/</a></p>
]]></description><pubDate>Mon, 25 Nov 2024 08:38:17 +0000</pubDate><link>https://news.ycombinator.com/item?id=42234371</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42234371</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42234371</guid></item><item><title><![CDATA[New comment by googie in "SQLiteStudio: Create, edit, browse SQLite databases"]]></title><description><![CDATA[
<p>Author here. This was never reported. I haven't noticed it for myself either. Feel free to get in touch through the official email (mentioned on the homepage) or through GitHub issues. I'm in the process of polishing 3.4.x branch, eliminating as many bugs as possible, before focusing on 3.5.0.</p>
]]></description><pubDate>Mon, 25 Nov 2024 08:36:19 +0000</pubDate><link>https://news.ycombinator.com/item?id=42234359</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=42234359</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=42234359</guid></item><item><title><![CDATA[New comment by googie in "Show HN: New AI edits images based on text instructions"]]></title><description><![CDATA[
<p>Note, that I have the CUDA installed. Still the imaginAIry
 runs on CPU :(</p>
]]></description><pubDate>Fri, 27 Jan 2023 16:36:53 +0000</pubDate><link>https://news.ycombinator.com/item?id=34548025</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=34548025</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=34548025</guid></item><item><title><![CDATA[New comment by googie in "Show HN: New AI edits images based on text instructions"]]></title><description><![CDATA[
<p>How to make it use my GPU (I have RTX 3070)? It complains about using sloooow CPU, but I don't see option to switch to GPU, which I think should be sufficient...? I'm running it on Windows 10.</p>
]]></description><pubDate>Fri, 27 Jan 2023 11:43:59 +0000</pubDate><link>https://news.ycombinator.com/item?id=34544980</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=34544980</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=34544980</guid></item><item><title><![CDATA[New comment by googie in "SQLite 3.32"]]></title><description><![CDATA[
<p>It does.</p>
]]></description><pubDate>Sat, 23 May 2020 22:31:03 +0000</pubDate><link>https://news.ycombinator.com/item?id=23287155</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=23287155</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=23287155</guid></item><item><title><![CDATA[New comment by googie in "Appropriate Uses for SQLite"]]></title><description><![CDATA[
<p>Yet another free, open source and multiplatform GUI is SQLiteStudio ( <a href="http://sqlitestudio.pl/" rel="nofollow">http://sqlitestudio.pl/</a> ).</p>
]]></description><pubDate>Mon, 26 Sep 2016 11:37:00 +0000</pubDate><link>https://news.ycombinator.com/item?id=12580969</link><dc:creator>googie</dc:creator><comments>https://news.ycombinator.com/item?id=12580969</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=12580969</guid></item></channel></rss>