Component Libraries • Project Templates
Docs • Install • Tutorials • Developer Guides • Contribute • Blog • Discord

Xircuits Component Library for SQLite – Simplify database operations within your workflows.

---

Xircuits Component Library for SQLite

This library enables seamless integration of SQLite database operations into Xircuits workflows. It supports tasks like database connection management, executing SQL queries, and retrieving or manipulating data.

Table of Contents

• Preview
• Prerequisites
• Main Xircuits Components
• Try the Examples
• Installation

Preview

The Example:

The Result:

Prerequisites

Before you begin, you will need the following:

1. Python3.9+.
2. Xircuits.

Main Xircuits Components

SqliteOpenDB Component:

Establishes a connection to the SQLite database file, making it accessible for query execution.

SqliteFetchOne Component:

Executes a query and retrieves a single row from the database result set as a dictionary.

SqliteFetchAll Component:

Executes a query and retrieves all rows from the database result set, returning them as a list of dictionaries.

SqliteWithTransaction Component:

Executes multiple SQLite operations within a transaction, ensuring all operations are committed or rolled back.

SqliteExecute Component:

Executes a single SQL query, with optional arguments, on the connected SQLite database.

SqliteExecuteScript Component:

Runs an SQL script from a file on the SQLite database, enabling batch query execution.

Try the Examples

We've provided an example workflow to help you get started with the SQLite component library. Give it a try and see how you can interact with an SQLite database in a Xircuits workflow.

Sqlite Sample

This example demonstrates basic database operations, including creating a table, inserting records, and fetching data from the SQLite database.

Installation

To install the SQLite component library, you can use the component library interface or the CLI:

xircuits install sqlite

Or you can install it manually by cloning and setting up the library:

# base Xircuits directory
git clone https://github.com/XpressAI/xai-sqlite xai_components/xai_sqlite