pgtyped
slonik-tools
Our great sponsors
pgtyped | slonik-tools | |
---|---|---|
34 | 3 | |
2,762 | 146 | |
- | - | |
8.7 | 9.1 | |
3 days ago | 5 days ago | |
TypeScript | TypeScript | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgtyped
-
Type-Safe Printf() in TypeScript
There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql
There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped
To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build
-
ORMs are nice but they are the wrong abstraction
ORMs suck, but raw SQL embedded in your code sucks too.
This might be good time to plug my TypeScript non-ORM: https://jawj.github.io/zapatos/.
I should say I also like what I've seen of https://kysely.dev/ and https://pgtyped.dev/.
-
An effective way to build a heavy CRUD Rest API?
Thank you for suggestions they helped me finding what I was looking for. I will either pick kysely or https://pgtyped.dev/, but first I will do some tests. Thanks!
-
PostgresJs: The Fastest full featured PostgreSQL client for Node.js and Deno
Perhaps not as featured as OP’s but I’ve found https://pgtyped.dev/ useful. Queries are written as SQL files, and pgtyped creates typed functions you call with query parameters.
-
compile-time SQL validations and type generation in TypeScript & Node
Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?
-
Deno 1.33: Deno 2 is coming
There's pgtyped, which I believe does almost the same as sqlc
-
Kysely: TypeScript SQL Query Builder
For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?
You might also want to consider pgTyped (https://github.com/adelsz/pgtyped). It's supposed to make SQL and TS work together. I haven't gotten around to using it yet but I hear good things.
-
This package is so underrated.
I would highly recommend trying out pgTyped if you want typesafe queries with postgres. It's fantastic!
slonik-tools
-
Does Anyone Know A Good ORM To Use For An Existing Complex Postgres Database
This is cool. It is very similar to what https://github.com/mmkal/slonik-tools/tree/master/packages/typegen
-
NextJS full-stack app with relational DB
Prisma isn't alone with this approach. pgTyped and slonik together with slonik-tools give you the same "zero-cost" type safety for your database queries. The main difference to Prisma is that they only support type safety for raw SQL queries, which works great if that's your preferred way of interacting with your database.
-
What package do you guys use for postgres in node js?
Lately though I've been using slonik (and @slonik/migrator) for lighter setups -- it very much gets out of your way so if you want to do some simple queries really quickly and don't want any ceremony it's a nice light option.
What are some alternatives?
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
kysely - A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely]
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
typesafe-query-builder - Generate SQL queries leveraging type inference and Postgres Json functions
kysely - A type-safe typescript SQL query builder
ts-sql - A SQL database implemented purely in TypeScript type annotations.
kanel - Generate Typescript types from Postgres
pg-to-ts - Generate TypeScript interface definitions from your Postgres schema
prisma-examples - 🚀 Ready-to-run Prisma example projects
node-sql-template-strings - ES6 tagged template strings for prepared SQL statements đź“‹
typescript-runtime-type-benchmarks - đź“Š Benchmark Comparison of Packages with Runtime Validation and TypeScript Support