Hacker News new | past | comments | ask | show | jobs | submit login

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



Hey now if you're just gonna count lines no need to sort it at all.


you need to sort it in order to uniq it, because uniq only removes duplicate consecutive lines.


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




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

Search: