RSQLite

RSQLite embeds the SQLite database engine in R and provides a DBI-compliant interface for working with SQLite databases. It enables you to create, query, and manage lightweight, single-user databases directly from R without external dependencies.

SQLite is a public-domain database engine that implements core SQL 92 operations including table creation, updates, inserts, selects, and transaction management. RSQLite supports both in-memory databases for temporary data operations and file-based databases for persistent storage. You can retrieve query results all at once or process them in chunks for memory-efficient handling of large datasets.