Topics tagged sql

Topic	Replies	Views	Activity
Inferring & casting param types for raw SQL Questions / Help ecto , sql , ecto_sql	9	71	September 4, 2025
SQL - Brings an extensible SQL parser and sigil to Elixir, confidently write SQL with automatic parameterized queries. Libraries ecto , phoenix , sql , postgresql , mysql , mariadb , ecto_sql , tds	30	1702	August 23, 2025
Drops.Relation - High-Level Relation Abstraction on top of Ecto Libraries ecto , sql , postgresql , sqlite3 , ecto_sql	0	126	July 31, 2025
How exactly an Ecto stream works? Questions / Help ecto , sql , ecto-query , stream	4	170	May 14, 2025
Postgrex error with sql library: message: "syntax error at or near \"$0\"" Questions / Help sql , postgrex	26	270	April 19, 2025
How to partially match a string in ETS' match specs? Questions / Help mnesia , ets , sql , match-spec	3	3522	February 24, 2025
Google's SQL dialect added a `\|>` pipe operator Chat / Discussions syntax , sql	7	256	February 14, 2025
How to select virtual field from a CTE Questions / Help ecto , phoenix , sql	3	115	October 18, 2024
Elixir + Functional Programming in 9-12 High School Livebook Forum ecto , functional-programming , phoenix , sql , livebook-questions	6	226	September 28, 2024
SQLToy in Elixir Other Resources sql	0	205	September 9, 2024
SQL structure for many, different child entities Questions / Help sql , postgresql	25	3218	June 20, 2024
Inserting to Tables with Foreign Key Mappings (strategy suggestions) Questions / Help ecto , sql , ecto_sql	0	146	March 30, 2024
ExtractQueryParams - A simple elixir package for transforming keyword lists to SQL statements Libraries databases , sql , query	3	419	December 4, 2023
What is the right way to setup AshJsonApi? Ash Questions / Help phoenix , sql , json , ash-questions	3	633	October 23, 2023
Podcast: Thinking Elixir 166 - Filtering, ordering and pagination via Flop Blogs & Podcasts ecto , sql , podcasts , via-devtalk , podcasts-by-brainlid	0	435	August 29, 2023
Connect to SQL server with TCP protocol Questions / Help sql , tcp , gen_tcp , tds	2	404	June 14, 2023
Ecto: fetch all records not related in join table Questions / Help ecto , sql , postgres , database	2	493	May 22, 2023
Ecto Query to compare 2 tables on a string column and return the unmatched result Questions / Help sql , ecto_sql	5	793	January 21, 2023
Postgrex how to pack argument for Select IN Questions / Help sql , postgrex	4	643	July 9, 2022
Library to convert an SQL schema into an Ecto schema Questions / Help ecto , sql , ecto_sql	0	581	July 5, 2022
INSERT … SELECT in Ecto using Ecto.Query Questions / Help ecto , sql , postgresql	8	6039	September 12, 2021
Aggregate query counts with multiple where values Questions / Help ecto , sql	4	1104	August 31, 2021
Preloading top comments for posts in Ecto using window functions Questions / Help ecto , sql , mysql	3	1112	March 19, 2021
How to query on keys in an embeds_many Questions / Help ecto , sql , postgres	2	1018	November 18, 2020
Ecto SQL query does not return the expected value Questions / Help ecto , sql , postgres , postgresql	9	1326	October 7, 2020
How we can Prevent SQL Injection in Phoenix framework? Questions / Help ecto , security , phoenix , sql	2	1234	September 14, 2020
Selecting values from multiple rows to use in group by Questions / Help ecto , sql	2	1590	August 22, 2020
How to apply SQL array aggregation function in Ecto Questions / Help lists , maps , sql , ecto-query , ecto_sql	3	4609	July 8, 2020
Cascade delete with many to many relationship Questions / Help ecto , sql	1	926	May 3, 2020
Ecto Fragment interpolating var in group_by and select Questions / Help ecto , sql	4	2126	February 27, 2020