# Indexing feature

**URL:** <https://www.ruby-forum.com/t/indexing-feature/194916>\
**Category:** Rails\
**Created:** [September 13, 2010, 7:05pm UTC](https://www.ruby-forum.com/t/indexing-feature/194916 "2010-09-13T19:05:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![awijeet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/65b543/32.png) [@awijeet](https://www.ruby-forum.com/u/awijeet)\
**Post date:** [September 13, 2010, 7:05pm UTC](https://www.ruby-forum.com/t/indexing-feature/194916/1 "2010-09-13T19:05:52Z")

</div>

How can I enable my admin to index the tables, just after he/she makes  
change into database.

---

<div class="post-metadata">

**Author:** ![awijeet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/65b543/32.png) [@awijeet](https://www.ruby-forum.com/u/awijeet)\
**Post date:** [September 14, 2010, 2:47am UTC](https://www.ruby-forum.com/t/indexing-feature/194916/2 "2010-09-14T02:47:24Z")

</div>

you can trigger a rake task

---

<div class="post-metadata">

**Author:** ![awijeet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/65b543/32.png) [@awijeet](https://www.ruby-forum.com/u/awijeet)\
**Post date:** [September 14, 2010, 6:46pm UTC](https://www.ruby-forum.com/t/indexing-feature/194916/3 "2010-09-14T18:46:46Z")

</div>

Awijeet Mr. wrote:

> How can I enable my admin to index the tables, just after he/she makes  
> change into database.

The database should take care of its own indexing. Your application  
normally does not need to worry about this once the indices are set up.

Or am I misunderstanding your question?

## Best,

Marnen Laibow-Koser  
[http://www.marnen.org](http://www.marnen.org)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![awijeet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/65b543/32.png) [@awijeet](https://www.ruby-forum.com/u/awijeet)\
**Post date:** [September 14, 2010, 7:38pm UTC](https://www.ruby-forum.com/t/indexing-feature/194916/4 "2010-09-14T19:38:57Z")

</div>

oops got confused with full text indexing i thought you where talking  
about  
sphinx or something like it

On Tue, Sep 14, 2010 at 12:46 PM, Marnen Laibow-Koser

---

<div class="post-metadata">

**Author:** ![awijeet](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/65b543/32.png) [@awijeet](https://www.ruby-forum.com/u/awijeet)\
**Post date:** [September 14, 2010, 9:37pm UTC](https://www.ruby-forum.com/t/indexing-feature/194916/5 "2010-09-14T21:37:48Z")

</div>

On Sep 13, 7:05 pm, “Awijeet Mr.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> How can I enable my admin to index the tables, just after he/she makes  
> change into database.

Just create new controller and execute in index action a sql statement  
that will return list of database tables. With that you will have live  
view of tables list.

Robert Pankowecki