So quite a while ago I wrote about avoiding the n+1 query problem with SQLObject. I've since been using Django a lot more. In particular at my day job I've been improving a Django site we've inherited. This particular site suffered from a few too many SQL queries and …
Articles tagged with SQL
An iPhone friendly, local storage backed, offline TODO list webapp
A while back I had a go at using the local storage features being added to javascript to create a simple TODO list app. The main focus of the app was getting it all to fit under 5K (5120 bytes), but it was a good test of using a client-side …
Client-side sql databases in Javascript
It occurred to me that I didn't really go into much detail about the local storage part of my 5K TODO app. It's quite a neat piece of tech and because it works in Safari it also works on the iPhone. That obviously means you can use javascript+local storage …
Using raw SQL with SQLObject and keeping the object-y goodness
This is sort of a continuation of my little SQLObject performance guide. So it might be worth reading that too, if you are after hints about speeding up SQLObject. Anyway, on with the show...
It's possible to create raw (database agnostic) sql queries with SQLObject. This can be really handy …
A little SQLObject performance guide
For those that aren't aware, SQLObject is an Object-Relational Mapping (ORM) library for Python. I use it in chrss (my chess by rss web app) as part of Turbogears. Ian and Kyran also use it as part of the ShowMeDo site.
Chrss and ShowMeDo have quite different levels of traffic …
chrss update 6
So I've now uploaded the results of the saturday morning code-a-thon. This means that you can now browse all of the previous moves and they also have a convenient URL. So if you want to show someone a move that you thought was particularly good/bad you can just send …