{"repo":"multipliedtwice/prisma-to-sql","free":true,"listed":false,"github":"https://github.com/multipliedtwice/prisma-to-sql","clone":"git clone https://github.com/multipliedtwice/prisma-to-sql.git","description":"Prisma read operations at raw sql speed","language":"TypeScript","stars":22,"topics":["nodejs","performance","postgresql","prisma","sql","sqlite","typescript","boost"],"license":null,"category":"databases-storage","readme_excerpt":"prisma-sql Prerender Prisma queries to SQL and execute them directly via postgres.js or better-sqlite3 . Same Prisma API. Same Prisma types. Lower read overhead. What it does prisma-sql accelerates Prisma read queries by skipping Prisma's read execution path and running generated SQL directly through a database-native client. It keeps Prisma Client for: - schema and migrations - generated types - writes - fallback for unsupported cases It accelerates: - findMany - findFirst - findUnique - count - aggregate - groupBy - PostgreSQL $batch Why use it Prisma's DX is excellent, but read queries still pay runtime overhead for query-engine planning, validation, transformation, and result mapping. prisma-sql moves that work out of the hot path: - builds SQL from Prisma-style query args - can prebake hot queries at generate time - executes via postgres.js or better-sqlite3 - maps results back to Prisma-like shapes The goal is simple: - keep Prisma's developer experience - cut read-path overhead - stay compatible with existing Prisma code Installation PostgreSQL SQLite Quick start 1) Add the generator 2) Generate This generates: planner.generated.ts contains relation and model statistics used by the strategy planner. 3) Extend Prisma PostgreSQL SQLite With existing Prisma extensions Apply speedExtension last so it sees the final query surface. Supported queries Accelerated - findMany - findFirst - findUnique - count - aggregate - groupBy - $batch for PostgreSQL Not accelerated These con","default_branch":null,"files":null,"tree":[],"storefront":"/r/multipliedtwice","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/multipliedtwice/prisma-to-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."}