Glossary

Terms used in wsqlite documentation.

ORM

Object-Relational Mapping. A technique that maps database tables to Python objects.

Pydantic

A Python library for data validation using type annotations.

CRUD

Create, Read, Update, Delete - the four basic operations of persistent storage.

Async

Asynchronous programming pattern using asyncio in Python.

Transaction

A sequence of database operations executed as a single unit of work.

Index

A data structure that improves the speed of data retrieval operations.

Schema

The structure that defines the organization of data in a database.

Primary Key

A unique identifier for each record in a table.

SQLite

A lightweight, file-based SQL database engine.

Connection Pool

A cache of database connections maintained for reuse.