safeql
node-sql-template-strings
Our great sponsors
| safeql | node-sql-template-strings | |
|---|---|---|
| 4 | 6 | |
| 799 | 576 | |
| 2.4% | - | |
| 10.0 | 0.0 | |
| 10 days ago | 2 days ago | |
| TypeScript | JavaScript | |
| MIT License | ISC 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.
safeql
-
Write SQL Queries With Confidence (TypeScript + Postgres)
Be sure to follow this issue if you're interested - https://github.com/ts-safeql/safeql/issues/14
SafeQL is currently in its very early stages, but we can make it better with the community's help! If you have any ideas/improvements/bugs to share, be sure to file an issue in our GitHub repository.
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 pitfalls that you encountered?
I'm trying to decide between this, or writing my own helpers around https://github.com/felixfbecker/node-sql-template-strings.
Also, have you found anything the solves typechecking of embedded expressions inside the SQL template?
For example, Webstorm will help you autocomplete your SQL, but you can still type:
SELECT * FROM foo WHERE barInt = ${bazStr}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.
What are some alternatives?
MySQL - A pure node.js JavaScript Client implementing the MySQL protocol.
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.
trpc - 🧙♀️ Move Fast and Break Nothing. End-to-end typesafe APIs made easy.
dedent - ⬅️ ES6 string tag that strips indentation from multi-line strings.
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.
pgtyped - pgTyped - Typesafe SQL in TypeScript
postgres - Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno
pg-promise - PostgreSQL interface for Node.js
denodb - MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
JDBI - jdbi is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integration