#postrgresql

Was that title a mouthful, or what!? Anyways, here is the problem I was trying to solve. I was wanting to write a query against my ActiveRecord model that finds an object where its email was like a search term. Well, here was my problem. Let's say my object's email was "[email protected]". If my search looked like this: 

Then, if my search was "testuser", it isn't going to match anywhere with "[email protected]" because of the upper case 'T' and 'U'. So, what's a boy to do? Well, here is what I did.

I had already done quite a bit of work on my rails project when I figured out that Heroku uses PostgreSQL and not SQLite, which was the default when I created my project. Now, I'm sure I could've gone on my merry way, pushed the project up to Heroku, and ran my migrations. But, I felt better having everything running with the same database in the backend. And since I already had Postgres installed and running, I didn't think it would be too hard. But, I decided to document it anyways, in case someone (myself 3 months from now) needed help.

<![CDATA[// <![CDATA[ // ]]]]><![CDATA[>]]>

The first thing you need to do is update your database.yml file. All you need to do is switch your adapter from sqlite3 (or whatever you are using) to postgresql. And update your database names. The format that seems most common is [app_name]_[environment] (ex. superproject_development).

<![CDATA[// <![CDATA[ // ]]]]><![CDATA[>]]>

Make sure you add a reference to pg in your gemfile.

<![CDATA[// <![CDATA[ // ]]]]><![CDATA[>]]>