ᴄʜᴏᴋɪᴅᴀʀ@lemmy.world to Programming@programming.devEnglish · 1 year agoConsider SQLiteblog.wesleyac.comexternal-linkmessage-square68fedilinkarrow-up179arrow-down11
arrow-up178arrow-down1external-linkConsider SQLiteblog.wesleyac.comᴄʜᴏᴋɪᴅᴀʀ@lemmy.world to Programming@programming.devEnglish · 1 year agomessage-square68fedilink
minus-squarexchgeaxeax@sh.itjust.workslinkfedilinkEnglisharrow-up3·1 year agoThe 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”.
minus-squareButt Pirate@reddthat.comlinkfedilinkEnglisharrow-up3·1 year agoYes, 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.
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”.
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.