{"repo":"com-lihaoyi/scalasql","free":true,"listed":false,"github":"https://github.com/com-lihaoyi/scalasql","clone":"git clone https://github.com/com-lihaoyi/scalasql.git","description":"Scala ORM to query SQL databases from Scala via concise, type-safe, and familiar case classes and collection operations. Connects to Postgres, MySql, H2, and Sqlite out of the box","language":"Scala","stars":259,"topics":["database","query-builder","scala","sql","h2","mysql","postgresql","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"ScalaSql ScalaSql is a Scala ORM library that allows type-safe low-boilerplate querying of SQL databases, using \"standard\" Scala collections operations running against typed Table descriptions. ScalaSql supports database connections to PostgreSQL, MySQL, Sqlite, MSSql and H2 databases. Support for additional databases can be easily added. ScalaSql is a relatively new library, so please try it out, but be aware you may hit bugs or missing features! Please open Discussions for any questions, file Issues for any bugs you hit, or send Pull Requests if you are able to investigate and fix them! Getting Started To get started with ScalaSql, add it to your build.mill file as follows: ScalaSql supports Scala =3.6.2 SimpleTable variant based on named tuples For Scala versions =3.7.0 supporting named tuples, an alternative way to define tables is supported. Add the following to your build.sc file as follows: And taking the example above, the only thing that needs to change is the following: And you now have the option to return named tuples from queries: Documentation ScalaSql Quickstart Examples: self-contained files showing how to set up ScalaSql to connect your Scala code to a variety of supported databases and perform simple DDL and SELECT / INSERT / UPDATE / DELETE operations: Postgres MySql Sqlite H2 Microsoft SQL Server HikariCP (and other connection pools) ScalaSql Tutorial: a structured walkthrough of how to use ScalaSql, connecting to a database and writing queries to SELECT /","default_branch":null,"files":null,"tree":[],"storefront":"/r/com-lihaoyi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/com-lihaoyi/scalasql/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."}