The latest articles on DEV Community by Houze (@houze). https://dev.to/houze https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F931078%2F42b2dd6e-f6a6-4831-9f98-63f3cb375d61.png https://dev.to/houze en Houze Fri, 23 Sep 2022 08:04:52 +0000 https://dev.to/houze/apply-search-unicode-by-unaccent-1hjd https://dev.to/houze/apply-search-unicode-by-unaccent-1hjd <p>Step 1 : Add extension unaccent for Postgres by run query &gt; create extension unaccent <br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--frQ_0Rbp--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jwdualliir8j0f4l7zwb.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--frQ_0Rbp--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jwdualliir8j0f4l7zwb.png" alt="Image description" width="462" height="163"></a></p> <p>Step 2 : Python/INSTALLED_APPS add &gt; 'django.contrib.postgres'<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--m5YSo_Rz--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sv6v9cendau3f6iykrjj.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--m5YSo_Rz--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sv6v9cendau3f6iykrjj.png" alt="Image description" width="880" height="489"></a></p> <p>Step 3 : Using unaccent in filter , <br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--l3ZZshRF--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n1gw6liug7cvbrigifg0.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--l3ZZshRF--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n1gw6liug7cvbrigifg0.png" alt="Image description" width="624" height="278"></a></p> <p>Warning 1: unaccent lookups should perform fine in most use cases. However, queries using this filter will generally perform full table scans, which can be slow on large tables. In those cases, using dedicated full text indexing tools might be appropriate.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--8hHWCg5g--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i36g4da8i5t4iq2ivxon.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--8hHWCg5g--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i36g4da8i5t4iq2ivxon.png" alt="Image description" width="880" height="212"></a></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--kVGTsfOn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/57vhdm0xuhd3clran2zl.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--kVGTsfOn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/57vhdm0xuhd3clran2zl.png" alt="Image description" width="880" height="287"></a></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--eguj245---/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k996sg4i8jgk089e70gh.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--eguj245---/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k996sg4i8jgk089e70gh.png" alt="Image description" width="880" height="290"></a></p> python postgres search