Pg Full Text search in the ORM

2021-02-24 Thread Stats Student
Hi, does anyone know how to translate the following query to the ORM? select * from company where to_tsvector(name) @@ to_tsquery('gold:*') So far I have the following, but cannot seem to integrate the [:*] piece. Company.objects.annotate(search = SearchVector('name')).filter(search = SearchQuer

Full text search in multi language columns

2019-07-06 Thread Héctor Alonso Lozada Echezuría
I am trying to implement a full text search in django 1.11, in my model product_name and foreign_name can have values in English and Spanish, in pastebin <https://pastebin.com/RQS1AHtN> I have published my model with a manually created index which works very well with the query, I woul

Re: How to implement full-text search in Django?

2017-12-16 Thread Etienne Robillard
rm a full-text search query and return a JSON stream. My goal is to not duplicate data between redis and zodb... What do you think? Etienne Le 2017-12-16 à 06:05, Egor Smolyakov a écrit : Check out this library https://github.com/django-haystack/django-haystack It supports a wide ran

Re: How to implement full-text search in Django?

2017-12-16 Thread Egor Smolyakov
Check out this library https://github.com/django-haystack/django-haystack It supports a wide range of backends. On 16/12/2017, Etienne Robillard wrote: > Hi all, > > I would like some input on implementing a full-text search engine for my > website and blog. > > I really

How to implement full-text search in Django?

2017-12-16 Thread Etienne Robillard
Hi all, I would like some input on implementing a full-text search engine for my website and blog. I really don't want to use Google search API or a external webservice to index my documents. Also, my blog is powered by ZODB while my main website uses Durus. Ideally, i would like t

Re: Full text search available on PostgreSQL?

2014-10-07 Thread Benjamin Scherrey
ocs.djangoproject.com/en/dev/ref/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields> > full > text search only support MySQL. > > Are there plans on any progress towards getting this functionality on > PostgreSQL? > > Thanks > > -- > You received thi

Re: Full text search available on PostgreSQL?

2014-07-08 Thread jirka . vejrazka
f/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields> > full > text search only support MySQL. > > Are there plans on any progress towards getting this functionality on > PostgreSQL? > > Thanks > > -- > You received this message because you are subscribed to the Google > Groups &qu

Re: Full text search available on PostgreSQL?

2014-07-08 Thread Bastian Kuberek
This looks promising. Thanks -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to djan

Re: Full text search available on PostgreSQL?

2014-07-08 Thread Johannes Schneider
you could have a look at djorm-ext-pgfulltex. bg, Johannes On 28.06.2014 18:15, Bastian Kuberek wrote: Hi, Just saw that django.contrib.admin.ModelAdmin.search_fields <https://docs.djangoproject.com/en/dev/ref/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields> full text

Re: Full text search available on PostgreSQL?

2014-06-29 Thread Anssi Kääriäinen
On Saturday, June 28, 2014 7:15:05 PM UTC+3, Bastian Kuberek wrote: > > Hi, > > Just saw that django.contrib.admin.ModelAdmin.search_fields > <https://docs.djangoproject.com/en/dev/ref/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields> > full > text search

Full text search available on PostgreSQL?

2014-06-28 Thread Bastian Kuberek
Hi, Just saw that django.contrib.admin.ModelAdmin.search_fields <https://docs.djangoproject.com/en/dev/ref/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields> full text search only support MySQL. Are there plans on any progress towards getting this functionality on Post

Re: Supporting a wider range of awesome PostgreSQL features in Django - including hstore, JSON and full text search

2014-03-10 Thread Russell Keith-Magee
On Mon, Mar 10, 2014 at 7:22 PM, Matthieu Rigal wrote: > Is it somehow planned that Django Users can dialog with him to express > some desires ? > > For example, I would be very happy to see a reimplementation of the > annotate and aggregate functions, as they make the queries so slow by > groupin

Re: Supporting a wider range of awesome PostgreSQL features in Django - including hstore, JSON and full text search

2014-03-10 Thread Matthieu Rigal
Is it somehow planned that Django Users can dialog with him to express some desires ? For example, I would be very happy to see a reimplementation of the annotate and aggregate functions, as they make the queries so slow by grouping by all the fields that I always have to use raw SQL to group o

Re: Supporting a wider range of awesome PostgreSQL features in Django - including hstore, JSON and full text search

2014-02-23 Thread Russell Keith-Magee
On Sun, Feb 23, 2014 at 10:45 PM, Federico Capoano wrote: > I found this on django's blog: > > > https://www.kickstarter.com/projects/mjtamlyn/improved-postgresql-support-in-django > > Very interesting! > > Anybody knows if they intend to redevelop everything from scratch or reuse > and improve e

Supporting a wider range of awesome PostgreSQL features in Django - including hstore, JSON and full text search

2014-02-23 Thread Federico Capoano
I found this on django's blog: https://www.kickstarter.com/projects/mjtamlyn/improved-postgresql-support-in-django Very interesting! Anybody knows if they intend to redevelop everything from scratch or reuse and improve existing implementations? Federico -- You received this message because

Re: Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Brett Parker
On 18 Jul 18:28, Dmitry Gladkov wrote: > I like the idea, but I don't like the approach, it should be a > subclass of PositiveIntegerField, as it is an unsigned int on DB > level. Also, I agree with Łukasz that it should support both IPv6 and > IPv4. IPAddressField appears to be v4 only for backwa

Re: Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Dmitry Gladkov
I like the idea, but I don't like the approach, it should be a subclass of PositiveIntegerField, as it is an unsigned int on DB level. Also, I agree with Łukasz that it should support both IPv6 and IPv4. -- Best wishes, Dmitry Gladkov, mailto:dmitry.glad...@gmail.com +380 91 303-37-46 On Mon,

Re: Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Javier Guerra Giraldez
On Mon, Jul 18, 2011 at 10:13 AM, Javier Guerra Giraldez wrote: > On Mon, Jul 18, 2011 at 9:56 AM, Cal Leeming [Simplicity Media Ltd] > wrote: >> It stores the IP address in integer form, meaning the lookups on large >> tables are much faster: > > are they?    hashtables shouldn't be too sensitiv

Re: Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Cal Leeming [Simplicity Media Ltd]
Or maybe you were talking about hash tables in MySQL. Either way, you're right that this would probably need some benchmarks before being approved for the core. @django-developers, if I was to provide some benchmarks, would this possibly be considered for the core? Cal On Mon, Jul 18, 2011 at 4

Re: Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Cal Leeming [Simplicity Media Ltd]
Sorry, I should have been a little more specific. I meant faster lookups in terms of database index, such as MySQL with InnoDB. Cal On Mon, Jul 18, 2011 at 4:13 PM, Javier Guerra Giraldez wrote: > On Mon, Jul 18, 2011 at 9:56 AM, Cal Leeming [Simplicity Media Ltd] > wrote: > > It stores the IP

Re: Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Javier Guerra Giraldez
On Mon, Jul 18, 2011 at 9:56 AM, Cal Leeming [Simplicity Media Ltd] wrote: > It stores the IP address in integer form, meaning the lookups on large > tables are much faster: are they?hashtables shouldn't be too sensitive to key size, as long as the string size stays bounded... like on IP addr

Storing IP address as integer within database to remove need for full text search

2011-07-18 Thread Cal Leeming [Simplicity Media Ltd]
Hi, I have created a ModelField called RealIPAddressField. It stores the IP address in integer form, meaning the lookups on large tables are much faster: http://djangosnippets.org/snippets/2493/ @django-developers - Do you think there is any possibility of this getting included into the core?

Re: Full text search with PostgreSQL and Django

2010-12-17 Thread Jorge Bastida
http://haystacksearch.org/ 2010/12/17 marcoarreguin > Hi!! > > I need to implement a search engine with full text search, I'm using > postgreSQL and Django, I have searched in google ( > http://barryp.org/blog/entries/postgresql-full-text-search-django/ ) > but isn&#x

Full text search with PostgreSQL and Django

2010-12-17 Thread marcoarreguin
Hi!! I need to implement a search engine with full text search, I'm using postgreSQL and Django, I have searched in google ( http://barryp.org/blog/entries/postgresql-full-text-search-django/ ) but isn't there a more simple way ?? Or just another way? -- You received this message b

Re: Full Text Search

2010-10-01 Thread m1chael
maybe i misunderstood your question, but maybe it will help On Fri, Oct 1, 2010 at 8:19 PM, m1chael wrote: > Hello! > > I use PostgreSQL, and this is how I accomplished a full text search: > > def search(request): >  # how to set up postgresql for full text searching >  #al

Re: Full Text Search

2010-10-01 Thread m1chael
Hello! I use PostgreSQL, and this is how I accomplished a full text search: def search(request): # how to set up postgresql for full text searching #alter table quote_quote add column body_tsv tsvector; #CREATE TRIGGER quote_quote_tsvectorupdate BEFORE INSERT OR UPDATE ON quote_quote FOR

Re: Full Text Search

2010-10-01 Thread Andrej
Check this out: http://www.julienphalip.com/blog/2008/08/16/adding-search-django-site-snap/ On Oct 1, 6:52 am, Alessandro Ronchi wrote: > On Fri, Oct 1, 2010 at 3:35 AM, Steve Holden wrote: > > On 9/30/2010 8:26 PM, Nick Arnett wrote: > > > Brain is mush, though. > > Thank you. I'm waiting with

Re: Full Text Search

2010-10-01 Thread Nick Arnett
I'm waiting with hope :) > Brain less mushy now... Sometimes just knowing something is possible helps, which was why I posted last night. I used this idea: http://www.mercurytide.co.uk/news/article/django-full-text-search/ and added a parameter to turn boolean on and off. However, I'

Re: Full Text Search

2010-10-01 Thread Alessandro Ronchi
On Fri, Oct 1, 2010 at 3:35 AM, Steve Holden wrote: > On 9/30/2010 8:26 PM, Nick Arnett wrote: > > Brain is mush, though. > > Thank you. I'm waiting with hope :) -- Alessandro Ronchi http://www.soasi.com -- You received this message because you are subscribed to the Google Groups "Django u

Re: Full Text Search

2010-09-30 Thread Steve Holden
On 9/30/2010 8:26 PM, Nick Arnett wrote: > Brain is mush, though. Obviously, otherwise you'd have left it in the hope that someone else would reply with an answer before you recovered consciousness. Great heavens, this community is *so* anxious to help. Kudos for trying with a frazzled brain! reg

Re: Full Text Search

2010-09-30 Thread Nick Arnett
On Thu, Sep 30, 2010 at 8:34 AM, Alessandro Ronchi < alessandro.ron...@soasi.com> wrote: > Is there any way to make a FULL TEXT search not in BOOLEAN MODE? > I've found only > http://docs.djangoproject.com/en/1.1/ref/models/querysets/#search > > It says it uses BOOL

Full Text Search

2010-09-30 Thread Alessandro Ronchi
Is there any way to make a FULL TEXT search not in BOOLEAN MODE? I've found only http://docs.djangoproject.com/en/1.1/ref/models/querysets/#search It says it uses BOOLEAN MODE as a default, but doesn't tell how to avoid default... -- Alessandro Ronchi http://www.soasi.com Hobby &am

Re: Full-text search: what to use

2009-07-29 Thread Kegan
Any thoughts on using PostgreSQL built-in full text search ? On Jul 29, 5:49 pm, "dlvosse...@gmail.com" wrote: > I've recently adopted the use of xapian for full text search, via the > djapian django app which works like a charm. Xapian is written in C++ > with pytho

Re: Full-text search: what to use

2009-07-29 Thread dlvosse...@gmail.com
I've recently adopted the use of xapian for full text search, via the djapian django app which works like a charm. Xapian is written in C++ with python bindings, and with the djapian app u can stay within the django realm; e.g. updating the index can be done with manage.py index.. When

Re: Full-text search: what to use

2009-07-28 Thread alex finn
Thanks for your replies, it is useful. Has anyone used whoosh in production so far? Any ideas about it's performance? Alex. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group

Re: Full-text search: what to use

2009-07-28 Thread Russell Keith-Magee
hich is >> a nice wrapper around Lucene). > > I program a bibliography manager with Django.  Users are able to > upload the papers as PDFs, and I'd like to add full-text search.  So > far, I planned to user Solr Cell for it, but can one also do that > with Sphinx? Sphinx doesn

Re: Full-text search: what to use

2009-07-27 Thread Torsten Bronger
ers are able to upload the papers as PDFs, and I'd like to add full-text search. So far, I planned to user Solr Cell for it, but can one also do that with Sphinx? Tschö, Torsten. -- Torsten Bronger, aquisgrana, europa vetus Jabber ID: torsten.bron...@j

Re: Full-text search: what to use

2009-07-27 Thread Russell Keith-Magee
On Mon, Jul 27, 2009 at 11:14 PM, alex finn wrote: > > Hello, > > I'm working on a huge django-based application that heavily utilizes > full-text search. Up until now I've been using external search service > built using SOLR that is deployed separately. > The pro

Full-text search: what to use

2009-07-27 Thread alex finn
Hello, I'm working on a huge django-based application that heavily utilizes full-text search. Up until now I've been using external search service built using SOLR that is deployed separately. The problem is with such an approach I need to maintain 2 different environments - one

Re: full-text search

2009-05-28 Thread Alex Gaynor
> > > Someone has used a similar solution for versions after 1.0? > > > > [1]http://www.mercurytide.co.uk/news/article/django-full-text-search/ > > Toodle-lo... > creecode > > > Well for one thing that is mysql only, which is hangup for a lot of

Re: full-text search

2009-05-28 Thread creecode
necessary to use any external code (or > as xapian sphinx). Unfortunately this solution only works in older > versions of django. I tried to fix backend.quote_name, but failed. > > Someone has used a similar solution for versions after 1.0? > > [1]http://www.mercurytide.co.uk/ne

full-text search

2009-05-28 Thread Petry
sed a similar solution for versions after 1.0? [1]http://www.mercurytide.co.uk/news/article/django-full-text-search/ thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to t

Re: Postgres Full-text search -- is it possible?

2008-12-15 Thread alex.gay...@gmail.com
It can be done using extra as shown here: http://barryp.org/blog/entries/postgresql-full-text-search-django/ there isn't a way built into django to do it however, there are also a few external search projects to create a nicer search api in django. This one: http://code.google.

Postgres Full-text search -- is it possible?

2008-12-15 Thread Info Cascade
Hi -- I'm wanting to improve searches by using full-text searching. The documentation says: > > > search¶ > <http://docs.djangoproject.com/en/dev/ref/models/querysets/#search> > > A boolean full-text search, taking advantage of full-text indexing. &

Re: Django full text search best solution

2008-10-29 Thread Thomas Guettler
alain D. schrieb: > Being inside database transactions is a good reason to use database's > full text index ... but the sake of simplicity, a full text index > created by python code inside the models declaration (easily > maintainable) would be nice ... > > > This is inside the model declarati

Re: Django full text search best solution

2008-10-28 Thread alain D.
Being inside database transactions is a good reason to use database's full text index ... but the sake of simplicity, a full text index created by python code inside the models declaration (easily maintainable) would be nice ... > Since all external full text indexing (sphinx, lucene) won't be pa

Re: Django full text search best solution

2008-10-28 Thread Thomas Guettler
alain D. schrieb: > Hi, > > I'm looking at all the available solutions to implement a full text > index for django models and I found various projects at different > stages of maturity but none of them seems to have a strong community > support ... so here is the list along with my comments (and l

Django full text search best solution

2008-10-28 Thread alain D.
Hi, I'm looking at all the available solutions to implement a full text index for django models and I found various projects at different stages of maturity but none of them seems to have a strong community support ... so here is the list along with my comments (and last commit time) ... it any o

Sphinx Full-Text Search

2008-04-05 Thread David Cramer
I know some of you out there use my full-text layer relying on Sphinx in Django. I released a new version yesterday, which on my initial tests is fully backwards compatible. So the point, what I'm looking for, is has anyone put the new version to use yet? If not, can you try it on your working co

Re: full-text search and mediawiki markup apps

2007-09-08 Thread Useful Database
Hello friends, I recently happened to see the below information ... just thought that it could be useful to you people ... Thanks. -- *Introducing for the first time in **India**, a Product that

Re: full-text search and mediawiki markup apps

2007-09-08 Thread ringemup
Just yesterday, I was thinking how useful it would be to be able to use mediawiki markup syntax for a new project... and voila -- my prayers are answered! Thank you for putting this together! One problem... I'm getting a syntax error on import (using python 2.5): >>> import wikimarkup Traceback

full-text search and mediawiki markup apps

2007-09-07 Thread David Cramer
I've taken the time to upload both our SphinxSearch layer, and our MediaWiki markup util to Google code today. For more info see my blog post: http://www.davidcramer.net/code/54/mediawiki-markup-and-sphinxsearch-... I haven't used Google code before, so if theres any problems just let me know. E

Tutorial: Full text search with Lupy in Django

2006-12-19 Thread [EMAIL PROTECTED]
I've written a small tutorial about using Lupy - a full text python search engine and Django: Link: http://www.rkblog.rk.edu.pl/w/p/django-lupy/ I'll more code when I'll add Lupy search support to Diamanda :) Django full-text branch isn't finished and won't be in the near and not near future from

django dont support select_related when use full-text search?

2006-08-27 Thread [EMAIL PROTECTED]
i seems django dont support select_related when using full-text search filter. a.objects.filter(field1__search=q), it can return results successfully, but when i wrote: a.objects.select_related.filter(field1__search=q),it returns nothing. why that happen

how to select related field in full-text search filter?

2006-08-27 Thread [EMAIL PROTECTED]
it seems like django dont support select_related when using full-text search? a.objects.filter(field1__search=str) can show the results successful but: a.objects.select_related().filter(field1__search=str) show nothing why that happen

Re: Public Domain ( was Re: Full Text Search w/ MySQL)

2006-08-12 Thread Jan Claeys
Op vr, 04-08-2006 te 16:55 +1000, schreef Ian Holsman: > To quote the paper: This “Give-It-Away” license provides no protection > for anyone if the donated software causes harm. > > ie.. even if you didn't mean it, if I used a piece of public domain > code in a app I write and it fails, i can s

Public Domain ( was Re: Full Text Search w/ MySQL)

2006-08-04 Thread Ian Holsman
On 03/08/2006, at 10:42 PM, Andrew Durdin wrote: the code in the paper is released intothe public domain, so there's nothing stopping any interested personfrom taking it and developing it into something more suited for generalsearching.AndrewThis isn't directed at you, or your paper Andrew.I kno

Re: Full Text Search w/ MySQL

2006-08-03 Thread Andrew Durdin
Adam Endicott wrote: > > Do any of the core devs see this as a candidate for inclusion in > contrib? Speaking as the author of the piece -- I don't. This code isn't developed enough to be particularly practical as-is: to be more useful it should probably support both natural language and boolean

Re: Full Text Search w/ MySQL

2006-08-02 Thread Adam Endicott
Nice work John, good stuff. Do any of the core devs see this as a candidate for inclusion in contrib? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to djang

Re: [White-paper] Full Text Search w/ MySQL

2006-08-02 Thread Adrian Holovaty
On 8/2/06, John Sutherland <[EMAIL PROTECTED]> wrote: > I just wanted to let you know about a white-paper written by one of > the guys in my office. > > "Extending Django's database API to include full-text search" > <http://www.mercurytide.com/knowledge/whi

[White-paper] Full Text Search w/ MySQL

2006-08-02 Thread John Sutherland
Hi all, I just wanted to let you know about a white-paper written by one of the guys in my office. "Extending Django's database API to include full-text search" <http://www.mercurytide.com/knowledge/white-papers/django-full-text-search> We spent a little bit of time coming