postgres-schema-builder
Simple postgres schema builder for Node.JS leveraging Typescript's type system to enable typesafe queries (by yss14)
kysely
A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely] (by koskimas)
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 | kysely | |
|---|---|---|
| 2 | 42 | |
| 13 | 4,444 | |
| - | - | |
| 0.0 | 9.5 | |
| about 1 year ago | about 1 year 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!
kysely
Posts with mentions or reviews of kysely.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-23.
-
I made a Twitter clone using Deno and Fresh
Did you check https://github.com/koskimas/kysely ? It was great when I used it. It has great TS support.
- Full-Stack TypeScript with tRPC and React
- Kysely
-
Type-safe S3 Select queries with Kysely
That’s where Kysely comes to the rescue: Kysely is a type-safe and devX-friendly typescript SQL query builder. It was designed to work with PostgreSQL and MySQL, but it exposes a few classes that can let us write queries without being connected to an actual relational database.
- Vue and trpc?
-
Announcing a new TypeScript ORM
prisma (mentioned in the article), zapatos, pgtyped and kysely are the most popular currently I think.
switch between a limited interface and a query builder (MikroORM, TypeORM). This feels like using two different libraries, switching between two different sets of limitations. Kysely is a nice query builder with good TS support, but MikroORM is using Knex instead so you're losing TS, and TypeORM has a custom query builder, less user-friendly than Knex.
-
Which ORM do you prefer with nodejs/Typescript project and why ?
I'd love to see Kysely as an option.
-
You might not need an ORM
Kysely[1] and zapatos[2] are excellent solutions for type-safe typescript query builders. It’s hard to go back to the days of spending 20-30% of your time in the object mapping layer.
[1] https://github.com/koskimas/kysely
-
Simple CQRS in NodeJS with Typescript
Querying the database (PostgreSQL) should not be ground breaking. Personally I like to have full type-safety so we can easily catch bugs during the development time without introducing any tests that are just testing the data type from our datastore to match the data type our API expects. I like to go database schema first, which means that we generate types from the database schema and work with those. Any change to the schema of the database is made with SQL migrations and after that, the typescript types are regenerated. Another approach is to use a code-first tool like TypeORM or Prisma. However in my experience such tools often produce not efficient SQL queries and are less easy to extend. In my projects I use library kysely (https://github.com/koskimas/kysely) with kysely-codegen (https://github.com/RobinBlomberg/kysely-codegen) to have a full type-safe SQL builder.