Topics tagged sql

Topic	Replies	Views	Activity
How to select virtual field from a CTE Questions / Help sql , ecto , phoenix	3	86	October 18, 2024
Elixir + Functional Programming in 9-12 High School Livebook Forum sql , functional-programming , livebook-questions , ecto , phoenix	6	165	September 28, 2024
SQLToy in Elixir Other Resources sql	0	162	September 9, 2024
SQL structure for many, different child entities Questions / Help postgresql , sql	25	3130	June 20, 2024
Inserting to Tables with Foreign Key Mappings (strategy suggestions) Questions / Help sql , ecto_sql , ecto	0	142	March 30, 2024
ExtractQueryParams - A simple elixir package for transforming keyword lists to SQL statements Libraries sql , databases , query	3	415	December 4, 2023
What is the right way to setup AshJsonApi? Ash Questions / Help json , phoenix , sql , ash-questions	3	541	October 23, 2023
Podcast: Thinking Elixir 166 - Filtering, ordering and pagination via Flop Blogs & Podcasts ecto , via-devtalk , sql , podcasts , podcasts-by-brainlid	0	419	August 29, 2023
Connect to SQL server with TCP protocol Questions / Help gen_tcp , sql , tcp , tds	2	384	June 14, 2023
Ecto: fetch all records not related in join table Questions / Help ecto , postgres , database , sql	2	471	May 22, 2023
Ecto Query to compare 2 tables on a string column and return the unmatched result Questions / Help sql , ecto_sql	5	768	January 21, 2023
Postgrex how to pack argument for Select IN Questions / Help sql , postgrex	4	631	July 9, 2022
Library to convert an SQL schema into an Ecto schema Questions / Help ecto , sql , ecto_sql	0	572	July 5, 2022
INSERT … SELECT in Ecto using Ecto.Query Questions / Help ecto , sql , postgresql	8	5756	September 12, 2021
Aggregate query counts with multiple where values Questions / Help ecto , sql	4	1091	August 31, 2021
Preloading top comments for posts in Ecto using window functions Questions / Help ecto , sql , mysql	3	1099	March 19, 2021
How to query on keys in an embeds_many Questions / Help ecto , sql , postgres	2	995	November 18, 2020
Ecto SQL query does not return the expected value Questions / Help ecto , sql , postgres , postgresql	9	1304	October 7, 2020
How we can Prevent SQL Injection in Phoenix framework? Questions / Help ecto , phoenix , security , sql	2	1213	September 14, 2020
Selecting values from multiple rows to use in group by Questions / Help ecto , sql	2	1520	August 22, 2020
How to apply SQL array aggregation function in Ecto Questions / Help lists , maps , sql , ecto-query , ecto_sql	3	4333	July 8, 2020
Cascade delete with many to many relationship Questions / Help ecto , sql	1	914	May 3, 2020
Ecto Fragment interpolating var in group_by and select Questions / Help ecto , sql	4	2039	February 27, 2020
Creating an SQL injection Questions / Help ecto , phoenix , sql	4	1238	December 9, 2019
How to maintain an auto increment field but per category Questions / Help sql , ecto	3	1863	November 3, 2019
Performing a find-or-create in Ecto? Questions / Help postgresql , sql , ecto	8	6968	September 7, 2019
How to use PostgreSQL's DISTINCT ON in Ecto Query Questions / Help postgresql , sql , ecto	11	10220	July 12, 2019
NoSQL vs OldSql General Prog (Archived) sql , nosql	5	995	June 18, 2019
Backend with pure elixir (direct SQL in DataBase) without frameworks possible? Questions / Help sql	19	3020	May 14, 2019
Postgres recursive CTE on single table Questions / Help postgresql , sql , ecto-query , postgres	9	3025	April 19, 2019