Topics tagged sql

Topic	Replies	Views	Activity
Selecting values from multiple rows to use in group by Questions / Help ecto , sql	2	1600	August 22, 2020
How to apply SQL array aggregation function in Ecto Questions / Help lists , maps , sql , ecto-query , ecto_sql	3	4694	July 8, 2020
Cascade delete with many to many relationship Questions / Help ecto , sql	1	939	May 3, 2020
Ecto Fragment interpolating var in group_by and select Questions / Help ecto , sql	4	2155	February 27, 2020
Creating an SQL injection Questions / Help ecto , phoenix , sql	4	1279	December 9, 2019
How to maintain an auto increment field but per category Questions / Help ecto , sql	3	1938	November 3, 2019
Performing a find-or-create in Ecto? Questions / Help ecto , sql , postgresql	8	7420	September 7, 2019
How to use PostgreSQL's DISTINCT ON in Ecto Query Questions / Help ecto , sql , postgresql	11	10638	July 12, 2019
NoSQL vs OldSql General Prog (Archived) sql , nosql	5	1013	June 18, 2019
Backend with pure elixir (direct SQL in DataBase) without frameworks possible? Questions / Help sql	19	3140	May 14, 2019
Postgres recursive CTE on single table Questions / Help sql , postgres , postgresql , ecto-query	9	3074	April 19, 2019
How to connect simple elxiir app to MySQL database and execute query? Questions / Help sql , mysql , learning-elixir	8	7531	April 11, 2019
Help with subquery including joins and preloads for pagination Questions / Help ecto , phoenix , sql	4	3486	January 26, 2019
Sum of two left_joins returns doubled values in first table Questions / Help ecto , sql	13	4794	July 7, 2018
PostgreSQL does not support selecting all fields from without a schema Questions / Help ecto , sql , postgres , ecto-query	2	3944	June 29, 2018
How to return a structured JSON with column names and values in Mariaex Questions / Help sql , json , mysql	2	1904	June 12, 2018
Adding prefix to field values obtained by Ecto.Query.select Questions / Help ecto , phoenix , sql	6	2085	May 13, 2018
Does the following PostgreSQL (9.5) statement involve disk writes General Prog (Archived) sql , postgres	2	1065	December 31, 2017
Dynamic Query Generation Questions / Help ecto , phoenix , sql	2	1970	November 9, 2017
How to do joins and grouping in Ecto Questions / Help ecto , phoenix , sql	1	3777	October 26, 2017
Running custom DDL commands in Ecto Questions / Help ecto , deployment , sql	1	1289	October 24, 2017
Error in creating non primary auto-increment field Questions / Help ecto , databases , sql , how-to-question	0	1517	October 23, 2017
SQL vs Ecto optimization/translation help Questions / Help ecto , sql	29	3818	October 15, 2017
SQL Query to Substitute value in the scanned results and update that field of Table Questions / Help ecto , sql , postgres	1	761	October 3, 2017
How to do SQL variable binding in `from` Questions / Help ecto , sql	1	853	September 24, 2017
Adding multiple associations with one cast Questions / Help ecto , best-practices , sql	4	1704	August 28, 2017
How to handle Database pooling in MSSQL Questions / Help databases , sql , how-to-question	0	917	August 5, 2017
SQL - modeling overlapping schedules Questions / Help sql	0	831	July 15, 2017
"undefined function fragment" in from or alternative errors if I change things around Questions / Help ecto , sql	1	1338	June 10, 2017
How to run a SELECT WHERE column IN (...) query? Questions / Help ecto , sql	8	4331	May 10, 2017