similar to: Postgres and Tsearch2, how do you do it?

I''m sure people have encountered this before, but I''ve been unsuccessful at finding anything about it. Basically, I got a rails app that uses postgres and tsearch2 for some full text indexing and I''d like to be performing unit tests. Now, there''s the whole deal of how to get the test database to load all the tsearch2 information properly. I tried to come up

I have a search form; I grab the value and use it in a fulltext query: :conditions => ["idxfti @@ ''" + search_string + "''::tsquery and ...........] Characters in search_string like "?", ":", bomb active record. I tried a single tick and "\" to escape those, but active record still bombs (same queries via psql work). Suggestions?

Hello, I am planning to build a bigger Internet platform and actually evaluating Java EE and Rails. I have a lot of Java experience and I am quite new to Rails. After playing some weeks with Rails I am sure that it is a mature web framework and I really like the productivtity of Rails. One of the key advantages is that new developers will understand this platform much quicker than all the Java

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do

I''ve been searching for a way to implement a search feature across articles posted in a table. All the google results I get refer to "live" search and I''m not interested an automcomplete function, but because of the prevalence of tutorials on the subject, I can''t seem to find what I want. I have implemented a search in PHP before where I had MySQL perform an

hello, I''m currently looking for a html/css/ajax/rails programmer. if your interested please email neumanc@gmail.com. I have paying work, will pay via check, money order, paypal or credit card. I''m not sure if I can post this here or not. if not, please remove and email me a warning as I did not see any rules on signup. Thanks -- Posted via http://www.ruby-forum.com/.

Hi @ all Does anyone has some experience with PostgreSQL and RoR? Does it gives any disadvantages or problems with PostgreSQL? I have a webapplication, that manage (read/write) many records (no. 200''000 records) and I search a ideal database. Actually, I have two options: - MySQL / - PostgreSQL And now, I would like to ascertain a good solution... Thx, ribit -- Posted via

I am trying to set up a search page that looks within a product catalog. There are several many to many relationships with the items object. I am trying to be able to narrow searchs and then allow for text searches using tsearch2 and postgres. @format = Format.find(@params[:format_id]) @items = @format.items And then do a find_by_sql on the @items, but I know this isnt how you do this.

This is the webpage: http://projects.exactlyoneturtle.com/date_picker/ I have downloaded and installed it. But how do I use in view page? This is the usual view with ordinary datetime_select: <p><label for="product_date_available">Date available</label><br/> <%= datetime_select ''product'', ''date_available'' %></p>

HEllo, I have the following problem with rails, I am new in this...is there anyone who explain to me what´s happens? Thanks See below: NoMethodError in Classified#show Showing app/views/classified/show.rhtml where line #17 raised: undefined method `updated_at'' for #<Classified:0x686c5e4> Extracted source (around line #17): 14: 15: <strong>Date Posted:</strong>

Or does anybody prefer fastcgi/fcgi? I''m using webrick for development, but plan on using scgi when I switch to production (because it appears to be an update to fastcgi, and I couldn''t get fastcgi working anyhow). thanks csn __________________________________ Yahoo! Mail - PC Magazine Editors'' Choice 2005 http://mail.yahoo.com

My app has a header & footer I want common to each section. They live in app/views/shared/_header.rhtml & _footer.rhtml. They are referenced by app/views/layouts/application.rhtml as one would expect: <div id="header"> <%= render :partial => ''shared/header'' %> </div> They contain many lines like this: <a

Perhaps stupid question but, is Asterisk a statefull or stateless proxy? Ignace

Hey all, I haven''t heard much on the list in a while re: ActiveSearch, Ferret, Hyper Estraier, etc. in a while. Has anyone successfully used ActiveSearch on tables with rows in the order of hundreds of thousands, if not millions? (in our case, each row containing anywhere from a paragraph of text to many pages) Here''s some background on our search efforts. A. Hyper

I''m on MAC OSX and I set up my environment as described here: http://hivelogic.com/narrative/articles/ruby_rails_lighttpd_mysql_tiger?status=301 This may be too old and I just realized that, but before I attempt Building Ruby, Rails, Subversion, Mongrel, and MySQL on Mac OS X: http://hivelogic.com/narrative/articles/ruby-rails-mongrel-mysql-osx Okay, I purchased a book "Rails

Hi, I have activated scaffold in my first rails application ( following http://manuals.rubyonrails.com/read/chapter/38 ) and now I get the next error ''Packets out of order'' error was received from the database. Please update your mysql bindings (gem update mysql) and read http://dev.mysql.com/doc/mysql/en/password-hashing.html for more information. if I run the "gem

Here''s an alternative in-depth treatment on setting upo rails on Debian (Ubuntu, Kubuntu, ... ), may be interesting to follow through in more detail for some: The Perfect Rails/debian/lighttpd Stack... ( http://brainspl.at/pages/perfect_vps ) Victor Kane http://awebfactory.com.ar On 3/25/06, rails-request@lists.rubyonrails.org < rails-request@lists.rubyonrails.org> wrote: >

Hi samba lists, we have a samba-ldap domain running on a debian squeeze (samba 3.5.6)server (pdc and bdc). I try to configure a domain member server on an other debian squeeze that will serve as cifs and nfs server. My Debian server member use winbind (on ldap) for mapping the users windows sid to the unix uid. The users mapping is write in the the ldap directory : ou=idmap,dc=exemple,dc=com

Hey, everyone. Wanted to post this announcement to the list. This is for a series of workshops that myself and my business partner are putting on. For those that live in the Northern New England area, looking to get some good hands-on instruction into Rails, this might be for you. Oh.. and don''t be too freaked out by my picture on the front page. I''ve got a fairly

Hi, Can''t get the rails demo to run. I''ve started the webrick server. Here is what the output looks like: ----- [root@chat demo]# ruby script/server => Booting WEBrick => Rails 2.3.3 application starting on http://0.0.0.0:3000 => Call with -d to detach => Ctrl-C to shutdown server [2009-08-18 21:29:41] INFO WEBrick 1.3.1 [2009-08-18 21:29:41] INFO ruby 1.8.5