First, credit due where credit is due. This project is inspired by the “Tiny Robot Family” by shlonkin. This is a fairly simple, low cost (~$10/unit) project that can be done in a weekend.
I wrote an online password exchange app. It improves security when sending passwords via email/IM. The way the app works is that you send a link that allows the user to view the password. That link will then expire within a set time frame. The user can also delete the entry from the database after viewing.
The app is open source and freely available on GitHub. You should be able to get your own instance running within a few minutes.
I’m aware that there are more secure ways for sending passwords (i.e. PGP). From my experience these are usually not feasible when working with non-technical folks. This app is an attempt to improve security at least a bit by not having passwords in your chat history or emails.
You are welcome to use my instance at your own risk but it would be better to set up your own instance and not trust some random guy on the internet.
The app is written in PHP using the Silex framework and Doctrine DBAL. I’m happy to accept pull requests if anyone has some improvements.
After doing a video of an endurance hiking competition, where I did a lot of handheld footage walking with the hikers, I realized that I need some kind of camera stabilizer. The commercial units are unfortunately out of my hobby-filmmaker budget. I looked around for DIY solutions and came across this DIY build:
A while ago I came across a picture of a headphone amplifier in an Altoids tin. Even though I don’t have headphones that necessarily require an amp (Audio-Technica ATH-M50) I decided to go ahead with the build. It’s an easy enough project to build in a weekend. I followed this excellent tutorial with a few modifications. I built the single 9V battery version. I ordered all my components except the pot from DigiKey. I ordered the pot from Mouser. I still had a bunch of perfboards lying around from previous projects and used one of them. The total cost for the parts came to around $30. Unfortunately DigiKey doesn’t show you the shipping cost on checkout and to my surprise they charged me $30 for regular UPS ground shipping. I contacted their support and apparently there is a shipping cost calculator link somewhere during the checkout process. Seriously DigiKey, it’s 2015, update your website.
Continue reading “CMoy Headphone Amp”
Magento is a complex beast and tracking down the source of a database query can be a huge pain. Recently I had to track down the source of a set of queries. I could see the queries in the SQL query logs but wasn’t able to figure out which particular piece of code would execute them because the functionality that triggered these was used all over the place.
I ended up adding the PHP stack trace that executed a SQL query to each query as a comment before the query. That way the full stack trace would show up in the MySQL query logs.
Continue reading “Tracking Magento Database Queries”