Contributors mailing list archives

Browse archives


Re: Full text search

Juan José Scarafía
- 23/06/2021 16:11:44
Hi Lorenzo,
I agree that having an implementation of postgres full text search would be a great improvement and would solve many use cases without needed integrations and other softwares.

The Holger module could be a good starting point

I believe it would be great to make an implementation of full text search configurable by the user on each model similar as done here. Basically it would be:
* user can choose on each models fields to be included on the full text search
* user can choose to enable that search as the "name_search" one
* user can choose to enable "smart search" it would be the first available option on the "search view" that would implement the full text search.

So, for eg:
* user choose on product.product the following fields to be used: name, barcode, default_code, brand
* user enable "smart search" + " name search"
* then:
a) on a sale order, user can search a product with a very flexible way
b) on the product.product tree view user can search with same flexible way

All this searches are already implemented with native "ilike" searches but are not so powerful and performant. It's also integrated on ecommerce here


Ing. Juan José Scarafía

(+54 9 341) 3 278039

twitter: @jjscarafia

github: @jjscarafia

El mar, 22 de jun. de 2021 a la(s) 06:22, Lorenzo Battistini ( escribió:
Thanks everyone for your helpful advice.

My primary goal is to improve search mechanisms of some frontend pages, like e-commerce products or slides.
Of course a solution at framework level, which would allow to apply the improved search to any model, would be great.

I like the postgres approach because
  1. It seems powerful enough to cover our needs
  2. We don't have to install other (big) softwares, hard and onerous to maintain
So, in the first place, I will have a look at Holger's and Anders's works.

Thanks a lot!

On Tue, 22 Jun 2021 at 08:12, Mignon, Laurent <> wrote:
Hello everyone,

I think Simone has given a good summary of the problem. I don't have much more to say. I would however just like to clarify a technical point about and more specifically the module dedicated to Elasticsearch. This module has been developed based of versions of Elasticsearch licensed under Apache 2.0. This module uses a limited number of methods from the api provided by Elasticsearch to publish and synchronize data in the indexes. I have personally used it with the Opendistro distribution of ES and I am confident that it will work seamlessly with Opensearh ( which is a fork of ES based on the latest version released under Apache 2.0. If this is not the case, it is very likely that the adaptations to be made will be minor. These are just a few technical considerations of no importance until the functional needs are clearly defined.



On Tue, Jun 22, 2021 at 7:27 AM Simone Orsi <> wrote:
Hello everyone,

guys, let's get back on track! I think none of these topics is relevant for Lorenzo. At least not at this stage.
Nobody is asking what's the final goal. Me included ;)

@Lorenzo: What are you looking for?

From my perspective:

a) if you need something pluggable in the backend, something that works w/ "normal" odoo models you should have a look at what Holger did. It's a bit complex and many implementation details should be rewritten completely but it gives you an idea on how to get there.

b) If you need something for the frontend, I'd definitely go for ES (especially if you want faceted search). Once you have ES in place you can use SearchKit JS to easily build a search UI.

c) If you don't want to maintain the search engine and you want a reliable and easy to use configuration you can use Algolia (yes, a proprietary servivce! :P)  but watch out because it can be very expensive.

Both b and c are feasible w/ the search-engine framework.

d) If you only need a full text index for one very particular model in one very particular form, I'd go for basic postgres full text indexing + some custom code.

HTH. If you need help on setting up the search engine stuff let me know ;)


On Mon, Jun 21, 2021 at 8:57 PM Frederik Kramer <> wrote:
Holger of course you are right, 

but just hiding crap in a container doesn't make it significantly less
cumbersome at the detailed level. But of course if you have a nicely
built docker-compose oder kubernetes service defintion at hand much is
done anywhere else an you only have to handle ENV variables.


Am Montag, den 21.06.2021, 18:31 +0000 schrieb Holger Brunn:

> > Neverthless all Java ;-)


> when I was young I would complain about Java, but now you just stick

> it into a 

> container and be done with it

> _______________________________________________

> Mailing-List:

> Post to:

> Unsubscribe:

Dr.-Ing. Frederik Kramer
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155

Post to:

Simone Orsi

Full stack Python web developer, Odoo specialist, Odoo Community Board Member, in love with open source.

Post to:

Post to:


Post to: