@sdalu/db 0.1.1
Provide basic database interaction.
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