postgres-schema-builder
Simple postgres schema builder for Node.JS leveraging Typescript's type system to enable typesafe queries (by yss14)
pgtyped
pgTyped - Typesafe SQL in TypeScript (by adelsz)
SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
featured
postgres-schema-builder | pgtyped | |
---|---|---|
2 | 34 | |
13 | 2,822 | |
- | - | |
0.0 | 8.7 | |
about 1 year ago | 2 days ago | |
TypeScript | TypeScript | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
postgres-schema-builder
Posts with mentions or reviews of postgres-schema-builder.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-11-30.
-
Recommended type-safe npm package?
Hey there, I'm Nikolas from the Prisma team. We have a section about this in our docs: Should you use Prisma? where we explain when Prisma is a good use case for you and when other alternatives might be better. It sounds like you could look into tools like Slonik, pgtyped, Zapatos, postgres-schema-builder which are all great type-safe SQL libraries.
-
Any ORMs that don't use classes for entities?
Two years ago, I started publishing the code on GitHub (postgres-schema-builder, current version is 1.2.0-beta.3). The code has been in our production code for over 3 years now (and I'm also using it for several private side projects), but our team is currently working on a brand new library! The idea stays the same as for the postgres-schema-builder: You define your database schema and get the corresponding interface types derived from the schema (without code generation). Further, you can perform typesafe SQL queries against your defined schema. With the upcoming library, we plan to even allow more complex queries like joins, aggregations, database views, etc..., all typesafe, all functional API! I hope we are able to release a first beta version in about 1-2 months. I will keep you up to date!
pgtyped
Posts with mentions or reviews of pgtyped.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-24.
-
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
-
compile-time SQL validations and type generation in TypeScript & Node
Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?
-
Petrol: embedding a type-safe SQL API in OCaml using GADTs
I would instead rely on code generation like https://github.com/adelsz/pgtyped, because the embedded type-safe SQL will never fully cover all the features of vanilla SQL, for example Common Table Expression (CTE), window functions etc.
-
Deno 1.33: Deno 2 is coming
There's pgtyped, which I believe does almost the same as sqlc
https://github.com/adelsz/pgtyped
-
Kysely: TypeScript SQL Query Builder
For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?
-
Is postgresql-typed a good starting library for a production application?
Avoiding the cost of learning EDSL that many Haskell DB libraries provide, I found out that only postgresql-typed and postgresql-simple allow to write only raw SQL queries easily. As I extensively use pgtyped for production Node.js application, I am thinking about using postgresql-typed. While I could find many resources for postgresql-simple, the same cannot be said try for postgresql-typed.
-
This package is so underrated.
I would highly recommend trying out pgTyped if you want typesafe queries with postgres. It's fantastic!