ᴄʜᴏᴋɪᴅᴀʀ@lemmy.world to Programming@programming.devEnglish · 2 years agoConsider SQLiteblog.wesleyac.comexternal-linkmessage-square75fedilinkarrow-up180arrow-down11
arrow-up179arrow-down1external-linkConsider SQLiteblog.wesleyac.comᴄʜᴏᴋɪᴅᴀʀ@lemmy.world to Programming@programming.devEnglish · 2 years agomessage-square75fedilink
minus-squarexchgeaxeax@sh.itjust.workslinkfedilinkEnglisharrow-up3·2 years 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-up4·2 years 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.