node-sql-template-strings vs dedent

node-sql-template-strings

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

Suggest topics

Source Code

Suggest alternative

Edit details

dedent

⬅️ ES6 string tag that strips indentation from multi-line strings. (by dmnd)

JavaScript dedent ES6 template-string Es2015

Source Code

Suggest alternative

Edit details

Our great sponsors

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

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

Our great sponsors

node-sql-template-strings		dedent
	Project
6	Mentions	3
598	Stars	866
-	Growth	-
0.0	Activity	6.8
7 days ago	Latest Commit	8 days ago
JavaScript	Language	TypeScript
ISC License	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.

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.

dedent

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

All JavaScript and TypeScript features of the last 3 years explained
11 projects | news.ycombinator.com | 9 Mar 2023

and so `dedent` would not strip any indentation. That is, `dedent` is meant to identify the maximal common leading indentation in the template as written by the developer, which should not depend on the values of the interpolands.
A stale GitHub issue on the dmnd/dedent repo has a real-world example where this matters and led to a subtle bug: https://github.com/dmnd/dedent/issues/22
I thought I knew what I was doing
4 projects | /r/programminghorror | 24 Jun 2021

There is also some other interesting use cases.

What are some alternatives?

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

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

core-js - Standard Library

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

javascript - JavaScript Style Guide

typed-knex - A TypeScript wrapper for Knex.js

graphql-tag - A JavaScript template literal tag that parses GraphQL queries

PostgreSQL - PostgreSQL client for node.js.

webpack - A bundler for javascript and friends. Packs many modules into a few bundled assets. Code Splitting allows for loading parts of the application on demand. Through "loaders", modules can be CommonJs, AMD, ES6 modules, CSS, Images, JSON, Coffeescript, LESS, ... and your custom stuff.

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

type-fest - A collection of essential TypeScript types

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

html-es6cape - :zap: - Escape HTML special characters (including `)