3 ms·
Tell me when you can grep or sed an sqlite database, or cleanly check it into a git repo.
by CarelessExpert 7y ago
Tell me when you can grep or sed an sqlite database, or cleanly check it into a git repo.
- bachmeier 7y agoI've never heard of Recutils before, but I've been using grep, sed, awk, cut, etc. to work with data for years. sqlite is just too much of a hassle for version control and sharing. If I use sqlite, I have to export to text, commit and push, pull on the new machine, then import into sqlite. I've never run into performance issues even with thousands of records.
- CarelessExpert 7y agoAnd where you need a reasonably performant relational data store, all those cumbersome gymnastics might be worth it. But if you're working with a modest dataset where volume and performance aren't a primary concern, working straight in text is infinitely more convenient. There's a reason people do so much bulk data processing in CSV, JSON, or other easily manipulated formats.