joshtronic


Coding
Life stuff
Fermentation
Shipping fixes everything.

Using SQL’s IN syntax to search multiple fields

1 min read
development
database
mysql

This may not be something new for anyone, but figured I’d post it anyway. I needed to check for a certain date in multiple fields, instead of listing each one out, I used IN but used the value on the left side, and listed the fields in the parenthesis. Before […]

Nonogram Demo in PyGTK

9 min read
development
python
video games
video game development

So a while back I had gotten 3-in-1 Sodoku Garden on my cell phone because I like Sodoku even though I’m not that great at it. I figured, 3 games for the price of 1, wicked cool. Turns out one of the 3 games would later steal my heart. It […]

Oops, father has gone, wait for me, wait…!

1 min read
linux
pidgin

So out of the blue last night, Pidgin (version 2.5.2) crashed on me and when I tried to relaunch it, it would only stay open for a brief moment. I hadn’t done any updates to my system since my last reboot, so I couldn’t imagine it was some new busted […]

All Music Guide (AMG) Tagging Script

9 min read
development
python

So recently I decided that I hated how my music collection was tagged. I try to break apart the genre’s but ideally most of my music falls under multiple genres. Well All Music Guide (AMG, allmusic.com) does a pretty good job of classifying everything. They use broad genres, and then […]

PHP Warning: Module ‘mcrypt’ already loaded

1 min read
development
php

So the other day I realized that my concert spider stopped running. To my surprise I had a lot going wrong on my local machine (which runs the spider). First and foremost, MySQL wasn’t running. Still not sure why, but I manually started it to get it going. It ran […]