Topics tagged sql

Topic	Replies	Views	Activity
Podcast: Thinking Elixir 166 - Filtering, ordering and pagination via Flop Blogs & Podcasts ecto , sql , podcasts , via-devtalk , podcasts-by-brainlid , in-the-news	0	122	August 29, 2023
Connect to SQL server with TCP protocol Questions / Help sql , tcp , gen_tcp , tds	2	142	June 14, 2023
Ecto: fetch all records not related in join table Questions / Help ecto , sql , postgres , database	2	171	May 22, 2023
Ecto Query to compare 2 tables on a string column and return the unmatched result Questions / Help sql , ecto_sql	5	481	January 21, 2023
Postgrex how to pack argument for Select IN Questions / Help sql , postgrex	4	372	July 9, 2022
Library to convert an SQL schema into an Ecto schema Questions / Help ecto , sql , ecto_sql	0	368	July 5, 2022
INSERT … SELECT in Ecto using Ecto.Query Questions / Help ecto , sql , postgresql	8	4237	September 12, 2021
Aggregate query counts with multiple where values Questions / Help ecto , sql	4	702	August 31, 2021
Preloading top comments for posts in Ecto using window functions Questions / Help ecto , sql , mysql	3	785	March 19, 2021
How to query on keys in an embeds_many Questions / Help ecto , sql , postgres	2	718	November 18, 2020
Ecto SQL query does not return the expected value Questions / Help ecto , sql , postgres , postgresql	9	878	October 7, 2020
How we can Prevent SQL Injection in Phoenix framework? Questions / Help ecto , security , phoenix , sql	2	945	September 14, 2020
Selecting values from multiple rows to use in group by Questions / Help ecto , sql	2	978	August 22, 2020
How to apply SQL array aggregation function in Ecto Questions / Help lists , maps , sql , ecto-query , ecto_sql	3	3137	July 8, 2020
Cascade delete with many to many relationship Questions / Help ecto , sql	1	657	May 3, 2020
Ecto Fragment interpolating var in group_by and select Questions / Help ecto , sql	4	1525	February 27, 2020
Creating an SQL injection Questions / Help ecto , phoenix , sql	4	969	December 9, 2019
How to maintain an auto increment field but per category Questions / Help ecto , sql	3	1437	November 3, 2019
Performing a find-or-create in Ecto? Questions / Help ecto , sql , postgresql	8	5687	September 7, 2019
How to use PostgreSQL's DISTINCT ON in Ecto Query Questions / Help ecto , sql , postgresql	11	8637	July 12, 2019
NoSQL vs OldSql General Prog (Archived) sql , nosql	5	848	June 18, 2019
Backend with pure elixir (direct SQL in DataBase) without frameworks possible? Questions / Help sql	19	2447	May 14, 2019
SQL structure for many, different child entities Questions / Help sql , postgresql	23	2289	May 3, 2019
Postgres recursive CTE on single table Questions / Help sql , postgres , postgresql , ecto-query	9	2447	April 19, 2019
How to connect simple elxiir app to MySQL database and execute query? Questions / Help sql , mysql , learning-elixir	8	5557	April 11, 2019
Help with subquery including joins and preloads for pagination Questions / Help ecto , phoenix , sql	4	3037	January 26, 2019
Sum of two left_joins returns doubled values in first table Questions / Help ecto , sql	13	3704	July 7, 2018
PostgreSQL does not support selecting all fields from without a schema Questions / Help ecto , sql , postgres , ecto-query	2	3232	June 29, 2018
How to return a structured JSON with column names and values in Mariaex Questions / Help sql , json , mysql	2	1658	June 12, 2018
Adding prefix to field values obtained by Ecto.Query.select Questions / Help ecto , phoenix , sql	6	1711	May 13, 2018