Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are several options available and each have different strengths and weaknesses. If you would like to add full-text searching, it would be prudent to investigate each a little bit and try them out to see how well it works for you in your environment.</p> <p>MySQL has built-in support for full-text searching. It has online support meaning that when new records are added to the database, they are automatically indexed and will be available in the search results. The <a href="http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html" rel="nofollow noreferrer">documentation</a> has more details.</p> <p><a href="http://code.google.com/p/acts-as-tsearch/" rel="nofollow noreferrer"><code>acts_as_tsearch</code></a> offers a wrapper for similar built-in functionality for recent versions of <a href="http://www.postgresql.org/docs/8.3/static/textsearch.html" rel="nofollow noreferrer">PostgreSQL</a></p> <p>For other databases you will have to use other software.</p> <p><a href="http://lucene.apache.org/" rel="nofollow noreferrer">Lucene</a> is a popular search provider written in Java. You can use Lucene through its search server <a href="http://lucene.apache.org/solr/" rel="nofollow noreferrer">Solr</a> with Rails using <a href="http://acts-as-solr.rubyforge.org/" rel="nofollow noreferrer"><code>acts_as_solr</code></a>.</p> <p>If you don't want to use Java, there is a port of Lucene to Ruby called <a href="http://ferret.davebalmain.com/trac/wiki" rel="nofollow noreferrer">Ferret</a>. Support for Rails is added using the <a href="http://projects.jkraemer.net/acts_as_ferret/wiki" rel="nofollow noreferrer"><code>acts_as_ferret</code></a> plugin.</p> <p><a href="http://xapian.org/" rel="nofollow noreferrer">Xapian</a> is another good option and is supported in Rails using the <a href="http://github.com/frabcus/acts_as_xapian/wikis" rel="nofollow noreferrer"><code>acts_as_xapian</code></a> plugin.</p> <p>Finally, my preferred choice is <a href="http://www.sphinxsearch.com/" rel="nofollow noreferrer">Sphinx</a> using the <a href="http://blog.evanweaver.com/files/doc/fauna/ultrasphinx/files/README.html" rel="nofollow noreferrer">Ultrasphinx</a> plugin. It is extremely fast and has many options on how to index and search your databases, but is no longer being actively maintained.</p> <p>Another plugin for Sphinx is <a href="http://ts.freelancing-gods.com/" rel="nofollow noreferrer">Thinking Sphinx</a> which has a lot of positive <a href="http://www.williambharding.com/blog/rails/rails-thinking-sphinx-plugin-full-text-searching-thats-cooler-than-a-polar-bears-toenails/" rel="nofollow noreferrer">feedback</a>. It is a little easier to get started using Thinking Sphinx than Ultrasphinx. I would suggest investigating both plugins to determine which fits better with your project.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I do full-text searching in Ruby on Rails?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USsock
    1. USsock
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I do full-text searching in Ruby on Rails?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload