/dev/random

sqlite dump to csv

Mon Feb 6 22:05:46 2017

Since I always forget…

$ sqlite3 postal_codes.db
SQLite version 3.8.5 2014-08-15 22:37:57
Enter ".help" for usage hints.
sqlite> .mode csv
sqlite> .output foo.csv
sqlite> .dump postal_codes
sqlite> ^D

/etc

  1. 13 Aug 2023 Dark mode!!!
  2. 15 Aug 2022 Wordle Suggestions
  3. 30 Dec 2021 MetaMask Local Network
  4. 21 Oct 2021 Alleviating Meeting...
  5. 07 Aug 2021 Pairwise Comparison...
  6. 21 Jul 2021 Using the Logistic ...
  7. 15 Jul 2021 _init_completion: c...
  8. 18 Jun 2021 Running DynamoDB Lo...
  9. 21 Mar 2021 Git Rebase Onto
  10. 21 Apr 2020 OS X Mission Contro...
  11. 03 Apr 2020 ImageMagick stitch ...
  12. 21 Mar 2020 iTerm2 Keys
  13. 05 Dec 2019 Python itertools.pr...
  14. 10 May 2019 ISO_31-11
  15. 22 Mar 2019 Cons cells (python ...
  16. 12 Mar 2019 Ordered Symbol Tabl...
  17. 06 Mar 2019 Docker: No space le...
  18. 14 Dec 2018 Vim Window Resizing
  19. 11 Nov 2018 brew macvim woes
  20. 31 Oct 2018 Iterated logarithm
  21. 30 Oct 2018 Bash 'Command' Builtin
  22. 16 Sep 2018 discrete math
  23. 31 Jul 2018 killall Dock
  24. 26 May 2018 Ruby defaultdict
  25. 04 May 2018 Docker detach
  26. 19 Apr 2018 Additive Inverse
  27. 17 Apr 2018 Remove from Chrome ...
  28. 24 Mar 2018 Database N+1 Queries
  29. 08 Mar 2018 Book: The Power of ...
  30. 02 Mar 2018 Associative entity
  31. 30 Jan 2018 AWS S3
  32. 05 Dec 2017 Recursive Cartesian...
  33. 04 Nov 2017 Products and trees
  34. 23 Oct 2017 Git: cleanup merged...
  35. 21 Oct 2017 Combinatorics refre...
  36. 19 Oct 2017 Run-length encoding
  37. 17 Oct 2017 Last git branch
  38. 30 Sep 2017 YubiKey All The Things
  39. 14 Sep 2017 Send More Money
  40. 11 Aug 2017 Map lookup time
  41. 31 Jul 2017 jq to the rescue
  42. 27 Jul 2017 Circular Right Rotate
  43. 08 May 2017 RSpec gotcha (err me)
  44. 07 Apr 2017 mount bigger /dev/shm
  45. 11 Mar 2017 Symmetric Key Encry...
  46. 19 Feb 2017 Euclid's algorithm
  47. 08 Feb 2017 getting ssl certs
  48. 06 Feb 2017 sqlite dump to csv
  49. 04 Jan 2017 Hash comprehension?
  50. 02 Dec 2016 custom pry commands
  51. 08 Nov 2016 ImageMagick identify
  52. 06 Oct 2016 date manip
  53. 22 Sep 2016 Docker snippets
  54. 21 Jun 2016 elasticsearch bulk api
  55. 30 May 2016 Fibonacci Fun Time
  56. 21 Apr 2016 require 'pry'; bind...
  57. 09 Apr 2016 ffmpeg time lapse
  58. 29 Feb 2016 rlwrap ftw
  59. 25 Feb 2016 NGINX proxy_pass to...
  60. 17 Feb 2016 git gui blame
  61. 05 Feb 2016 xargs with files wi...
  62. 22 Jan 2016 screen in screen in...
  63. 22 Dec 2015 Debugging Octave/Ma...
  64. 13 Nov 2015 pdb aliases are you...
  65. 06 Nov 2015 moreutils::sponge
  66. 07 Oct 2015 nvm error: Checksum...
  67. 22 Aug 2015 GPG snippets
  68. 12 Jul 2015 No more sslwrap
  69. 08 Jun 2015 Git flow bullets/ch...
  70. 07 Jun 2015 Markdownify'ing web...
  71. 22 May 2015 brute force arithmetic
  72. 15 May 2015 host dns lookup
  73. 02 Apr 2015 E141: No file name ...
  74. 01 Apr 2015 netlify'ing :)
  75. 07 Feb 2015 Instagram python ap...
  76. 22 Dec 2014 CPython vs C Perfor...
  77. 07 Nov 2014 Nibble to binary st...
  78. 24 Oct 2014 Python Package to RPM
  79. 09 Oct 2014 ssh force IdentityFile
  80. 24 Sep 2014 Memoization tests (...
  81. 22 Aug 2014 VirtualBox Bridged ...
  82. 19 Aug 2014 Mac OS X NFS Client
  83. 19 Aug 2014 GTK Emacs Keybindings
  84. 07 Aug 2014 Linux Caps Lock to ...
  85. 04 Aug 2014 SD card dd unbuffer...
  86. 23 Jul 2014 CentOS(ish) Static IP
  87. 16 Jul 2014 Imaged OS mac addre...
  88. 12 Jul 2014 ssh disable public ...
  89. 12 Jul 2014 Modify Raspberry Pi...
  90. 02 Jul 2014 Refresh postfix
  91. 30 Jun 2014 Install pip for the...
  92. 10 Jun 2014 Apache mod_rewrite ...
  93. 16 May 2014 Manage dotfiles wit...
  94. 23 Apr 2014 git grep with blame
  95. 06 Apr 2014 PostgreSQL Ident Au...

mike(at)cadizm.com