Removing duplicate records from a table in Sqlite3 when “DELETE” doesn’t support “LIMIT 1”

I love to know how many lines I’ve added and deleted before making a commit. This is why I created this alias: alias svn_diff_counter=’svn diff | egrep “^[+|-].*” | egrep -v “(+++)|(—)” > .tmp_diff_counter ; added=`egrep “(^+)” .tmp_diff_counter | wc -l`; removed=`egrep “(^-)” .tmp_diff_counter | wc -l`; rm .tmp_diff_counter; echo “Lines Added vs. Line Removed […]