typesafe-query-builder
postgres-schema-builder
typesafe-query-builder | postgres-schema-builder | |
---|---|---|
2 | 2 | |
26 | 13 | |
- | - | |
1.1 | 0.0 | |
6 months ago | about 1 year 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.
typesafe-query-builder
-
TypeORM - it's not what you think.
I'm using my own query builder in production with lots of succcess (easy to develop with, fast, flexible enough) but there are quite a few projects in that space that I have listed here. To me the most feature-complete and typesafe-first one seems to be mammoth.
-
Any ORMs that don't use classes for entities?
Maybe typesafe-query-builder is worth a look.
postgres-schema-builder
-
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!
What are some alternatives?
pgtyped - pgTyped - Typesafe SQL in TypeScript
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.
Knex - A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
typescript-runtime-type-benchmarks - 📊 Benchmark Comparison of Packages with Runtime Validation and TypeScript Support
kysely - A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely]
MikroORM - TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
musicshare - Self-hosted open-source music sharing platform from music lovers for music lovers, powered by NodeJS, PostgreSQL, GraphQL, and React.
benchmark - MikroORM vs TypeORM benchmark of CRUD operations on 10k entities
kysely - A type-safe typescript SQL query builder