readwritesqlite

readwritesqlite-package

<img src="figures/logo.png?package=readwritesqlite&version=0.2.0" style="float: right" alt="logo" width="120">
Reads and writes data frames to 'SQLite' databases while preserving time zones (for POSIXct columns), projections (for 'sfc' columns), units (for 'units' columns), levels (for factors and ordered factors) and classes for logical, Date and 'hms' columns. It also logs changes to tables and provides more informative error messages.

internal

Reads and writes data frames to 'SQLite' databases
while preserving time zones (for POSIXct columns), projections (for
'sfc' columns), units (for 'units' columns), levels (for factors and
ordered factors) and classes for logical, Date and 'hms' columns.  It
also logs changes to tables and provides more informative error
messages.

Joe Thorley

Enhanced Reading and Writing for 'SQLite' Databases

Sebastian Dalgarno

Poisson Consulting 

readwritesqlite-package function

Maintainer: Joe Thorley <a href="/link/joe%40poissonconsulting.ca?package=readwritesqlite&version=0.2.0" data-mini-rdoc="readwritesqlite::joe@poissonconsulting.ca">joe@poissonconsulting.ca</a> (<a href="https://orcid.org/0000-0002-7683-4592">ORCID</a>)
Other contributors:<ul>
<li>Sebastian Dalgarno <a href="/link/seb%40poissonconsulting.ca?package=readwritesqlite&version=0.2.0" data-mini-rdoc="readwritesqlite::seb@poissonconsulting.ca">seb@poissonconsulting.ca</a> (<a href="https://orcid.org/0000-0002-3658-4517">ORCID</a>) [contributor]</li>
<li>Poisson Consulting [copyright holder, funder]</li>
</ul>

Author

<img src='figures/logo.png' style='float: right' alt='logo' width='120' />
Reads and writes data frames to 'SQLite' databases while preserving time zones (for POSIXct columns), projections (for 'sfc' columns), units (for 'units' columns), levels (for factors and ordered factors) and classes for logical, Date and 'hms' columns. It also logs changes to tables and provides more informative error messages.

readwritesqlite: Enhanced Reading and Writing for 'SQLite' Databases — readwritesqlite-package

Maintainer: Joe Thorley <a href='mailto:joe@poissonconsulting.ca'>joe@poissonconsulting.ca</a> (<a href='https://orcid.org/0000-0002-7683-4592'>ORCID</a>)
Other contributors:<ul>
<li>Sebastian Dalgarno <a href='mailto:seb@poissonconsulting.ca'>seb@poissonconsulting.ca</a> (<a href='https://orcid.org/0000-0002-3658-4517'>ORCID</a>) [contributor]</li>
<li>Poisson Consulting [copyright holder, funder]</li>
</ul>

readwritesqlite-package: readwritesqlite: Enhanced Reading and Writing for 'SQLite' Databases

Description

Arguments

Author

See Also