{"repo":"elixir-dbvisor/sql","free":true,"listed":false,"github":"https://github.com/elixir-dbvisor/sql","clone":"git clone https://github.com/elixir-dbvisor/sql.git","description":"SQL provides state-of-the-art, high-performance SQL integration for Elixir, built to handle extreme concurrency with unmatched expressiveness and ergonomic query composition. Write safe, composable, parameterized queries directly, without translating to Ecto or any ORM.","language":"Elixir","stars":265,"topics":["ecto","elixir-lang","elixir-phoenix","mysql","postgresql","sql","sqlite","tds"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"SQL SQL provides state-of-the-art, high-performance SQL integration for Elixir , built to handle extreme concurrency with unmatched expressiveness and ergonomic query composition . Write safe, composable, parameterized queries directly, without translating to Ecto or any ORM. SQL is a foreign language integration , letting you write SQL naturally while Elixir handles transactions, concurrency, and query planning for you. Unlike typical ORMs, SQL scales diagonally on the BEAM , fully leveraging multicore hardware under load. Highlights - Extreme Concurrency: Hundreds of processes can execute queries simultaneously without blocking pools. - Diagonal Scaling: Utilizes BEAM concurrency to maximize throughput, far beyond traditional connection pool limits. - Composable Queries: No need to remember SELECT vs FROM order—queries are fully composable via SQL . - Safe Interpolation: Automatically parameterized queries; no need to manually handle fragments or ? . - SOTA Performance Across Languages: Benchmarks show SQL outperforming Ecto by orders of magnitude under heavy load. - Ergonomic & Expressive: Intuitive syntax for queries, transactions, and mapping result sets. - Streaming Large Datasets: Efficiently stream millions of rows without blocking memory or reducing concurrency. Examples Transactions Transactions automatically handle nested savepoints , rollback, and commit logic, even under extreme concurrency. Mapping Results For custom mapping of rows: Streaming Pool configuration","default_branch":null,"files":null,"tree":[],"storefront":"/r/elixir-dbvisor","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/elixir-dbvisor/sql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}