<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>databasically // Kansas City Small Business IT &#38;&#38; Ruby on Rails Programming</title>
	<link>http://databasically.com</link>
	<description>Kansas City Small Business IT</description>
	<lastBuildDate>Fri, 03 Feb 2012 05:24:07 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>Using aliases to forward incoming mail on Ubuntu</title>
		<description><![CDATA[I only need to do this every couple years when I renew an SSL certificate and they want to verify domain ownership by sending to some non-standard address like ssladmin@example.com. So, here&#8217;s how: Edit the virtual alias file: (sudo) vi /etc/postfix/virtual Add your alias and the address(es) it forwards to: ssladmin@example.com realemail@example.com contact@example.com sales@gmail.com,support@gmail.com Reload [...]]]></description>
		<link>http://databasically.com/2012/01/25/using-aliases-to-forward-incoming-mail-on-ubuntu/</link>
			</item>
	<item>
		<title>Even better: hiding zero balance clients/projects in Harvest Uninvoiced Report</title>
		<description><![CDATA[I got a few comments on the original post (Hide zero balance clients in Harvest Uninvoiced Report) about not suppressing projects that have a zero balance if the overall client has some billing. For instance, this report with some $0 projects and some $0 clients. The previous bookmarklet would only hide the clients with a [...]]]></description>
		<link>http://databasically.com/2011/12/16/even-better-hiding-zero-balance-clientsprojects-in-harvest-uninvoiced-report/</link>
			</item>
	<item>
		<title>Hide zero balance clients in Harvest Uninvoiced Report</title>
		<description><![CDATA[UPDATE: Check out the updated bookmarklet for more functionality: Even better: hiding zero balance clients/projects in Harvest Uninvoiced Report I love the Harvest Uninvoiced Report. I actually built the same thing for myself using the Harvest API, so I could run it at will and see what client balances were. The Harvest provided one goes [...]]]></description>
		<link>http://databasically.com/2011/09/09/hide-zero-balance-clients-in-harvest-uninvoiced-report/</link>
			</item>
	<item>
		<title>Use vim to remove ^M end of line characters</title>
		<description><![CDATA[Sometimes, when you open a file in vim, the end-of-line (EOL) characters are messed up. You&#8217;ll especially see this if you move a file from Windows to Unix.  You&#8217;ll see a ^M at the end of each line. How do you remove all of these ^M characters from vim? :%s/^M//g The most difficult part of [...]]]></description>
		<link>http://databasically.com/2011/08/31/use-vim-to-remove-control-m-end-of-line-characters/</link>
			</item>
	<item>
		<title>Using SQL to delete rows from a table using INNER JOIN to another table</title>
		<description><![CDATA[Oftentimes, one wants to delete some records from a table based on criteria in another table. How do you delete from one of those tables without removing the records in both table? DELETE DeletingFromTable FROM DeletingFromTable INNER JOIN CriteriaTable ON DeletingFromTable.field_id = CriteriaTable.id WHERE CriteriaTable.criteria = "value"; The key is that you specify the name [...]]]></description>
		<link>http://databasically.com/2011/08/31/using-sql-to-delete-rows-from-a-table-using-inner-join/</link>
			</item>
	<item>
		<title>Configuration for mailjet email delivery with Ruby on Rails</title>
		<description><![CDATA[Setting up mailjet.com to deliver your mail via Ruby on Rails? Here&#8217;s how, because their Getting Started is nothing but placeholder headers right now. Create an account Go to https://www.mailjet.com and create an account. Note: the word &#8220;Faculatative&#8221; means &#8220;optional&#8221; on the signup form. Add your sending address Add a sending address (Accounts > Sender [...]]]></description>
		<link>http://databasically.com/2011/06/07/configuration-for-mailjet-email-delivery-with-ruby-on-rails/</link>
			</item>
	<item>
		<title>Remove all those .DS_Store files</title>
		<description><![CDATA[I don&#8217;t like committing .DS_Store files into my projects, so here&#8217;s an easy way to remove them: Run this from your project folder: # Recursively erase all .DS_Store files in this folder and below find . -name \.DS_Store -exec rm -v {} \; Also, you can prevent the DS_Store files from being created. Run this [...]]]></description>
		<link>http://databasically.com/2011/06/06/remove-all-those-ds_store-files/</link>
			</item>
	<item>
		<title>git: merge a single commit</title>
		<description><![CDATA[Sometimes, you have one commit you want to get into production, but it&#8217;s located after other changes that you&#8217;re not ready to merge in yet. How can you get that single git commit into a different branch? First, you have to know the SHA of the commit you want: git checkout branch-with-commit-on-it git log Highlight [...]]]></description>
		<link>http://databasically.com/2011/06/03/git-merge-a-single-commit/</link>
			</item>
	<item>
		<title>Mac OS X: find the program running on a port</title>
		<description><![CDATA[Sometimes, there&#8217;s a program running on a port and you don&#8217;t know what it is. How do you find out? I find this happens when I start a webserver up to test something locally and then I forget about it. So, if I wanted to find out what was running on port 80: sudo lsof [...]]]></description>
		<link>http://databasically.com/2011/06/02/mac-os-x-find-the-program-running-on-a-port/</link>
			</item>
	<item>
		<title>Converting mysql databases to UTF8</title>
		<description><![CDATA[UTF8 is the way to go when you&#8217;re creating a new database for an application, but how do you get your existing applications upgraded? We dump the database and then import it with the new character set so we can test things out: # Export your latin1 encoded database mysqldump --user=username --password=password --default-character-set=latin1 --compatible=mysql40 dbname [...]]]></description>
		<link>http://databasically.com/2011/06/01/converting-mysql-databases-to-utf8/</link>
			</item>
</channel>
</rss>

