Fundamentals¶
Core database patterns using pycubrid (DB-API 2.0) and SQLAlchemy ORM.
Start here if you're new to CUBRID + Python.
Sections¶
| Section | Description | Driver |
|---|---|---|
| connect/ | Basic connection, metadata, cursor usage | pycubrid |
| crud/ | Create, Read, Update, Delete operations | pycubrid |
| transactions/ | Commit, rollback, isolation levels | pycubrid |
| parameterized-queries/ | Parameterized queries for safety and performance | pycubrid |
| error-handling/ | Connection failures, constraint violations, timeouts | pycubrid |
| lob-handling/ | Large Object (BLOB/CLOB) operations | pycubrid |
| orm-basics/ | SQLAlchemy engine, Core, ORM, relationships, reflection | SQLAlchemy |
| async/ | Async I/O with pycubrid.aio and SQLAlchemy async engine | asyncio |
| alembic/ | Programmatic Alembic migrations with CubridImpl | Alembic |
| json/ | Native JSON column CRUD | pycubrid |
| isolation-levels/ | 6 CUBRID isolation levels, dirty-read demo | pycubrid |
Prerequisites¶
# Start CUBRID via Docker
docker compose up -d
# Install Python driver
pip install pycubrid
# (Optional) Install SQLAlchemy dialect
pip install sqlalchemy-cubrid
Connection Info¶
| Setting | Value |
|---|---|
| Host | localhost |
| Port | 33000 |
| Database | testdb |
| User | dba |
| Password | (empty) |
Learning Path¶
After fundamentals, continue to: - quickstart/ — 5-minute working API - templates/ — Production-ready starters - performance/ — Optimization patterns - pitfalls/ — Common mistakes to avoid