index.qmd

---
title: "DBI for R"
comments: False
format:
  html:
    page-layout: full
about:
  id: about-rdbi
  template: jolla
  image: https://avatars.githubusercontent.com/u/5695665?s=200&v=4
  image-shape: rectangle
  links:
    - icon: github
      text: GitHub
      href: https://github.com/r-dbi
listing:
  - id: blog
    contents: 
      - "blog/*/*.qmd"
    type: default
    fields: [title, subtitle, author, description, date]
    sort: 
      - "date desc"
      - "title asc"
---

:::{#about-rdbi}
R's interface to databases, with a testable and human-readable specification, a selection of backend packages to connect with various databases, and a boilerplate for developing new backends.
:::


## Packages
:::::{.grid}
::::{.g-col-8 .g-col-md-4}
### Interface

The [DBI](https://dbi.r-dbi.org/) package defines generic methods that work almost identically across databases. 
This is checked by [DBItest](https://dbitest.r-dbi.org/), which also provides a human-readable [specification](https://cran.r-project.org/web/packages/DBI/vignettes/spec.html).


::::

::::{.g-col-8 .g-col-md-4}

### Backends

The [RSQLite](https://rsqlite.r-dbi.org/), [RMariaDB](https://rmariadb.r-dbi.org/), and [RPostgres](https://rpostgres.r-dbi.org/) packages implement methods defined by DBI that connect to specific databases.
There are [more packages](/backends) that connect to other databases.


::::


::::{.g-col-8 .g-col-md-4}

### Boilerplate

The [RKazam](https://rkazam.r-dbi.org/) package makes it easy for package developers to create a new package to a new DBMS.

::::
::::

## Blog posts

:::{#blog}
:::