ADVICE WANTED - Typescript PostgreSQL without ORM

1. kysely

   1 42 4,444 9.5 TypeScript

   Discontinued A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely] (by koskimas)

   

   I dislike ORMs and have been using Kysely https://github.com/koskimas/kysely and https://github.com/RobinBlomberg/kysely-codegen for a small project and so far I love it. It's a mapper/query builder that is equivalent to Dapper in C# (without the query builder) but with the power of typescript's type system to enforce proper queries. You can also bypass something with the sql to write raw SQL.

2. Sevalla

   sevalla.com featured

   Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!

   

3. kanel

   2 11 1,038 8.6 TypeScript

   Generate Typescript types from Postgres

   

   I have so far found: - kanel https://github.com/kristiandupont/kanel - and pg-to-ts https://github.com/danvk/pg-to-ts

4. pg-to-ts

   3 2 117 3.3 TypeScript

   Generate TypeScript interface definitions from your Postgres schema

   

   I have so far found: - kanel https://github.com/kristiandupont/kanel - and pg-to-ts https://github.com/danvk/pg-to-ts

5. SQLDelight

   4 33 6,570 9.2 Kotlin

   SQLDelight - Generates typesafe Kotlin APIs from SQL

   

   Sounds like you want what SQLDelite offers, but for TypeScript. SQLDelite is only for Kotlin and SQLite though.

6. kysely-codegen

   5 9 1,047 8.9 TypeScript

   Generate Kysely type definitions from your database.

   

   I dislike ORMs and have been using Kysely https://github.com/koskimas/kysely and https://github.com/RobinBlomberg/kysely-codegen for a small project and so far I love it. It's a mapper/query builder that is equivalent to Dapper in C# (without the query builder) but with the power of typescript's type system to enforce proper queries. You can also bypass something with the sql to write raw SQL.

7. slonik

   6 74 4,810 9.0 TypeScript

   A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

   

   I don’t think it offers codegen for types but slonik is worth checking out given what you’re interested in.

Suggest a related project