Rapture in Everything

Posts tagged "tools"

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....

Tackling the information overload, part 2

In the previous post I described the problems I face when trying to reap the benefits of the Internet while staying sane. In essence, I wanted to be able to maintain a stash of interesting things to pick from when I have the time, to keep track of articles (and other stuff) I want to get back to later, and to have an efficient way of retrieving resources I have found along the way. These should all be available from multiple devices. So in the order of usage it goes like this: Saving for later Browser bookmarks might be good...

Tackling the information overload

Probably everyone who uses the web for more than just reading mail and reading a few websites every day has encountered the same problem: the Internet is big. Like, really big. For virtually any topic you take interest in there are more articles than we can handle; there is ton gigabyte upon gigabyte of images, videos and texts we’d love to read but never will have enough time for. And then there’s the noise – for every useful bit of information we need there are a dozen blog posts that just get in our way of finding it. Then...

Bit.ly kinda sucks, doesn't it

Until a while ago, bit.ly for me was something I was vaguely aware of and occasionally used to shorten links. When I started using IFTTT (an awesome service everyone should be using), I browsed the available channels and checked some out at random. Bit.ly looked promising, so I registered and started adding links. My main goal was to hook everything up via IFTTT, so all the content I gather from various services gets bookmarked in a single place for later viewing. (More on that in a future post, maybe.) My most used recipe. (Update Dec 2019 - the...