sql-compose vs trpc

sql-compose

A simple sql query composer for clojure. (by ludbek)

Suggest topics

Source Code

Suggest alternative

Edit details

trpc

🧙‍♀️ Move Fast and Break Nothing. End-to-end typesafe APIs made easy. (by trpc)

TypeScript API Nextjs Prisma Next React

Source Code

trpc.io

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

sql-compose		trpc
	Project
2	Mentions	35
2	Stars	32,672
-	Growth	2.7%
4.1	Activity	9.8
over 3 years ago	Latest Commit	3 days ago
Clojure	Language	TypeScript
GNU General Public License v3.0 or later	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.

sql-compose

Posts with mentions or reviews of sql-compose. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-06-17.

Show HN: A tiny SQL query composer that scales infinitely
1 project | news.ycombinator.com | 18 Jun 2021
DenoDB
15 projects | news.ycombinator.com | 17 Jun 2021

ORMs are unnecessary abstraction.
Check out https://github.com/ludbek/sql-compose
Tools like this are the future. It's so simple yet flexible enough to handle any complex queries.
It scales infinitely.

trpc

Posts with mentions or reviews of trpc. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-09-17.

Key differences between GraphQL and RESTful API
1 project | dev.to | 9 Nov 2023

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
3 projects | dev.to | 17 Sep 2023

tRPC + Cloudflare Workers Example
how to improve UX of checking changes in ONE file though git history
1 project | /r/github | 16 Sep 2023
trpc + nextjs app dir + fetchRequestHandler
1 project | /r/nextjs | 7 Sep 2023

Hi I'm working with trpc + nextjs app dir (unsupported by trpc currently) and trpc context
TRPC invalidation app directory
1 project | /r/nextjs | 21 Aug 2023

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
30 projects | news.ycombinator.com | 12 Aug 2023

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?
1 project | /r/nextjs | 14 Jun 2023

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.
16 projects | dev.to | 25 Apr 2023

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
28 projects | news.ycombinator.com | 13 Apr 2023

- https://github.com/trpc/trpc: End-to-end typesafe APIs made easy. Never write another API contract again.

What are some alternatives?

When comparing sql-compose and trpc you can also consider the following projects:

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 🚀

JDBI - The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

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]

typed-knex - A TypeScript wrapper for Knex.js

graphql-zeus - GraphQL client and GraphQL code generator with GraphQL autocomplete library generation ⚡⚡⚡ for browser,nodejs and react native ( apollo compatible )

tsql - Transact-SQL template combinators.

js-sqlate - A tiny tagged template string function library for JavaScript to write SQL safely. Works with Mapbox's SQLite3 library, Brian Carlson's PostgreSQL library and others.

MySQL - A pure node.js JavaScript Client implementing the MySQL protocol.

node-sql-template-strings - ES6 tagged template strings for prepared SQL statements 📋

strapi-mongo-next - NextJs frontend, Strapi backend API, and MongoDb. A full-stack sample business website styled with the latest Material-Ui.