musicshare VS postgres-schema-builder

The key feature of both postgres-schema-builder and our new library is the database schema definition and the derived typesafe queries. You define your whole (table) schema in typescript (example can be seen here) and for each Table you automatically receive a derived typescript type which reflects the correct column names and data types. You also get typesafe queries, like inserts, updates, selects, etc...

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.

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!