Skip to content

Quick Start

Connect to Tibero in 5 minutes using pytibero.

Prerequisites

  • A reachable Tibero server
  • Python 3.9+
  • One backend path:
  • pyodbc + a Tibero ODBC driver, or
  • Tibero native tbcli library for the tbcli backend

Backend dependencies are external

pip install pytibero installs the Python package, but system-level ODBC or native Tibero client libraries still must be installed and discoverable.

1) Install

pip install pytibero

2) Pick a connection mode

Mode A: Direct driver + host/port (default pyodbc backend)

import pytibero

conn = pytibero.connect(
    host="localhost",
    port=8629,
    database="test",
    user="tibero",
    password="tmax",
    driver="Tibero 7 ODBC Driver",
)

Mode B: DSN (pyodbc backend)

import pytibero

conn = pytibero.connect(
    dsn="TIBERO_TEST",
    user="tibero",
    password="tmax",
)

Mode C: Native tbcli backend

import pytibero

conn = pytibero.connect(
    host="localhost",
    port=8629,
    database="test",
    user="tibero",
    password="tmax",
    backend="tbcli",
    tbcli_library="/opt/tibero7/client/lib/libtbcli.so",  # optional if discoverable
)

3) Run a query

import pytibero

with pytibero.connect(
    host="localhost",
    port=8629,
    database="test",
    user="tibero",
    password="tmax",
) as conn:
    with conn.cursor() as cur:
        cur.execute("SELECT 1 FROM dual")
        rows = cur.fetchall()
        print(rows)

Quickstart workflow

mermaid flowchart TD A[Install pytibero] --> B{Choose backend} B -->|pyodbc| C[Configure Tibero ODBC driver or DSN] B -->|tbcli| D[Install or locate libtbcli] C --> E[Call pytibero.connect] D --> E E --> F[Create cursor] F --> G[Execute SQL] G --> H[Fetch rows] H --> I[Commit or rollback and close]

Next steps