PWX – online password exchange service

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.

Check out the project on GitHub.
You can test the service here.

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.

PWX – online password exchange service

CMoy Headphone Amp

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”

CMoy Headphone Amp

Tracking Magento Database Queries

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”

Tracking Magento Database Queries