# How to store Ferret index in DB using acts\_as\_ferret?

**URL:** <https://www.ruby-forum.com/t/how-to-store-ferret-index-in-db-using-acts-as-ferret/83504>\
**Category:** Ferret\
**Created:** [January 26, 2007, 6:49pm UTC](https://www.ruby-forum.com/t/how-to-store-ferret-index-in-db-using-acts-as-ferret/83504 "2007-01-26T18:49:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [January 26, 2007, 6:49pm UTC](https://www.ruby-forum.com/t/how-to-store-ferret-index-in-db-using-acts-as-ferret/83504/1 "2007-01-26T18:49:13Z")

</div>

Hello,

I would like Ferret index to be stored in DB ( instead of multiple  
files )

It would allow me to centralize all datas in a unique media + backup my  
index using a simple DB export.

Is there a way to do so ?

Thks

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [January 26, 2007, 9:24pm UTC](https://www.ruby-forum.com/t/how-to-store-ferret-index-in-db-using-acts-as-ferret/83504/2 "2007-01-26T21:24:58Z")

</div>

On 26.01.2007, at 18:49, Pierre-Yves Landanger wrote:

> I would like Ferret index to be stored in DB ( instead of multiple  
> files )

Ferret is optimized for speed and therefore uses it’s own file  
format. A database is not a suitable place to store a full text  
index, mainly for performance reasons.

> It would allow me to centralize all datas in a unique media +  
> backup my  
> index using a simple DB export.

I assume you use Ferret to index data which is stored in your  
database anyway. It’s of little use to backup your Ferret index since  
it can be rebuilt from the contents of your database. If you need to  
restore your database from a backup just rebuild your index afterwards.

Cheers,  
Andy

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [January 30, 2007, 4:48pm UTC](https://www.ruby-forum.com/t/how-to-store-ferret-index-in-db-using-acts-as-ferret/83504/3 "2007-01-30T16:48:14Z")

</div>

All right,

Thank you Andy ^^

```
  py
```