{"repo":"poissonconsulting/readwritesqlite","free":true,"listed":false,"github":"https://github.com/poissonconsulting/readwritesqlite","clone":"git clone https://github.com/poissonconsulting/readwritesqlite.git","description":"An R package that enhances writing and reading data to and from SQLite databases","language":"R","stars":39,"topics":["rstats","sqlite","dbi","read","write","metadata","sfc","posixct","units","log"],"license":null,"category":"databases-storage","readme_excerpt":"readwritesqlite readwritesqlite SQLite databases are a simple, powerful way to validate, query and store related data frames particularly when used with the RSQLite package. However, current solutions do not preserve (or check) meta data, log changes or provide particularly useful error messages. readwritesqlite is an R package that by default - preserves (and subsequently checks) the following metadata - the class for logical, Date and hms columns - the levels for factors and ordered factors - the time zone for POSIXct columns - the units for unit columns - the projection for sfc columns - the sf column for sf objects - logs - the date time - system user - table creation and data insertion or deletion - provides informative error messages if - columns are missing - NOT NULL columns contain missing values - PRIMARY KEY column values in the input data are not unique readwritesqlite also allows the user to - write environments (or named lists) of data frames (useful for populating databases) - delete existing data (and meta data) before writing (useful for converting an existing database) - replace existing data which causes unique or primary key conflicts (useful for updating databases) - confirm data can be written without committing any changes (useful for checking data) - check all existing tables are written to (useful for data transfers) - rearrange and add levels for factors and add levels for ordered factors - initialize the meta data for a new table by writing a data f","default_branch":null,"files":null,"tree":[],"storefront":"/r/poissonconsulting","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/poissonconsulting/readwritesqlite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}