@sdalu/db v0.1.1

DB

Provide basic interraction with databases.

As it relies on the knex framework to perform database access, it is protected from SQL injection, that is not the case for the official mysql node.

Supported databases: MySQL, MariaDB, PostgreSQL

Indicated dependencies are Node RED >= 3 and NodeJS >= 20, but it is certainly working with other versions.

db insert

Insert data into a database table.

db query

Perform SQL query using knex.raw