I haven’t tried editcss yet, I have to restart my browser to finish the installation! Looks dead handy for editing css easily!
Category Archives: Development
MySQL: Finding the records in one table that are not in another table
OK, this’ll make users of “proper databases” cringe but because MySQL doesn’t support sub-selects you can’t do the most obvious way of selecting records in one table that aren’t in another. Here’s how it’s done, with a clear explanation of why it works!
select po.id
from po left join pn
on po.id=pn.id
where pn.id is null
Unfortunately, I can’t figure out how to filter the second table as I don’t want to select from the whole table, only a subset. Anyone solved this?
The Joy of Usability
The comic going along with this article really caught my attention – how many times have you taken apart an old joystick to add the auto-fire switch from another joystick, or to repair the plastic struts that broke while you were playing Combat School! 🙂
Must read OK/Cancel: The Joy of Usability too of course!
UI is Humble
Rand looks at NewsFire and is amazed.
That’s right. It is simple. In fact, your first impression is that you could fire up Interface Builder and slap this together in a ten short minutes. You’re really quite wrong. Keep using the product. Add some feeds… read some articles… and you’ll start to appreciate the work that has gone into this application.
Vim Regular Expressions
Nice Vim article on regex in the editor. Must have a look later!
Searching with PHP and MySQL
Great article on searching MySQL using PHP! I didn’t know about RLIKE at all! How’d I miss that? (via The Real Adam)
CVS Insanity, or what?
ah ha! This is handy! How to use CVS without going insane is a list of must-have commands for creating, maintaining and using a CVS repository, or maybe I should use something else?
Software That Lasts 200 Years
This essay has been linked to death but I just got around to reading it. Printing it out for consumption later!
C64 Python!
Ooh! Cool! Python on the C64! including a screenshot of the interpreter working. Must download and play with this! hehe.
S60 Python – on your mobile!
It looks like Python may be making it’s way to a Series 60 mobile phone soon! I may actually learn how to code in Python if this becomes available!
On that note, I may buy a new phone. The keyboard on my 7650 is getting cranky, some keys need to be pressed hard, others print characters twice. I could take the phone apart and clean the keyboard but now the plastic cover on the thumbstick/joystick thingy is coming apart. If I buy another phone, I’d like another Symbian device – Triz really is a great Tetris clone that I’d miss. Now, if I could only get a version of Go! for the phone I’d be happy and content.