Security News
The Unpaid Backbone of Open Source: Solo Maintainers Face Increasing Security Demands
Solo open source maintainers face burnout and security challenges, with 60% unpaid and 60% considering quitting.
sql-escape-string
Advanced tools
Simple SQL string escape.
const escapeString = require('sql-string-escape')
const sqlString = "Sup'er"
console.log(escapeString(sqlString)) // => Sup''er
npm install sql-escape-string
Original implementation from sqlstring with the added option of supporting or not supporting backslash.
Escapes the given string to protect against SQL injection attacks.
By default it assumes that backslashes are not supported as they are not part of the standard SQL spec. Quoting from the SQLlite web site:
C-style escapes using the backslash character are not supported because they are not standard SQL.
This means three things:
''
instead of \'
and double quotes via ""
instead of \"
'backslash: \\'
.It is recommended to set the backslashSupported
option true
if your SQL
engine supports it. In that case backslash sequences are escaped and single
and double quotes are escaped via a backslash, i.e. '\''
.
Parameters
val
String the original string to be used in a SQL query$0
Object opts
$0.backslashSupported
Boolean? if true
backslashes are supported (optional, default false
)opts
Returns String the original string escaped and safe to use
MIT
FAQs
Simple SQL string escape.
The npm package sql-escape-string receives a total of 30,202 weekly downloads. As such, sql-escape-string popularity was classified as popular.
We found that sql-escape-string demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Solo open source maintainers face burnout and security challenges, with 60% unpaid and 60% considering quitting.
Security News
License exceptions modify the terms of open source licenses, impacting how software can be used, modified, and distributed. Developers should be aware of the legal implications of these exceptions.
Security News
A developer is accusing Tencent of violating the GPL by modifying a Python utility and changing its license to BSD, highlighting the importance of copyleft compliance.