Unaccented Name Search with Postgres and Ecto
Postgres does not support searching for names with special characters by default. Here is how to fix it.
Postgres does not support searching for names with special characters by default. Here is how to fix it.
A detailed deep-dive into efficient full-text search for multiple languages, result ranking, tsvectors and tsqueries, search modifiers, and so much more.
Search through millions of strings efficiently using indexed ILIKE or SIMILARITY queries.
Block overlapping appointments efficiently in your database using exclusion constraints and don't worry about double-bookings ever again!
Write more efficient bulk insert queries and avoid sending duplicate data by using placeholders.
Implement insert-or-update functionality for your schemas directly with Ecto's on_conflict option.