Tag Archives: tips

MySQL wrapper script: variables from the command line

There’s a lot I like about PostgreSQL, and I’ll probably switch eventually, but for now, I’m still more comfortable with MySQL, especially its ability to update huge amounts of existing data in-place very quickly. I do have some technical gripes … Continue reading

Posted in General | Tagged , , , | 10 Comments

SQL and simple polymorphism

SQL is about tables and sets. Object-oriented programing is about types, subtypes, and polymorphism. There are nasty, nasty frameworks available to try to move between the two worlds (say, by serializing and deserializing Java objects) — this posting, however, is … Continue reading

Posted in General | Tagged , , | 8 Comments

Customer Problem Checklist

Whether you’re writing a business plan for your personal startup (the tech equivalent of the Great American Novel that every hack journalist plans to write), a report for your customers, or a proposal for your managers, sooner or later you’re … Continue reading

Posted in Uncategorized | Tagged , | 3 Comments

Ready for Prime Time?

I bought a cheap HP C4280 printer-scanner-copier today, since my old HP 1210 finally gave up the ghost. Installing the printer in Windows Vista Installing the printer in Windows Vista wasn’t too difficult. I followed the instruction not to plug … Continue reading

| Tagged | 1 Comment

Strange web exploit attempt (?)

In the search logs for OurAirports, I noticed a series of searches for URLs: http://www.feliciano.de/Webgalerie/bilder/Italy/une/yiwul/ http://www.unduetretoccaate.it/codice/aseje/wocobo/ http://www.altaiseer-eg.com/ar/articles/jed/umut/ At first, I thought they might be a kind of link spam — some sites display recent searches — but when I checked … Continue reading

Posted in Uncategorized | Tagged , , , | 4 Comments

LAMP stack stability

I’m using a single dedicated server to host ourairports.com, megginson.com, and a couple of minor domains. OurAirports is a database-heavy application using (currently) a MySQL v.5 database hosted on the same server. I’ll offload the database to a separate server … Continue reading

Posted in Uncategorized | Tagged , , ,

Two problems with Google Maps for aviation

I love Google Maps and their API, and am using it extensively in my new web site OurAirports. However, there are two problems that keep coming up for using Google Maps with an aviation application: Google Maps uses a Mercator … Continue reading

Posted in Uncategorized | Tagged , | 4 Comments