I previously offered up an SQL puzzle as food for thought. In this post, I want to discuss a couple of solutions.

(Read more...)

Topics: software/databases, software/django

[#]

A quick little SQL problem that I came across again recently. Read no further if you don't like databases.

This problem is probably well-known to many people and easy for people with lots of SQL experience. But it is the prelude to a post I will write in a couple of days about writing custom SQL in Django and is based on a real-world problem that came up on the Django mailing lists a month or so ago. It's kind of fun to think about, too, if you have not done so before, too.

Aside

A dilemma I am going to have fairly frequently here is how to juggle presenting some of the more technical things I want to discuss with keeping it interesting for a general audience. At least for now, I think I will have every entry appear on the front page, but any really specialised article will have the bulk of the content on another page. Hopefully this will mean that reading the front-page will still be of some interest even to people who don't have my precise set of interests.

(Read more...)

Topics: software/databases, software/django

[#]