PostgreSQL array type support makes it easy to have an array of tags on a Rails model.
1 2 3 create_table :posts do |t| t.string :tags, array: true, default:  end
Now that you're storing some tags on your
(hand-waving...), you might want to grab an array of
unique tags entered on posts.
You might start down the path of selecting the post tags, then collecting them, something we see often in Rails code.
You have an array of the tags, but that's kinda ugly. There's
a lot of Ruby manipulation going on after the tags are retrieved.
can help with this, by giving us just the attributes we're looking for.
Same result as before, but much nicer. We still have that pesky
flatten.uniq hanging off the end, though. PostgreSQL has
an array function called
unnest that will give us the same
result as our Ruby
flatten method and
distinct will ensure
There we go, offload some of those operations onto the database. This should be much more efficient than Ruby, so we ran some simple benchmarks against 10000 posts, with 20382 tags (183 unique).
1 2 3 4 user system total real old: 0.240000 0.000000 0.240000 ( 0.245174) new: 0.000000 0.000000 0.000000 ( 0.010110)
Looks much better!
Need help with your project?