Rapture in Everything

Posts tagged "tools"

csv-to-sqlite 2.0 - memory improvements

My csv-to-sqlite script got some updates - most importantly it now requires far less memory....

Leaving Evernote for Joplin

I have been looking for an Evernote replacement for the longest time. It's a nice tool, but it has some features and limitations that irritated me: no markdown support (the HTML in the editor often got messy), no end-to-end encryption or control over my data, and a restrictive device limit and online-only requirement in the free version. While one could argue I could have paid to fix some of those problems, I didn't want to. The only restriction that really bothered me was the two-device limit. I had no use for more space or extra features: in the 5+ years...

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