node-sql-template-strings
sql-compose
Our great sponsors
node-sql-template-strings | sql-compose | |
---|---|---|
6 | 2 | |
598 | 2 | |
- | - | |
0.0 | 4.1 | |
6 days ago | over 3 years ago | |
JavaScript | Clojure | |
ISC License | GNU General Public License v3.0 or later |
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
-
Write SQL Queries With Confidence (TypeScript + Postgres)
Ah, I see it. I'm assuming node-sql-template-strings or an equivalent?
-
I thought I knew what I was doing
There is also some other interesting use cases.
- DenoDB
-
Slonik: A PostgreSQL client with strict types, detailed logging, and assertions
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
sql-template-strings is a really simple and elegant solution for parameterized queries.
sql-compose
- Show HN: A tiny SQL query composer that scales infinitely
-
DenoDB
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.
What are some alternatives?
MySQL - A pure node.js JavaScript Client implementing the MySQL protocol.
trpc - 🧙♀️ Move Fast and Break Nothing. End-to-end typesafe APIs made easy.
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
denodb - MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
typed-knex - A TypeScript wrapper for Knex.js
JDBI - The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.
PostgreSQL - PostgreSQL client for node.js.
dedent - ⬅️ ES6 string tag that strips indentation from multi-line strings.
tsql - Transact-SQL template combinators.
postgres - Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare
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.