• Butt Pirate@reddthat.com
    link
    fedilink
    English
    arrow-up
    8
    ·
    1 year ago

    I love SQLite in the command line. Being able to import data sets into a db that I can quickly write queries for has saved me a lot of data processing time.

    • xchgeaxeax
      link
      fedilink
      English
      arrow-up
      4
      ·
      1 year ago

      The CSV import tool is so useful too. I’ll find myself looking at an excel sheet or something and thinking “if only I could query this like SQL”.

      • Butt Pirate@reddthat.com
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 year ago

        Yes, exactly! I just import the data into SQLite as an in memory db, execute whatever query I want and .output the answer somewhere. It’s so easy and clean.