starwars_db: Connect to the Star Wars Database

In starwarsdb: Relational Data from the 'Star Wars' API for Learning and Teaching

Connect to the Star Wars Database

Description

Provides a connection to a DuckDB database of the Star Wars data. Alternatively, you can use starwars_db() to manually connect to the database using DBI::dbConnect() and duckdb::duckdb().

Usage

starwars_connect(dbdir = ":memory:", ...)

starwars_disconnect(con)

starwars_db()

Arguments

dbdir	Location for database files. Should be a path to an existing directory in the file system. With the default (or ""), all data is kept in RAM.
...	Additional parameters passed to DBI::dbConnect()
con	A connection to the Star Wars database

Value

A connection to the Star Wars database, or the path to the database.

Functions

• starwars_connect(): Connect to the DuckDB database

• starwars_disconnect(): Disconnect from the DuckDB database

• starwars_db(): Returns the path to the starwarsdb database

Examples

# Manually connect using {duckdb} and {DBI}
con <- DBI::dbConnect(
  duckdb::duckdb(),
  dbdir = starwars_db(),
  read_only = TRUE
)

if (requireNamespace("dplyr", quietly = TRUE)) {
  dplyr::tbl(con, "films")
}

# Disconnect from that database (shutdown is specific to duckdb)
DBI::dbDisconnect(con, shutdown = TRUE)

# Or connect without worrying about connection details
con <- starwars_connect()

if (requireNamespace("dplyr", quietly = TRUE)) {
  dplyr::tbl(con, "films")
}

# Similarly, disconnect quickly without worrying about duckdb arguments
starwars_disconnect(con)

starwarsdb documentation built on Aug. 23, 2025, 1:10 a.m.