You may have noticed I have added a search bar at the top of the website. Here is how to make use of PostgreSQL's full text search facility with SQLAlchemy, a Python SQL Toolkit and Object Relational Mapper. To set up searching on one of your tables, add this to the model where your table classes are defined. Alternatively … Continue reading PostgreSQL full text search and SQLAlchemy
Month: August 2009
Script to put your music in a database
I made this script a while back now to populate a database with all the music on my computer (so excuse any poor Python!). It assumes you are on Windows and have all your music in one folder, arranged by artist with sub folder albums with songs in them. It also assumes you'll use PostgreSQL, … Continue reading Script to put your music in a database
Edinburgh Fringe: The School for Scandal
The School for Scandal is an 18th century restoration comedy by Sheridan with an all star cast including Lionel Blair, Marcus Brigstocke and Stephen K Amos amongst others. I thought for a moment Leigh Francis (the guy who did Avid Merrion in Bo Selecta) was in it, but it was a guy named Richard Thomson, who was really … Continue reading Edinburgh Fringe: The School for Scandal
Edinburgh Fringe: Ian Kendall’s 18th Birthday Magic Show
Yesterday I went to another fringe act, this time a magic show. Ian Kendall has been doing the Fringe for 18 years now, so his show was aptly titled Ian Kendall's 18th Birthday Magic Show. During the hour he performed many magic tricks and told us a bit about his life as a magician. It was … Continue reading Edinburgh Fringe: Ian Kendall’s 18th Birthday Magic Show
Edinburgh Fringe: Complete works of Shakespeare (abridged)
Today I went to see The Complete Works of William Shakespeare (Abridged) at The Caves on Cowgate. I vaguely remember seeing this before in London and really enjoyed it. However during the show I only remembered the ending, which puzzled me as usually memories of plays I've seen before come back quite quickly. After having a look on the … Continue reading Edinburgh Fringe: Complete works of Shakespeare (abridged)
Moroccan Tagine
After watching the celebrity Masterchef final where they went to Morocco, I decided to try out making their national dish, a Tagine. This recipe is a mixture from a few different sources and tastes divine. Takes about 20 minutes to prepare and an hour to cook. Ingredients (for 4 people) Sprinkling of cayenne pepper (adjust … Continue reading Moroccan Tagine
Edinburgh Fringe: Free comedy
Last night I went to the first of 9 bookings I have made for this years Edinburgh Fringe Festival: The Laughing Horse Free Comedy Selection. Admittedly, I would not have gone to this one was it not for my friends boyfriend being one of the comedians performing. Nevertheless, this was a great way to kick of … Continue reading Edinburgh Fringe: Free comedy
Polaroid images
I've been experimenting with images and CSS on how to make an image look like it's been taken with a polaroid. I still own a polaroid, and have about 2 photos left. Pity they don't make them any more 😦 Polaroids are roughly square, I have made mine 307px by 319px. I created a background … Continue reading Polaroid images
8 Favourite iPod Touch apps
1. BBC Reader (free)This app downloads and caches the latest headlines from the BBC website from three categories (I have world news, UK and Entertainment for example). What's great for iPod Touch users is that you can download the news when you have internet and read the articles later when you don't. When you click on … Continue reading 8 Favourite iPod Touch apps
What do rabbits see?
Often the rabbits get startled when I enter the kitchen and only when I greet them do they know who I am. This is because rabbits have quite bad vision, and usually tell what things are by their smell, noise and shape. They have a very narrow area where they can focus on and judge … Continue reading What do rabbits see?
Lowmanio 