search for: tsearch2

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 with an elegant way to do it without overwriting any rails code or duplicating SQL o...

Hi, How do you use Tsearch2 in Rails? Petr -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3Mb...

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

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?

...#39;'re planning on giving ActiveSearch a run for its money. Although, if a bunch of ya''ll chime and and say "Nooooooooo!" we might change courses once again =) FWIW, we''re using PostgreSQL as the database. We''ve also considered using Postgres'' tsearch2 full-text search feature. The setup for that seems a bit more complicated, but perhaps it''s worth it. Anyone have a favorite tsearch2 story to share? Thanks! - Shanti http://sproutit.com/ - team-based support/sales email management http://sablog.com/ - personal blog -- P...

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 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. @items.find_by_sql("SELECT * FROM items WHERE idxfti @@ to_tsquery(''default'', ''#{@str}'') class F...

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

...with innodb would there be a workaround for > > effective text searching? > > You need to do some fun stuff to make that work. > > If you aren''t forced to stay on MySQL, you might consider another open > source database... PostgreSQL. > > Transactional support + tsearch2 = relational data integrity + smart > full text searching. > > More info: > > - http://www.postgresql.org/ > - http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ > > > -Robby > > -- > /************************************************************** > *...