Rails 4 and Postgres

Few useful links to get started with new Postgres features in Rails 4

  1. article Completed

    You got NoSQL in my Postgres! Using Hstore in Rails

    <span>Heroku just announced their&nbsp;</span><a target="_blank" rel="nofollow" href="https://postgres.heroku.com/blog/past/2012/3/14/introducing_keyvalue_data_storage_in_heroku_postgres/">support of hstore</a><span>&nbsp;in their dedicated Postgres 9.1 instances. Hstore is a schema less key value store inside of PostgreSQL that allows us to store data like hashes directly inside of a column. It’s great for when you don’t know exactly what types of attributes you need to store on a model, or if you need to support many different attributes for the same model.</span>

    Edit Remove Move
  2. link Completed

    Concurrent Indexes in PostgreSQL for Rails 4 and Postgres_ext

    <span>PostgreSQL allows you to&nbsp;</span><a target="_blank" rel="nofollow" href="http://www.postgresguide.com/performance/indexes.html#create-index-concurrently">create your indexes concurrently</a><span>&nbsp;so that your table isn't locked as the index builds. This allows you to avoid taking a performance hit when adding a new index to a large table. Yesterday, I submitted a&nbsp;</span><a target="_blank" rel="nofollow" href="https://github.com/rails/rails/pull/9923">pull request to Rails</a><span>&nbsp;that as merged in this morning that allows you to add concurrent indexes through the&nbsp;</span>add_index<span>&nbsp;method in your migrations.&nbsp;</span>

    Edit Remove Move
  3. article Completed

    Rails 4.0 Sneak Peek: PostgreSQL array support

    <span>I'm happy to announce that&nbsp;</span><a target="_blank" rel="nofollow" href="https://github.com/rails/rails/pull/7547" title="Link: https://github.com/rails/rails/pull/7547">Rails 4.0 now has support for PostgreSQL arrays</a><span>. You can create an array column easily at the time of migration by adding&nbsp;</span>:array =&gt; true. Creating an array column will respect the other options you add to the column (length<span>,&nbsp;</span>default<span>, etc).</span>

    Edit Remove Move
  4. article Completed

    A love affair with PostgreSQL [Rails 4 Countdown to 2013]

    <span>Out of all the supported databases available in Active Record, PostgreSQL received the most amount of attention during the development of Rails 4. In today's countdown post, we are going to look at the various additions made to the PostgreSQL database adapter.</span>

    Edit Remove Move
  5. article Completed

    The Most Amazing PostgreSQL Database - IMHO

    <span>PostgreSQL is the most amazing (open source) database around. Even though, there is much interest in stripped down NoSQL databases like key-value stores or “data structure servers”, PostgreSQL continues to innovate at the SQL frontier.</span>

    Edit Remove Move
  6. article Completed

    PostgreSQL: Documentation: 9.1: fuzzystrmatch

    <span>The Soundex system is a method of matching similar-sounding names by converting them to the same code. It was initially used by the United States Census in 1880, 1900, and 1910. Note that Soundex is not very useful for non-English names.</span>

    Edit Remove Move
  7. link Completed

    Learn more skills faster

    Use Helpified to curate any media into learning Paths. Learn by following Paths of others. Teach by curating your own.

    Edit Remove Move
  8. article Completed

    Tagging With ActiveRecord and Postgres - Monkey and Crow

    Postgres doesn't have a secret tagging feature, it does however support arrays as a column type. This creates interesting opportunities for modeling complex data. We will be using arrays to build efficient tagging into a Rails application. We will cover some of Postgres' the basic array operators, and some strategies for using them in ActiveRecord.

    Edit Remove Move
  9. link Completed

    Learn more skills faster

    Use Helpified to curate any media into learning Paths. Learn by following Paths of others. Teach by curating your own.

    Edit Remove Move

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy