Installation | Introduction | Supported Formats | Quick Start | BiocIO Pattern | Lazy Evaluation | Multiple Tables | Connection Management | Next Steps

Introduction | Core Functions | filter_by_overlaps | Multiple Regions | dbSequence to dbSequence | compute_coverage | as_granges | Workflow Example | File Type Restrictions | Next Steps

Installation | Introduction | Supported Formats | Quick Start | BiocIO Pattern | Lazy Evaluation | Multiple Tables | Connection Management | Next Steps

Introduction | Core Functions | filter_by_overlaps | Multiple Regions | dbSequence to dbSequence | compute_coverage | as_granges | Workflow Example | File Type Restrictions | Next Steps

Minimal example

Introduction | Creating a DuckDB connection | Reading in spatial data from various sources | From data.frames | From .csv file | From {terra} objects: SpatVector

Setup | Geometry Operations | Measurements | Spatial Joins | Convert to sf

dbMatrix arithmetic | Create test data | Create a dbMatrix object | Scalar Arithmetic | Matrix Arithmetic | Matrix Multiplication | Hadamard product | Matrix product | Cleanup | Session Info

Introduction | Loading library | dbMatrix generics | dbSparse Matrix Operations | Create test data | transpose | colMeans | colSums | rowMeans | rowSums | dim | Check results are equivalent | dbDenseMatrix Operations | mean | Cleanup | Session Info

dbMatrix | Minimal example | dbSparseMatrix | dbDenseMatrix

The Problem | dbProject's Solution | DBI Compatibility | Convenience Features | Core Concepts | Mutable State (R6) | Centralized Management | Automatic Reconnection | Working with Pins

Database Lock Errors | Error: "Could not set lock on file" | Connection Issues | Error: "No active or cached connection available" | Objects showing "Error: Column references ..." after restart | Memory Issues | Large datasets causing R to crash | Package-Specific Issues | dbMatrix: Slow operations after many transformations | Getting Help

Introduction | Creating a dbProject | Working with Data | Pinning Tables | Disconnecting and Reconnecting | Reading Pinned Tables | Cleanup