Google Sheets is a great tool to interactively work with an assortment of APIs to work as an intermediary database for experiments or small scale data processing. Here we’re going to look at how we can query our Quickbooks data and display it in a sheet to then merge with any other data set like Read More
Tutorials
Bitcoin Arbitrage Visualization with Google Sheets
If you have access to international bitcoin exchanges, you might be able to take advantage of bitcoin arbitrage opportunities. Google Sheets has a great Scripts features that allows you to program requests to APIs in Javascript and I will show you how to store all of that data in Google Sheets and even receive email Read More
Adding a WordPress Blog to Your Rails App
If you’re running a rails application with a blog like I was, you we’re probably using something that utilized jekyl. There are some good blogging platforms out there and when I decided to add a blog to my site, I decided to use toto. At the time I thought adding all the html tags myself Read More
Using Node.js and OpenCV to Count Colonies on a Petri Dish
If you’re looking for a relatively simple way to automate routine tasks that involve extracting information from images, using computer vision libraries like OpenCV might be a great tool to accomplish your goals. As an example, we’ll take a look at a routine task that most scientists do that isn’t a good use of their Read More
How to Turn Your Product Idea into a Reality
If you have an idea for a product but don’t have any idea how to go about getting it made, this post is for you. Maybe you’re a business owner and you can’t seem to find software that suits your needs. Or maybe you’re an average Joe but you’d like to see if your idea Read More
Notes on Computer Vision by Richard Szeliski
Introduction A little over a year ago I embarked on a project that involved computer vision. Not having much experience in the field, I read as many books as I could find on the subject and the most useful book I discovered was Richard Szeliski’s book: Computer Vision (2010) which is free to download. Below Read More
Restore a Postgres Database from Your VPS to Heroku
If your fledgling app isn’t gaining much traction and you don’t want to pay monthly fees for hosting a vps and you don’t want to see all the hours you pured into your app to disappear, why not move it over to heroku for free? One caviet from using pg_dump that heroku doesn’t tell you Read More
Deploy a Rails App with Heroku
It’s easy as pie to push a demo version of your rails app to heroku. Follow the simple steps below and you’ll be on your way to testing in a subdomain of herokuapp.com. You can also point your dns to heroku and have a live app with a few commands! Make sure that you have Read More
Google Apps Script to Extract Emails
If you have a generic email that is being sent to you regularly and you happen to be a gmail user, you can easily extract that data into a spreadsheet where you can further parse the data into a database if that particular email follows a template. Zapier recently introduced a free email parser but Read More
Shopify API Update Products Based on Conditions
If you already have a private app setup in a rails environment, skip the first step and go into your rails console. If you don’t have a rails environment but you’re running on a mac or linux environment, you may already have ruby installed and all you have to do is install the shopify_api gem Read More