sqlite-plugin-red 0.0.3

Adding a tab to show and edit the structure of a sqlite database. Needs node-red-node-sqlite.

npm install sqlite-plugin-red

Adding a sidebar tab for Node-RED to show and edit sqlite database structures

Requirements

Requires the Node-RED node: node-red-node-sqlite.

Instructions

The UI will help you to visualize and create your sqlite database, all within Node-RED.

  • Select, create or delete your your sqlite database files in the first row.
  • Select, create, rename or delete your tables in the second row.
  • If a table is selected you can add, remove or change your sqlite table columns.
  • If done press the confirm button.

Screenshot of a the Sqlite Tab.

Notes

There is currently no input safeproof implemented, as sqlite will return an error if something is not correct. For example: Creating a autoincrement column without setting the column to INTEGER.

This will be planned in the future.

Developers

If you want to modify something inside the sqlite-plugin-red.html file, I recommend to use SIR.

With help of SIR you can handle the sqlite-plugin-red.svelte file in which the code is much cleaner and easier to handle.

Node Info

Version: 0.0.3
Updated 2 years, 11 months ago
License: MIT
Rating: 5.0 2

Actions

Rate:

Downloads

52 in the last week

Nodes

  • sqlite-plugin-red

Keywords

  • node-red
  • sqlite
  • database
  • db
  • sql

Maintainers