readwritesqlite
readwritesqlite copied to clipboard
poissonconsulting
An R package that enhances writing and reading data to and from SQLite databases
datetime columns that are stored as `TEXT` and contain 00:00:00 times causes all times to be dropped
not an issue when using column type `TIMESTAMP` in table definition ```r data
This will deal with issue #37
I can create a table and set the type to be integer, but rws_write will still write a table containing a text column (i.e. no error at this stage). If...
if true, all spatial tables should be written as layers to one gpkg. The gpkg name should be database name
in particular 1) read in data 2) drop table 3) repopulate
There is useful metadata stored in the attributes of a variable, and it would be nice to have that saved in the database along with the other metadata. Specifically, I...
Seems odd - so incredibly sorry if this is actually just a system specific error. Seems to install fine with pak from github.... was originally 4.4.0 ``` > pak::pkg_install('readwritesqlite') ✔...
Metadata
Owner
Metadata
An R package that enhances writing and reading data to and from SQLite databases