09.22.07 - 11:47pm
acts-as-tsearch is pretty cool, except for the fact that it uses Ruby (app layer) instead of PL/pgSQL (DB layer) to update the tsvectors that are indexed for full text search. That means that fixture data gets inserted without being full text indexed. D’oh!
Here’s some code that changes that.
Category: ruby, ruby on rails, postgresql, sql, Uncategorized | Tags: | Be the First to Comment »
09.22.07 - 05:18pm
Let’s say you’re using Rails with PostgreSQL and the TSearch2 built-in full text search engine.
Did you notice that every time you run rake test, that depends on db:test:prepare, which depends on db:test:clone, which depends on db:test:purge, which drops the database and creates it again?
Along with your dropped database goes the TSearch2 functions that wrap the […]
Category: ruby on rails, postgresql, databases | Tags: | 2 Comments »
08.02.07 - 08:37pm
From what I’ve seen, Rails’ weakest features lie in the way it prepares the test database and test data, and Ruby’s Test::Unit isn’t much better than the awful but ubuiquitous JUnit that Java developers are accustomed to. I set out this week to impose my preferences on Rails in this area, and that took some […]
Category: ruby, java, testing, ruby on rails, postgresql, databases, sql, architecture | Tags: | 5 Comments »
08.02.07 - 08:16pm
For the last few days I’ve been struggling to bend Rails to my will regarding the proper way to assure data consistency. Today I made some progress. This builds upon some research I did a few months ago, and hopefully this is a more or less complete solution to the problem of making Rails work […]
Category: ruby on rails, ruby, postgresql, sql, databases, architecture | Tags: | 23 Comments »
07.27.07 - 08:58pm
Last year I was doing mobile development and there was interesting Linux-as-smartphone-OS stuff going on. Now I’m doing Ruby on Rails development and there’s interesting server grid stuff going on. Here’s what I’m looking forward to finding out more about (all of these are things I’ve been watching or directly researching already):
Category: zfs, gfs, vmware, raid, oracle, nfs, xen, ruby, servers, tools, databases, postgresql, ruby on rails, Linux | Tags: | 1 Comment »