Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search postgresql postgres mysql   |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by dlo):

 * keywords:  oracle fulltext search => oracle fulltext search postgresql
 postgres mysql


Comment:

 I'd be happy to work on this ticket. I just implemented a very flexible
 FTS integration with custom fields, and built in support for migrations to
 automatically create the indices. If it's ok, I'd like to take the reigns
 on this if no one else has time to.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/076.b81d28410ef626788ec6be7960354e8b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-

Comment (by MalikRumi):

 I was just reading in the documentation that full text search is only
 available for MySQL, and came over here to find out why. What can I do to
 help light a fire under this project?

 What are people doing in the meantime? Solr? Haystack?

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/076.9b7a180b9d86b0096fbca801c02bc590%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by mjtamlyn):

 * status:  new => assigned
 * owner:  nobody => mjtamlyn


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/076.0f822f0e9a1d8d6c3c760a15ef435988%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-

Comment (by mpessas):

 This is definitely something I would like to see in Django and could help
 with (see https://github.com/mpessas/django-pg-extensions for another
 package that supports FTS in PostgreSQL).

 Here is a suggestion as how this could be implmented for PostgreSQL:

 - Add two extra options in TextField, use_fts=True and fts_config (see
 http://www.postgresql.org/docs/9.3/static/textsearch-intro.html
 #TEXTSEARCH-INTRO-CONFIGURATIONS), with 'simple' being the default value.
 - When the use_fts option is set, create an index (see
 http://www.postgresql.org/docs/9.3/static/textsearch-tables.html
 #TEXTSEARCH-TABLES-INDEX). The main reasons to prefer an index to a column
 for the tsvector representation are that this is simpler to set up (no
 need for columns that are not exposed in Django and no need for triggers
 or methods to update the column) and that, even if it is a bit slower,
 most people would not mind; if they care for performance, they can do it
 manually or use Solr etc. See http://www.postgresql.org/docs/9.3/static
 /textsearch-tables.html for the details of the two approaches.
 - The user can do a fts query by using the `search` field lookup.

 I haven't looked into fts for some time now, so I might be forgetting
 something. In any case, how does this proposal sound?

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/076.612ce000d77923ad2e75ee28ecff1412%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by mpessas):

 * cc: mpessas@… (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/076.e71321958c38be3f780f429f7f5d2089%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by slav0nic):

 * cc: slav0nic@… (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by niwi):

 * cc: niwi@… (added)


Comment:

 If in the future, are going to implement support for postgresql text
 search, you can have this as a reference implementation:
 https://github.com/niwibe/djorm-ext-
 pgfulltext/blob/master/djorm_pgfulltext/models.py

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by robin):

 * cc: robinchew@… (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by jpic):

 * cc: jpic (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
-+-
 Reporter:  Ronny Pfannschmidt   |Owner:  nobody
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle fulltext  |  Needs documentation:  1
  search |  Patch needs improvement:  1
Has patch:  1|UI/UX:  0
  Needs tests:  1|
Easy pickings:  0|
-+-

Comment (by Stefano Crosta ):

 can this be useful? http://barryp.org/blog/entries/postgresql-full-text-
 search-django/

 There's a special "search" method for MySQL but still nothing for
 PostgreSQL... any specific reason? This interesting ticket seems just
 abandoned!

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
---+
  Reporter:  Ronny Pfannschmidt| Owner:  nobody 
   
Status:  new   | Milestone: 
   
 Component:  Database layer (models, ORM)  |   Version: 
   
Resolution:|  Keywords:  oracle 
fulltext search
 Stage:  Accepted  | Has_patch:  1  
   
Needs_docs:  1 |   Needs_tests:  1  
   
Needs_better_patch:  1 |  
---+
Changes (by justinlilly):

 * cc: justinli...@gmail.com (added)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
---+
  Reporter:  Ronny Pfannschmidt| Owner:  nobody 
   
Status:  new   | Milestone: 
   
 Component:  Database layer (models, ORM)  |   Version: 
   
Resolution:|  Keywords:  oracle 
fulltext search
 Stage:  Accepted  | Has_patch:  1  
   
Needs_docs:  1 |   Needs_tests:  1  
   
Needs_better_patch:  1 |  
---+
Old description:

> I didn't like it was missing.
>
> oracle, mssql : add a FulltextIndex for the Fields
>
> postgresql: for each FulltextField add a extra tsvector Field named like
> "%(fieldname)_tsv"
>
> Problems with sqlite fts:
> * they stated a match statement may only be used once in a query
> * it needs a very specific syntax to search multiple fields
> * i have no idea how to get that into the ORM

New description:

 I didn't like it was missing.

 oracle, mssql : add a !FulltextIndex for the Fields

 postgresql: for each !FulltextField add a extra tsvector Field named like
 `"%(fieldname)_tsv"`

 Problems with sqlite fts:

  * they stated a match statement may only be used once in a query
  * it needs a very specific syntax to search multiple fields
  * i have no idea how to get that into the ORM

Comment (by ramiro):

 (description)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
---+
  Reporter:  Ronny Pfannschmidt| Owner:  nobody 
   
Status:  new   | Milestone: 
   
 Component:  Database layer (models, ORM)  |   Version: 
   
Resolution:|  Keywords:  oracle 
fulltext search
 Stage:  Accepted  | Has_patch:  1  
   
Needs_docs:  1 |   Needs_tests:  1  
   
Needs_better_patch:  1 |  
---+
Changes (by mboersma):

  * keywords:  => oracle fulltext search

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
---+
  Reporter:  Ronny Pfannschmidt| Owner:  nobody
Status:  new   | Milestone:
 Component:  Database layer (models, ORM)  |   Version:
Resolution:|  Keywords:
 Stage:  Accepted  | Has_patch:  1 
Needs_docs:  1 |   Needs_tests:  1 
Needs_better_patch:  1 |  
---+
Changes (by mboersma):

 * cc: mboersma (added)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #3254: [patch] experimental fulltext search support for postgres, oracle and mssql

[Django]

#3254: [patch] experimental fulltext search support for postgres, oracle and 
mssql
---+
  Reporter:  Ronny Pfannschmidt| Owner:  nobody
Status:  new   | Milestone:
 Component:  Database layer (models, ORM)  |   Version:
Resolution:|  Keywords:
 Stage:  Accepted  | Has_patch:  1 
Needs_docs:  1 |   Needs_tests:  1 
Needs_better_patch:  1 |  
---+
Changes (by anonymous):

 * cc: tw...@twidi.com (added)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---