tsql
trpc
tsql | trpc | |
---|---|---|
3 | 35 | |
12 | 32,748 | |
- | 1.3% | |
6.8 | 9.8 | |
8 months ago | 3 days ago | |
TypeScript | TypeScript | |
GNU General Public License v3.0 or later | 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.
tsql
-
Kysely: TypeScript SQL Query Builder
We use in prod variant of no 1. [0]. Why? Because:
* it's extremely lightweight (built on pure, functional combinators)
* it allows us to use more complex patterns ie. convention where every json field ends with Json which is automatically parsed; which, unlike datatype alone, allows us to create composable query to fetch arbitrarily nested graphs and promoting single [$] key ie. to return list of emails as `string[]` not `{ email: string }[]` with `select email as [$] from Users` etc.
* has convenience combinators for things like constructing where clauses from monodb like queries
* all usual queries like CRUD, exists etc. and some more complex ie. insertIgnore, merge1n etc has convenient api
We resort to runtime type assertions [1] which works well for this and all other i/o; runtime type assertions are necessary for cases when your running service is incorrectly attached to old or future remote schema (there are other protections against it but still happens).
[0] https://github.com/appliedblockchain/tsql
[1] https://github.com/appliedblockchain/assert-combinators
-
Objection to ORM Hatred
Exactly. I'm happy with tsql [0] - template based, with safe sanitation, helper renderers/combinators, used in production for several years, would recommend this approach.
[0] https://github.com/appliedblockchain/tsql
-
DenoDB
Personally I prefer functional combinators like interfaces [0]. Js/ts have tagged templates which enhances those type of interfaces a lot. It gives access to full set of functionality of underlying database, not just common denominator of all used. It allows arbitrary compositions etc.
[0] https://github.com/appliedblockchain/tsql/
trpc
-
Key differences between GraphQL and RESTful API
RESTful API: RESTful API does not have machine-readable metadata cacheable, and query validation is not available.(There are some libraraies tried to solve this issue like TRPC)
-
Implementing Authorization with Clerk in a tRPC app running on a Cloudflare Worker
tRPC + Cloudflare Workers Example
- how to improve UX of checking changes in ONE file though git history
-
trpc + nextjs app dir + fetchRequestHandler
Hi I'm working with trpc + nextjs app dir (unsupported by trpc currently) and trpc context
-
TRPC invalidation app directory
I'm using TRPC with Next13 App directory and I can't manage to invalidate queries. Seing from their example there is a way to do it https://github.com/trpc/trpc/blob/96956e790e6862bcc6dcc4622edc8e48da0adbcb/examples/.experimental/next-app-dir/src/app/post-example/page.tsx
-
tRPC โ Move Fast and Break Nothing. End-to-end typesafe APIs made easy
It is. But RSC make many library authors and maintainers question whether their library is still needed in a RSC world and if so how they can support it. Same story with tRPC https://github.com/trpc/trpc/issues/3297
-
trpc VS prim-rpc - a user suggested alternative
2 projects | 23 Jul 2023
-
T3\tRPC - How do you change the cache?
Also, while trying to debug this, and this is way outside my league but I noticed this: Is there possibly an error in the Updater TS-definitions in https://github.com/trpc/trpc/blob/main/packages/react-query/src/shared/proxy/utilsProxy.ts at lines 155+156 & 167+168 because they are duplicate-lines and seems to be where my issues are coming from.
-
SPARTAN. Type-safe Angular full-stack development powered by Analog.
Unfortunately, tRPC and NestJs do not play well together by default, and the tRPC team does not intend to integrate the two through an official plugin for the time being.
-
GitHub Accelerator: our first cohort and what's next
- https://github.com/trpc/trpc: End-to-end typesafe APIs made easy. Never write another API contract again.
What are some alternatives?
denodb - MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Nest - A progressive Node.js framework for building efficient, scalable, and enterprise-grade server-side applications with TypeScript/JavaScript ๐
postgres - Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare
domain-functions - Decouple your business logic from your framework. With first-class type inference from end to end. [Moved to: https://github.com/seasonedcc/domain-functions]
MySQL - A pure node.js JavaScript Client implementing the MySQL protocol.
graphql-zeus - GraphQL client and GraphQL code generator with GraphQL autocomplete library generation โกโกโก for browser,nodejs and react native ( apollo compatible )
PostgreSQL - PostgreSQL client for node.js.
JDBI - The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.
sql-compose - A simple sql query composer for clojure.
strapi-mongo-next - NextJs frontend, Strapi backend API, and MongoDb. A full-stack sample business website styled with the latest Material-Ui.