Help pages

Every help page in the package. The grouping below is the one the reference index used to have; an alphabetical list of the same pages follows.

Connecting. Opening a database, optionally straight onto a branch. dbConnect() takes the DoltLite-specific branch, bigint and busy_timeout arguments alongside the usual DBI ones.

Doltlite(), dbConnect(), DOLTLITE_RO

DBI classes and methods. The ordinary DBI surface. These behave as they would for any SQLite database, with the documented exceptions around clustered primary keys and transactions.

dbWriteTable(), dbDataType(), doltliter-transactions

Configuring and committing. The commit loop. Note that dolt_commit() is the Dolt sense of commit – it writes to the version history – and is unrelated to DBI::dbCommit().

dolt_config(), dolt_add(), dolt_commit(), dolt_status(), dolt_reset(), dolt_revert(), dolt_cherry_pick()

Branches, merging and conflicts. Each connection selects its own branch. Conflicts exist only inside the transaction that produced them, so a merge you expect to conflict belongs in one.

dolt_branch(), dolt_checkout(), dolt_active_branch(), dolt_merge(), dolt_merge_base(), dolt_merge_status(), dolt_rebase(), dolt_tag(), dolt_conflicts(), dolt_constraint_violations()

History, diffs and time travel. Reading the past: what changed, when, and who changed it.

dolt_log(), dolt_diff(), dolt_table_diff(), dolt_diff_stat(), dolt_patch(), dolt_history(), dolt_at(), dolt_blame(), dolt_workspace(), dolt_schemas()

Remotes. Pushing and pulling between databases, over the filesystem or HTTP.

dolt_remote(), dolt_push(), dolt_pull(), dolt_clone(), dolt_creds()

Interactive. A Shiny gadget and RStudio addin over a connection you already have open.

dolt_pane()

Introspection and maintenance. Content hashes, versions and housekeeping.

dolt_hashof(), dolt_version(), doltlite_engine(), dolt_gc(), dolt_verify_constraints()

Calling anything else. The two escape hatches for DoltLite functions this package does not wrap, with arguments bound as parameters rather than pasted into SQL.

dolt_scalar(), dolt_table()