<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>phup 'n stuff</title>
	
	<link>http://blog.kristopherwilson.com</link>
	<description>Another Blog About Being a Developer</description>
	<lastBuildDate>Fri, 05 Mar 2010 13:28:31 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9.2</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/kristopherwilson" /><feedburner:info uri="kristopherwilson" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>PostgreSQL arrays and PHP’s str_getcsv()</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/PM2FmoXulfw/</link>
		<comments>http://blog.kristopherwilson.com/2010/03/postgresql-arrays-and-phps-str_getcsv/#comments</comments>
		<pubDate>Fri, 05 Mar 2010 13:28:31 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Database]]></category>
		<category><![CDATA[Programming]]></category>
		<category><![CDATA[PHP]]></category>
		<category><![CDATA[PostgreSQL]]></category>

		<guid isPermaLink="false">http://blog.kristopherwilson.com/?p=213</guid>
		<description><![CDATA[Yesterday, while trying to figure out the best way to deal with PostgreSQL arrays in PHP, I came across the new str_getcsv() function in PHP as of 5.3. This function works much the same as fgetcsv to parse a CSV line, except that it works on a string instead of a file. 
For quick reference, [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/03/postgresql-arrays-and-phps-str_getcsv/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/03/postgresql-arrays-and-phps-str_getcsv/</feedburner:origLink></item>
		<item>
		<title>Omitting the Closing tag in PHP Files</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/RtAejbE5A7c/</link>
		<comments>http://blog.kristopherwilson.com/2010/02/omitting-the-closing-tag-in-php-files/#comments</comments>
		<pubDate>Wed, 24 Feb 2010 23:32:56 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Programming]]></category>
		<category><![CDATA[PHP]]></category>
		<category><![CDATA[Zend Framework]]></category>

		<guid isPermaLink="false">http://blog.kristopherwilson.com/?p=210</guid>
		<description><![CDATA[At first when I saw the Zend Framework recommendation of omitting the closing tag in PHP files I thought it bizarre and stupid. Afterall, you close every other syntactic character in programming: parenthesis, brackets, HTML tags, ifs, loops, etc. So why wouldn&#39;t you close the PHP tag at the end of the document as well? [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/02/omitting-the-closing-tag-in-php-files/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/02/omitting-the-closing-tag-in-php-files/</feedburner:origLink></item>
		<item>
		<title>MySQL and the Most Useless Feature Ever</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/GyuqCpATdoE/</link>
		<comments>http://blog.kristopherwilson.com/2010/02/mysql-and-the-most-useless-feature-ever/#comments</comments>
		<pubDate>Wed, 24 Feb 2010 22:41:12 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Database]]></category>
		<category><![CDATA[MySQL]]></category>

		<guid isPermaLink="false">http://blog.kristopherwilson.com/?p=207</guid>
		<description><![CDATA[While building MySQL database support into the OpenAvanti PHP framework, I came across an interesting quirk in MySQL that I thought must be a bug. Apparently, after submitting a bug report and getting a response from MySQL, it&#39;s a documented feature (and later, referred to as a limitation). 
The following create table statements are valid [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/02/mysql-and-the-most-useless-feature-ever/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/02/mysql-and-the-most-useless-feature-ever/</feedburner:origLink></item>
		<item>
		<title>An Epic Struggle With Portage</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/QuXSjZV224U/</link>
		<comments>http://blog.kristopherwilson.com/2010/02/an-epic-struggle-with-portage/#comments</comments>
		<pubDate>Tue, 23 Feb 2010 16:58:34 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Linux]]></category>
		<category><![CDATA[Gentoo]]></category>
		<category><![CDATA[Portage]]></category>

		<guid isPermaLink="false">http://blog.kristopherwilson.com/?p=196</guid>
		<description><![CDATA[Today I embarked on an epic struggle with the Portage package manager attempting to update the packages on my system. After I ran into what can only be described as a phantom package. 
So I did an emerge --pretend --update --deep --newuse world today to see what new packages were available, and got something similar [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/02/an-epic-struggle-with-portage/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/02/an-epic-struggle-with-portage/</feedburner:origLink></item>
		<item>
		<title>array_to_string in PostgreSQL</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/46eX92fDhw0/</link>
		<comments>http://blog.kristopherwilson.com/2010/02/array-to-string-in-postgresql/#comments</comments>
		<pubDate>Wed, 17 Feb 2010 14:06:12 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Database]]></category>
		<category><![CDATA[PostgreSQL]]></category>

		<guid isPermaLink="false">http://www.kristopherwilson.com/?p=169</guid>
		<description><![CDATA[This snippet courtesy of Kieran Smith.
Want to get more work done in a single query? Tired of looping through query results to simply build a list of data. How about this?

SELECT
array_to_string&#40;
    ARRAY&#40;
        SELECT name
        FROM projects
   [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/02/array-to-string-in-postgresql/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/02/array-to-string-in-postgresql/</feedburner:origLink></item>
		<item>
		<title>Gentoo Portage Alternative</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/DXbrfDbf_yI/</link>
		<comments>http://blog.kristopherwilson.com/2010/02/gentoo-portage-alternative/#comments</comments>
		<pubDate>Tue, 02 Feb 2010 13:57:02 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Linux]]></category>
		<category><![CDATA[Gentoo]]></category>

		<guid isPermaLink="false">http://www.kristopherwilson.com/gentoo-portage-alternative</guid>
		<description><![CDATA[I just came across an alternative to the http://gentoo-portage.com and http://packages.gentoo.org sites: http://znurt.org/
Nice, clean, beautiful and full of information. 
]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/02/gentoo-portage-alternative/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/02/gentoo-portage-alternative/</feedburner:origLink></item>
		<item>
		<title>The Sluggish Speed of Gentoo</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/Jgxk_HH2v8g/</link>
		<comments>http://blog.kristopherwilson.com/2010/01/the-sluggish-speed-of-gentoo/#comments</comments>
		<pubDate>Wed, 20 Jan 2010 20:00:37 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Linux]]></category>
		<category><![CDATA[Gentoo]]></category>
		<category><![CDATA[PHP]]></category>

		<guid isPermaLink="false">http://www.kristopherwilson.com/the-sluggish-speed-of-gentoo</guid>
		<description><![CDATA[Gentoo, ffs, get PHP 5.3.1 in Portage ASAP. PHP 5.3 isn&#39;t even in there, yet. What&#39;s the use of your package manager if I just have to manually install stuff?
/rant
]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/01/the-sluggish-speed-of-gentoo/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/01/the-sluggish-speed-of-gentoo/</feedburner:origLink></item>
		<item>
		<title>Automatically Setting Modified Date Database Fields</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/fo42LJcOTOg/</link>
		<comments>http://blog.kristopherwilson.com/2010/01/automatically-setting-modified-date-database-fields/#comments</comments>
		<pubDate>Tue, 19 Jan 2010 18:04:39 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Database]]></category>
		<category><![CDATA[PostgreSQL]]></category>

		<guid isPermaLink="false">http://www.kristopherwilson.com/?p=135</guid>
		<description><![CDATA[Most of my database tables have a <code>last_modified_on</code> column that is populated with the data the a record was last updated. The problem is, we can't set a default of the current date and time on this column, because it would be populated on create. Of course, we could handle this in code, but this is something I like leaving up to the database. 

Here's how I do it.]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/01/automatically-setting-modified-date-database-fields/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/01/automatically-setting-modified-date-database-fields/</feedburner:origLink></item>
		<item>
		<title>User Time Zones in PHP</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/6tdkqfNSgYc/</link>
		<comments>http://blog.kristopherwilson.com/2010/01/user-time-zones-in-php/#comments</comments>
		<pubDate>Sat, 16 Jan 2010 01:43:46 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Programming]]></category>
		<category><![CDATA[PHP]]></category>

		<guid isPermaLink="false">http://www.kristopherwilson.com/?p=115</guid>
		<description><![CDATA[When writing applications that are meant to be used by users the world over (not just users within a localized network), it&#39;s important to be able to show dates and times relative to the users time zone. If one user posts something at 11:30 EST, and a few minutes later, a user in California checks [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/01/user-time-zones-in-php/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/01/user-time-zones-in-php/</feedburner:origLink></item>
		<item>
		<title>PostgreSQL 8.4.2-r1 on Gentoo</title>
		<link>http://feedproxy.google.com/~r/kristopherwilson/~3/beB-B52F4OM/</link>
		<comments>http://blog.kristopherwilson.com/2010/01/postgres-8-4-2-r1-on-gentoo/#comments</comments>
		<pubDate>Sat, 09 Jan 2010 00:53:14 +0000</pubDate>
		<dc:creator>Kristopher</dc:creator>
				<category><![CDATA[Linux]]></category>
		<category><![CDATA[PostgreSQL]]></category>

		<guid isPermaLink="false">http://www.kristopherwilson.com/?p=106</guid>
		<description><![CDATA[A new version of PostgreSQL, 8.4.2-r1, is available in Gentoo Portage, but be careful. It appears the server is compiled with HAVE_INT64_TIMESTAMP by default, something not true with previous versions. Because of this, after updating, you might get an error about the data cluster being incompatibile with the server when you restart, unless you were [...]]]></description>
		<wfw:commentRss>http://blog.kristopherwilson.com/2010/01/postgres-8-4-2-r1-on-gentoo/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://blog.kristopherwilson.com/2010/01/postgres-8-4-2-r1-on-gentoo/</feedburner:origLink></item>
	</channel>
</rss>
