Drupal + PostgreSQL: review some patches, folks!

baseball bat
am i the girl, the bat or the heart? you decide!

I’ve been working on a site that uses Drupal for a few months now. And I’m living dangerously with CCK, Views and, as of last week, Organic Groups.

I found this sharp moderation module (Modr8) last week, and then quickly realized that I wanted to be able to provide this moderation tool any conferences that wanted it! Enter the Organic Groups.

I’m using PostgreSQL for the back-end database, and so I’m used to being a second-class database citizen in Druplandia. This means that I frequently have to patch modules so that they use SEQUENCE instead of AUTO_INCREMENT, or get rid of the (8) after an INT type. So, when Organic Groups and the og_modr8 modules caused this bug to rear up, and I suddenly had a full-scale “blogs running backwards” problem on my hands, I wasn’t surprised.

Thank goodness for Brenda Wallace’s patch, which fixed everything up a short while later. What got me, however, was that the problem has had a fix (although not Brenda’s ultimate patch) for over a year, but it hasn’t been added to core. Particularly when the problem causes nodes to be presented out of order, site-wide.

Apparently there’s a shortage of PostgreSQL reviewers in the Drupal community.

Fortunately, if you’d like to help get patches applied to core, there’s a page of Patches To Be Reviewed, and a few people are trying to add a postgresql tag to bugs. If you’re a Drupaler and use PostgreSQL, please take a few minutes to review a patch.

twittering on 2008-06-13

  • Done #drunkgeeking. Headed home #
  • @mhalligan i owe a lot to unions. my family wouldn’t have owned a home, my brother wouldn’t be able to support his family, etc. #
  • @mhalligan unions are a defense against exploitation of the working class – people who pick and slaughter our food, and dig our trenches. #
  • @mhalligan they aren’t perfect, but neither is capitalism or management. #
  • @mhalligan i guarantee you that without a union, my father would not have made a mortgage-paying wage digging trenches and laying pipe. #
  • @mhalligan he also would not have had a retirement plan and pension that followed him through 30 years of hard, physical labor in 10 states #
  • @mhalligan i mean, lets give the same level of scruitiny to capitalism and the excesses of *that* as you’re applying to unions. #
  • @mhalligan poverty? homelessness? business-caused environmental disasters that supposedly our gov’t cleans up? inflation? #
  • @mhalligan i don’t mean to pick on you – lots of people say this type of thing about unions. i just want to point out that real people… #
  • @mhalligan benefit in life-changing, but on a $$ scale – very small ways – compared to the insanity of management compensation. #
  • @xolotl probably would not have turned out *exactly* like this :) #
  • @mhalligan it’s a two way street. unions can be bad, but management practices contribute. #
  • @mhalligan :) and i just think that the “cost to others” is far less than the total cost of capitalism on society.. #
  • @mhalligan i don’t know about unions creating world peace, solving israeli/pal. cnfct – just describing some costs of business. :) #
  • @roberte3 good stewards exist! just not rewarded by society in the ways that most people are trained to want/expect. so not as common. #
  • i have to go to bed, or i would now explain why i think ‘opting-out’ is BS :D but thx for listening @mhalligan. #
  • oh, and R ROCKS! http://www.r-project.org/ #
  • signing up for boxing class. #
  • cranking out some work before the downtime. #
  • @ryanwi have you tried skitch? #
  • @garethgreenaway i lost 5 followers yesterday after my union tirade :D #
  • @garethgreenaway is was a *pro* union tirade :) #

twittering on 2008-06-12

  • live plurking pdx perlmongers http://www.plurk.com/p/btze #
  • @petdance @theory – your mission, according to chromatic, is to get allison drunk so that she’ll agree to have a mechanical bull at OSCON. #
  • @notbenh — well, they can also be the actual RESULT of a query. i’m interested in how those stacked queries get optimized — or not. #
  • meeting is adjourning to the bar! #
  • @fuzzychef hah! well, more than 1/2 the meeting happens at the pub. sometimes the pub meeting is twice as long, even. #
  • @Theory: pdxpm thinks that we know what your password is: fuck #
  • watching tons of derren brown this morning #
  • @verso i like blackalicious, don’t like judith owen – although, probably in college, would have listened to her along w/ tori amos. thanks! #
  • @verso and thanks for putting me on a jay-z jag this morning! #
  • @verso oh of course! LOVAGE! #
  • @spinnerin that album rules. i hope lucas knows how LUCKY he is! #
  • @verso your memory is way better than mine. i just have strong feelings of fondness, and a desire to go dig that record out of the basement #
  • not gonna make it to ignite planning today :( #

twittering on 2008-06-12

  • live plurking pdx perlmongers http://www.plurk.com/p/btze #
  • @petdance @theory – your mission, according to chromatic, is to get allison drunk so that she’ll agree to have a mechanical bull at OSCON. #
  • @notbenh — well, they can also be the actual RESULT of a query. i’m interested in how those stacked queries get optimized — or not. #
  • meeting is adjourning to the bar! #
  • @fuzzychef hah! well, more than 1/2 the meeting happens at the pub. sometimes the pub meeting is twice as long, even. #
  • @Theory: pdxpm thinks that we know what your password is: fuck #
  • watching tons of derren brown this morning #
  • @verso i like blackalicious, don’t like judith owen – although, probably in college, would have listened to her along w/ tori amos. thanks! #
  • @verso and thanks for putting me on a jay-z jag this morning! #
  • @verso oh of course! LOVAGE! #
  • @spinnerin that album rules. i hope lucas knows how LUCKY he is! #
  • @verso your memory is way better than mine. i just have strong feelings of fondness, and a desire to go dig that record out of the basement #
  • not gonna make it to ignite planning today :( #

twittering on 2008-06-11

  • sad i’m not gonna make it to PHP or python meeting tonight. too tired, heading home to be with my sweetie. #
  • @pullingshots yay! u can also make schema changes and rollback (with the associated performance penalties!) http://is.gd/uLY #
  • @gorthx just got the iTalk! need to test. #
  • Retweeting @brianaker: Best comments on a boing boing story forever: http://tinyurl.com/6mmtx5 (jump the shark boing boing!) #
  • @gorthx please do! #
  • going climbing at the gym tonight thanks to @gorthx! #
  • @kveton higgins? #
  • those looking at expression engine – security comparison with drupal (drupal bias :)http://tinyurl.com/5z6tph #
  • @verso MIA, kanye west, aimee mann, one self, kronos quartet #
  • @turnstep try is.gd #
  • @debbryant horray! #

twittering on 2008-06-10

  • recommending @sockington to @eggyknap based on @ctb’s glowing review. #
  • Retweeting @br3nda: new post: Wellington postgresql users’ group meeting is tomorrow http://tinyurl.com/6pr75e #
  • @petdance money and an isolated, padded room. #
  • example of how i’m going to liveblog perlmongers on wednesday: http://www.plurk.com/p/9wgs #
  • cool web-based SQL designer demo: http://tinyurl.com/4t85qs #
  • headed out for a late lunch. much DBIx::Class goodness today! #

twittering on 2008-06-09

  • @Theory i kind of like the shoes? #
  • ok tweeps: what #postgresql question would you like answered in a podcast? #
  • @xolotl thanks! (probably can spin that off into 100+ part series, but will do my best in 30-45 seconds) #
  • @Theory thanks!! #
  • @theory but it isn’t until june 19th! #
  • @theory awwww! we’ll miss you. it’s going to be a cocktail party. btw. just to rub it in. #
  • putting the chickens to bed. #
  • @pixelmatrix glad to hear you’re liking it. it just gets better! #
  • @betsywhim no cronjobs for teenagers :/ #
  • for all you “no pants day” people from barcamp: http://coffee.geek.nz/see_new_side_sig #
  • @ryansnyder yr welcome! i’ve used fugu b4 too. came back to transmit. #
  • @niczak huzzah! #
  • happy bday, @ravenzachary! #
  • @ryansnyder – Retweeting @thesethings: @selenamarie filezilla is an opensource ftp/sftp client for Mac/Windows/Linux…. #
  • @WomenWhoTech have you seen geekspeakr.com? #

twittering on 2008-06-08

  • @oregoniansteve first meeting of chickentenders happy hour was successful – gave chicken status updates, imparted wisdom, will meet again! #
  • happy b-day @AaronThul! #
  • answering @niczak’s coffee question on plurk http://www.plurk.com/p/855g #
  • @ryansnyder huh – i use transmit, but have been told that cyberduck is a fav! lemme know what you end up with. #
  • @niczak thx! was totally fun. that threaded stuff is something i love – a feature i wish twitter had figured out a long time ago: http: … #
  • oops – here’s that coffee thread on plurk: http://www.plurk.com/p/85ds #
  • @downthedrains totally legit question – why are are so many things that are considered ‘the norm’ really the worst choice? #
  • sun’s out! #pdxst #
  • making an omelet for breakfast. #