Search This Blog

Aaron Hoffman's Blog

Posts

I had a need to determine the State code given a zip code/postal code and could not find a concise list I could use as the base of the map. There is a PDF available on irs.gov, but that doesn't lend itself well to automation.

Project Gutenberg is an amazing site containing over 57,000 free ebooks at the time of this writing.

Recently I've been working on a project to create a database of book bibliographies. A database of book references from within other books. You'd be able to answer the query: Show me all the books that reference "Thinking Fast and Slow". I plan to use Project Gutenberg as the repository that I use to create the first version of this database.

You can manually add these by specifying a Short Name, a Keyword, and the URL to navigate to when that keyword is typed into the browser's address bar.

Until now, I would manually add these URLs one at a time, but being a lazy developer, I wanted a way to automate this process. I discovered that Chrome uses a SQLite database to store these values, and you can side-load new entries by simply performing a SQL Insert into the `keywords` table of that SQLite database!

You can use the following SQL Script to insert the default set of shortcuts I usually add for each new VSTS project/repo: