4 ms·

yeah, they could have done `sqlite …|sort -u|wc -l` instead and saved themselves a process invocation!

• silisili 2y ago
  Hey now if you're just gonna count lines no need to sort it at all.
  • lilyball 2y ago
    you need to sort it in order to uniq it, because uniq only removes duplicate consecutive lines.
    • silisili 2y ago
      You know, it's been so long since I've used it, I completely forgot that fact. Alright, you win the battle of best correct bad sql to bash pipeline :).