{"repo":"karimagnusson/slinq","free":true,"listed":false,"github":"https://github.com/karimagnusson/slinq","clone":"git clone https://github.com/karimagnusson/slinq.git","description":"A PostgreSQL query builder for Scala that mirrors SQL structure directly in code","language":"Scala","stars":11,"topics":["database","postgresql","query-builder","scala","scala3","type-safe","zio","zio2"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Slinq A PostgreSQL query builder for Scala that mirrors SQL structure directly in code. Write queries you can read Let the compiler test them Let AI help you write them Documentation · ZIO HTTP Demo · http4s Demo · Play Demo Installation Slinq is available for Scala 3 via GitHub Packages. 1. Add the resolver to build.sbt : 2. Add credentials (create /.sbt/1.0/github.sbt ): Set GITHUB TOKEN environment variable with a token that has read:packages scope. 3. Add the dependency: Why Slinq? Most query builders abstract SQL behind collection-like APIs. Slinq takes the opposite approach: your Scala code reads like the SQL it generates. This makes complex queries readable and the API intuitive - you already know SQL. Modules Module Effect Type Streaming Use With -------- ------------ ----------- ---------- slinq-pg-zio ZIO ZIO Streams ZIO 2 applications slinq-pg-ec Future — Akka, Pekko, Play slinq-pg-pekko Future Pekko Streams (Source/Sink) Apache Pekko slinq-pg-typelevel IO fs2 (Stream/Pipe) Cats Effect 3 / http4s For Play Framework integration, see slinq-play. Features - Native ZIO integration as a layer - Cats Effect 3 and fs2 streaming support - Pekko Streams support (Source/Sink) - Full JSONB support - query, update, and return rows as JSON - Array field operations - Subqueries in WHERE clauses and SELECT columns - Streaming to and from the database - Statement caching for JDBC-level performance - Transactions for bulk and mixed operations - Type-safe throughout - no wildcard ty","default_branch":null,"files":null,"tree":[],"storefront":"/r/karimagnusson","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/karimagnusson/slinq/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."}