node-sql-template-strings vs pg-extra

node-sql-template-strings

ES6 tagged template strings for prepared SQL statements 📋 (by felixfbecker)

Suggest topics

Source Code

Suggest alternative

Edit details

pg-extra

🐘 some helpful extensions for node-postgres (by danneu)

Postgres Node

DISCONTINUED

Suggest alternative

Edit details

Our great sponsors

SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App

InfluxDB - Power Real-Time Data Analytics at Scale

WorkOS - The modern identity platform for B2B SaaS

Our great sponsors

node-sql-template-strings		pg-extra
	Project
6	Mentions	1
600	Stars	11
-	Growth	-
0.0	Activity	0.0
11 days ago	Latest Commit	about 2 years ago
JavaScript	Language	JavaScript
ISC License	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.

node-sql-template-strings

Posts with mentions or reviews of node-sql-template-strings. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-09-11.

Write SQL Queries With Confidence (TypeScript + Postgres)
2 projects | /r/javascript | 11 Sep 2022

Ah, I see it. I'm assuming node-sql-template-strings or an equivalent?
I thought I knew what I was doing
4 projects | /r/programminghorror | 24 Jun 2021

There is also some other interesting use cases.
DenoDB
15 projects | news.ycombinator.com | 17 Jun 2021
Slonik: A PostgreSQL client with strict types, detailed logging, and assertions
8 projects | news.ycombinator.com | 10 Mar 2021

Any reason you chose that over node-sql-template-strings [1], which looks very similar?
[1] https://github.com/felixfbecker/node-sql-template-strings
How do I prevent SQL injection in this function? I am using pg-promise
5 projects | /r/node | 27 Dec 2020

sql-template-strings is a really simple and elegant solution for parameterized queries.

pg-extra

Posts with mentions or reviews of pg-extra. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-03-10.

Slonik: A PostgreSQL client with strict types, detailed logging, and assertions
8 projects | news.ycombinator.com | 10 Mar 2021

The template tag solution is cute but really dangerous if you can accidentally leave off the `SQL` tag and the query still works.
Here's a solution that goes the long route of wrapping node-postgres' classes to ensure that you can never accidentally pass a basic string into query(): https://github.com/danneu/pg-extra/blob/be0e1a9fd513296e9bed...

What are some alternatives?

When comparing node-sql-template-strings and pg-extra you can also consider the following projects:

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

pgtyped - pgTyped - Typesafe SQL in TypeScript

slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

typed-knex - A TypeScript wrapper for Knex.js

PostgreSQL - PostgreSQL client for node.js.

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.

dedent - ⬅️ ES6 string tag that strips indentation from multi-line strings.

postgres - Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare

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