This is a package for the n8n workflow automation tool that integrates SQLite database operations. It allows users to perform SQL queries such as SELECT, INSERT, UPDATE, and DELETE within their workflows.
Features
Create Table
This feature allows users to create tables within their SQLite database by specifying table columns and data types using the n8n interface.
Insert
Enables users to insert data into an SQLite table. The node allows parameterized inputs to prevent SQL injection issues.
Select
Supports querying data from SQLite tables with the capability to specify columns and conditions, allowing for flexible data retrieval.
Simplified Result Set
Provides a simplified view of result sets with options to format and map data retrieved from the SQLite database.
Delete Table
Allows users to delete tables from the SQLite database, helping maintain the database structure by removing unnecessary tables.
Unlimited Public Packages
Access to an unlimited number of public packages, enabling users to utilize a vast array of open-source JavaScript projects.
Unlimited Private Packages
Allows users to seamlessly integrate unlimited private packages into their development workflow, ensuring maximum flexibility and privacy.
Package-based Permissions
Enables users to add collaborators to work on both public and private packages, facilitating teamwork and collaboration.
Unlimited public packages
Bring the best of open-source JavaScript development to your own projects.
Unlimited private packages
Seamlessly integrate public and private packages into your development cycle.
Package-based permissions
Add collaborators to work on your public and private packages together. Includes team-based management for easier collaboration.
Unlimited public packages and automatic security warnings
Provides unlimited access to public packages and automatic notifications about security issues in dependencies.
Unlimited private packages
Enables users to create unlimited private packages for personal or business use, keeping their projects secure and private.
Unlimited team-based management
Allows organizations to manage their projects with unlimited teams, streamlining collaboration and access control.
JavaScript Package Registry
Provides access to the npm Registry, a vast collection of JavaScript packages, allowing you to discover and use software packages to build applications efficiently.
CLI Tool
The npm command-line interface (CLI) allows you to manage packages from the terminal, simplifying the installation, versioning, and publishing of packages.
Private Packages
Offers features like private packages for npm Pro users, allowing you to host packages privately and control access within your team or organization.
n8n-nodes-shopify-paginator
A custom n8n node to handle pagination for Shopify API requests.
rckflr-n8n-sqlite-node
Custom n8n nodes for interacting with SQLite3 databases through SQL queries.
n8n-nodes-rckflr-sqlite
Custom n8n nodes for interacting with SQLite3 databases through SQL queries.
Package Manager for Node.js
npm acts as the package manager for Node.js, allowing developers to manage and share packages of JavaScript code efficiently.
npm Registry
A public collection of open-source packages for Node.js and front-end web apps, among others, which developers can access and use for their JavaScript projects.
Command Line Client
npm provides a command line interface for installing and publishing packages easily, making it a core tool for developers.
Custom Node Creation
This package helps you get started with building custom integrations for n8n, providing example nodes and dependencies to streamline the process.
Development Setup Guidance
Provides prerequisites and step-by-step instructions for setting up your development environment, including tools like git and npm.
Publishing and Version Control
Guides you through the process of creating a repository, modifying files, using linting tools, and publishing your custom node as an npm package, with comprehensive version control practices.
SQLite Node for n8n
Integrates SQLite database operations within the n8n workflow automation tool. It allows users to insert, query, and manage data within SQLite databases directly from n8n workflows.
Database Operations
Supports various operations like Create, Insert, Query, and Delete within SQLite databases, simplifying data manipulation and maintaining control over data directly from the n8n interface.
Compatibility and Ease of Use
Designed to be compatible with existing n8n setups. Offers straightforward installation and integration processes via npm, available for use in local or cloud-hosted n8n instances.