Skip to contents

R package · Databases

An abstracted, object-oriented system for large datasets across database systems: robust PostgreSQL, SQL Server and SQLite connections, bulk loading and upserts, validation, and index management.

Get started Browse the reference →

csdb logo

Features

01

Connection management

DBConnection_v9 wraps an ODBC or SQLite connection with lazy connect, explicit disconnect, and automatic reconnect via $autoconnection.

02

Bulk table operations

DBTable_v9 handles insert, upsert, and key-based row deletion against PostgreSQL, SQL Server and SQLite tables, with configurable indexes.

03

Field validation

Pluggable validators check field types and field contents before data reaches the database, with built-in schemas for the csverse csfmt_rts_data format.