In poissonconsulting/createsqlite: Tools to generate SQLite database creation scripts

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)

createsqlite

Installation

From Genesis, came Phil Collins. collinsqlite can be used to generate and re-generate a SQLite database from a SQLiteConnection, data.frame or named list of data.frames.

# install.packages("remotes")
remotes::install_github("poissonconsulting/createsqlite")

Usage

Get table schemas from a SQLiteConnection object

Guess table schema for a single data.frame

Guess table schemas for a list of named data.frames

Write a file including table schemas, which can be sourced to create a new database

Contribution

Please report any issues.

Pull requests are always welcome.

Code of Conduct

Please note that the createsqlite project is released with a Contributor Code of Conduct. By contributing to this project, you agree to abide by its terms.

poissonconsulting/createsqlite documentation built on July 28, 2020, 2:15 p.m.