Skip to main content

SQLite

Work with SQLite databases for local data storage, querying, and management.

Overview​

The SQLite package provides database connectivity for SQLite, a lightweight file-based database. Use it when you need local data storage, querying, or when you need a simple database without server infrastructure.

Key Features​

  • Query Execution - Run SELECT queries and get results
  • Data Modification - INSERT, UPDATE, DELETE operations
  • Database Creation - Create databases and tables
  • Transactions - Manage database transactions
  • Export - Export data from database

Available Nodes​

  • Connect - Open a SQLite database file
  • Disconnect - Close database connection
  • Query - Execute SELECT query and return results
  • Non Query - Execute INSERT, UPDATE, DELETE statements
  • Insert - Insert data into a table
  • Create - Create a new table
  • Start - Begin a database transaction
  • Commit - Commit the current transaction
  • Export - Export database data

When to Use This Package​

  • Local Storage: Store automation data locally
  • Offline Processing: Work without network database
  • Data Caching: Cache data for performance
  • Lightweight Database: Simple database needs
  • Portable Data: Database in a single file

Typical Workflow​

  1. Connect to database file (creates if not exists)
  2. Create tables if needed
  3. Query to retrieve data
  4. Insert or Non Query to modify data
  5. Disconnect when finished

Use Cases​

  • Store automation logs locally
  • Cache API responses for reuse
  • Maintain local lookup tables
  • Track processed items
  • Create portable data files