Overview

Backend Configuration

Xorq supports multiple execution engines (backends) for running your data and ML workloads. This section covers how to configure and use different backends.

Topics

Profiles - Secure connection management via environment variables
Environment Variables - Available configuration options
Supported Backends - Choose the right backend for your workload

Quick start

Connect to the default embedded backend:

import xorq.api as xo

con = xo.connect()

Connect to a specific backend:

# DuckDB
duckdb_con = xo.duckdb.connect()

# PostgreSQL
pg_con = xo.postgres.connect_env()

# GizmoSQL (DuckDB over Arrow Flight SQL)
gizmosql_con = xo.gizmosql.connect(
    host="localhost",
    user="user",
    password="password",
    port=31337,
    use_encryption=True,
    disable_certificate_verification=True,
)

# Pandas
pandas_con = xo.pandas.connect()