Topics tagged ecto-query

Topic	Replies	Views	Activity
Composite - a library for writing dynamic queries Announcing ecto , library , ecto-query , dynamic-query	5	1829	August 22, 2026
Citext extension and making case-insensitive columns in PostGresQL Questions postgres , ecto-query	8	5066	March 17, 2026
Querying an array of ints in PostgreSQL using Ecto Questions ecto , postgres , ecto-query	3	498	January 21, 2026
Ecto: Limit per item in related table Questions ecto , ecto-query	4	447	January 7, 2026
How to model and enforce: "A table has zero or one of multiple specification associations" Questions ecto , macros , ecto-query , ecto-migration , ecto-schema	3	394	November 12, 2025
Ecto IN clauses with tuples Questions ecto , ecto-query	20	5984	September 23, 2025
How exactly an Ecto stream works? Questions ecto , sql , ecto-query , stream	4	553	May 14, 2025
Ecto query into Plain SQL Questions ecto , ecto-query	12	7869	January 14, 2025
Preload multiple associations with only one join? Questions ecto , ecto-query	3	398	November 29, 2024
Ecto query call when using aggregate function Questions ecto , phoenix , ecto-query	5	4090	October 24, 2024
How do I solve pagination (Repo.aggregate(:count)) on query with group_by in the best way? Questions ecto , troubleshooting , ecto-query , pagination	3	1483	September 25, 2024
Ecto query of a JSONB column Questions ecto-query	5	2270	July 16, 2024
SQL to ecto: custom order by getting (Postgrex.Error) ERROR 42601 (syntax_error) syntax error at or near "AS" Questions ecto , phoenix , ecto-query	3	335	July 10, 2024
How to make a query in Ecto that checks if a Schema is related to another schema in a One to Many relationship Questions ecto , learning-elixir , ecto-query , ecto-schema	2	430	July 4, 2024
Selecting parent records based on state of latest child record Questions ecto , phoenix , ecto-query , ecto_sql	5	495	June 2, 2024
Ecto Query preloading complex association Questions ecto , ecto-query , preload	3	477	April 29, 2024
How to select_merge with fragment? Questions ecto-query , ecto_sql	4	536	February 21, 2024
Performance implications of Ecto within-query preloads with postgres Questions ecto , performance , ecto-query	3	2037	July 10, 2020
Ecto get records where association count is 0 Questions ecto , associations , ecto-query	7	2913	November 30, 2023
Interpolate Ecto.Enum in fragment/1 Questions ecto , ecto-query	3	486	October 9, 2023
Best practices when writing context functions with DB queries Questions ecto , ecto-query , phonenix	2	613	September 30, 2023
Tracking down slow queries in Ecto Questions ecto , performance , ecto-query , monitoring	22	2919	September 22, 2023
How to prevent LIKE-injections Questions ecto , ecto-query	16	5474	August 29, 2023
Ecto doesn't use index when performing a query but should Questions ecto , phoenix , ecto-query , index	5	1019	August 4, 2023
Struggling with Ecto, distinct, and sum Questions ecto , ecto-query	5	884	July 25, 2023
Ecto Query Returns unwanted data Questions ecto , ecto-query	6	421	July 12, 2023
How to query for villas with bedroom air-conditioning? Questions ecto , ecto-query , ecto_sql	1	452	July 7, 2023
Querying deeply nested associations Questions ecto , phoenix , ecto-query	4	1001	June 29, 2023
Ecto query order for preload Questions ecto , ecto-query	16	4215	June 28, 2023
Getting stuck on more complex Ecto queries: combining conditions, preloading and selecting Questions ecto , phoenix , ecto-query , preload	11	1546	June 18, 2023