{"repo":"pigoz/effect-sql","free":true,"listed":false,"github":"https://github.com/pigoz/effect-sql","clone":"git clone https://github.com/pigoz/effect-sql.git","description":"Relational Databases with Effect!","language":"TypeScript","stars":45,"topics":["postgresql","typescript","database","orm","query-builder","mysql","sql","sqlite"],"license":null,"category":"databases-storage","readme_excerpt":"⚠️ This is dead Use the official @effect/sql package instead . https://www.npmjs.com/package/@effect/sql effect-sql Relational Databases with Effect! This project aims to become a one stop shop to deal with relational databases in Effect. It's composed of several decoupled pieces, from which you should be able to pick and choose whatever you want to build a \"database prelude\" that best fits your application. - effect-sql/query is a wrapper over Node database drivers. It provides an Effectful interface to operate with raw SQL strings and little overhead. A spiritual alternative to effect-pg , effect-mysql , and such. It includes: - Layer to manage the ConnectionPool using Effect's Pool - Query operators with tagged errors in the failure channel - DSL for nested transactions (using savepoints!) - ( Doing ): Driver based abstraction to support multiple database engines (focusing on getting PostgreSQL🐘 right initially) - ( Planned ): Non pooled connections (i.e. PlanetScale) - ( Planned ): Improved support for sandboxed database drivers - ( Planned ): Multiple connection strings for HA - ( Optional ) effect-sql/schema : TypeScript-first schema declaration based on Drizzle. Features: - Infer Kysely database using effect-sql/schema/kysely . - ( Planned ): Derive @effect/schema types - ( Planned ): Factory system with faker or fast check - ( Optional ) effect-sql/builders/ : Query builders to create typesafe queries and to execute them. They are built on top of effect-sql/query - K","default_branch":null,"files":null,"tree":[],"storefront":"/r/pigoz","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pigoz/effect-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."}