tadhg.com
tadhg.com
 

Posts concerning SQL

WP Plugins: Recent Commentary and Show Tags in RSS

19:38 23 Mar 2009

I finally got around to writing up docs for, and then packaging, the two WordPress plugins I’ve finished recently:

I’m currently looking at support for series in WordPress, and am considering either writing my own plugin or using/forking the Organize Series plugin.

Permalink     Comment     [, , , , , ]    

New Blog Functionality: Recent Commentary

21:39 23 Feb 2009

I’ve had a Recent Comments section on the front-page sidebar of the site for quite some time, and decided it was time for an upgrade. The old version was straightforward: it displayed a list of the most recent comments and who made them. What I decided I wanted was, rather, a list of the posts with the most recent comments on them, how many comments there were, and a list of the people who made the comments in timestamp order.
[more...]

Permalink     Comment     [, , , , , ]    

Related Posts Plugin and SQL Trickery

11:55 10 Feb 2009
Permalink     4 Comments     [, , , , ]    

sfmagic.org Rewrite: Head-to-Head Some Working SQLAlchemy

23:56 13 Jan 2008. Updated: 01:52 14 Jan 2008

I haven’t had much time to work on the project over the weekend, but I have made some progress in getting the queries into SQLAlchemy form.
[more...]

Permalink     Comment     [, , , ]    

sfmagic.org Rewrite: Head-to-Head Working SQL Queries

23:52 11 Jan 2008. Updated: 02:35 12 Jan 2008

I’ve stripped some fields from the h2hresults table, and I’ve created some queries that do what I want but may not be the right approach.
[more...]

Permalink     Comment     [, , , ]