Text search, sqlite bindings and Python

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

3d wall decor

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