c.execute(“SELECT * FROM entries WHERE (title LIKE ? OR body LIKE ?) order by date desc”, (“%%%s%%” %text, “%%%s%%” %text)) Notes Putting %?% does not work “%?%” does not work Double percent sign (%%) due to python string substitution rules
Perhaps my long search for a convenient way to code database frontends that work locally (“desktop app”) but leverage the power of a browser as a GUI has come to a successful point. This point involves: Python (Naturally) Bottle – a “microframework” py2app – py2exe for windows The only tricks making Bottle and py2app work… Read More Standalone browser based app
From the HTML standards. Use POST when the operation has lasting changes on the world, like a database modification.
svnadmin create /path/to/repository Point subclipse to that repo and make a new folder
So, there are artists who paint patterns on walls that turn into a recognizable figure if you are standing at the right perspective (e.g. here). One easy way to generate these patterns is to set up a projector with a slide of the pattern that you want projecting from the vantage point you want, and… Read More 3d wall decor
The D40 is an awesome camera, especially at the price I bought it ($375 with kit lens – but refurbished). It’s years out of production now and has been superseded, but it does fine for my casual needs. The only two gripes I have about it, in order of importance are: Auto white balance is… Read More Nikon D40 (almost) 2 years on
This lens is very, very good. I had read on boards from people who would never take this lens off the camera. I find that most of my shooting is done with this lens. The kit lens that came with the D40 (The Nikon 18-55 mm) is very good, but the 35mm’s 1.8 aperture is… Read More Nikon 35mm f/1.8 AF-S One year on