Rapture in Everything

Posts tagged "data"

csv-to-sqlite - copying from CSV files to a SQLite database

csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....

Migrating from Shelfari to Goodreads with OpenRefine

It seems that most of my friends are on (or have moved to) Goodreads. I like it a lot less than Shelfari, but I’m starting to think I’ll have to switch anyway. So naturally, I’m looking to migrate my data. How to do it depends on how lazy you are. If you don’t mind doing some manual work, there’s this guide that I’ve used as reference. If you’d rather use OpenRefine and save yourself the trouble, here’s a solution I’ve prepared. (I can’t seem to stop myself from working for...