Showing 13 of total 13 results (show query)
ropensci
nodbi:'NoSQL' Database Connector
Simplified JSON document database access and manipulation, providing a common API across supported 'NoSQL' databases 'Elasticsearch', 'CouchDB', 'MongoDB' as well as 'SQLite/JSON1', 'PostgreSQL', and 'DuckDB'.
Maintained by Ralf Herold. Last updated 6 hours ago.
databasemongodbelasticsearchcouchdbsqlitepostgresqlduckdbnosqljsondocuments
77 stars 8.23 score 28 scripts 1 dependents
rfhb
ctrdata:Retrieve and Analyze Clinical Trials Data from Public Registers
A system for querying, retrieving and analyzing protocol- and results-related information on clinical trials from four public registers, the 'European Union Clinical Trials Register' ('EUCTR', <https://www.clinicaltrialsregister.eu/>), 'ClinicalTrials.gov' (<https://clinicaltrials.gov/> and also translating queries the retired classic interface), the 'ISRCTN' (<http://www.isrctn.com/>) and the 'European Union Clinical Trials Information System' ('CTIS', <https://euclinicaltrials.eu/>). Trial information is downloaded, converted and stored in a database ('PostgreSQL', 'SQLite', 'DuckDB' or 'MongoDB'; via package 'nodbi'). Protocols, statistical analysis plans, informed consent sheets and other documents in registers associated with trials can also be downloaded. Other functions implement trial concepts canonically across registers, identify deduplicated records, easily find and extract variables (fields) of interest even from complex nested data as used by the registers, merge variables and update queries. The package can be used for monitoring, meta- and trend-analysis of the design and conduct as well as of the results of clinical trials across registers.
Maintained by Ralf Herold. Last updated 10 hours ago.
clinical-dataclinical-researchclinical-studiesclinical-trialsctgovdatabaseduckdbmongodbnodbipostgresqlregistersqlitestudiestrial
45 stars 7.85 score 32 scripts
ddotta
parquetize:Convert Files to Parquet Format
Collection of functions to get files in parquet format. Parquet is a columnar storage file format <https://parquet.apache.org/>. The files to convert can be of several formats ("csv", "RData", "rds", "RSQLite", "json", "ndjson", "SAS", "SPSS"...).
Maintained by Damien Dotta. Last updated 5 months ago.
conversionconvertconvertercsvparquetsasspsssqlitestata
71 stars 7.36 score 27 scripts 1 dependents
statismike
shiny.reglog:Optional Login and Registration Module System for ShinyApps
RegLog system provides a set of shiny modules to handle register procedure for your users, alongside with login, edit credentials and password reset functionality. It provides support for popular SQL databases and optionally googlesheet-based database for easy setup. For email sending it provides support for 'emayili' and 'gmailr' backends. Architecture makes customizing usability pretty straightforward. The authentication system created with shiny.reglog is designed to be optional: user don't need to be logged-in to access your application, but when logged-in the user data can be used to read from and write to relational databases.
Maintained by Michal Kosinski. Last updated 3 years ago.
googlesheetregister-uishiny-applicationssqlite
14 stars 6.45 score 20 scripts
poissonconsulting
readwritesqlite:Enhanced Reading and Writing for 'SQLite' Databases
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.
Maintained by Joe Thorley. Last updated 2 months ago.
dbilogmetadataposixctreadsfcsqliteunitswrite
38 stars 6.42 score 11 scripts 1 dependentspoissonconsulting
dbflobr:Read and Write Files to SQLite Databases
Reads and writes files to SQLite databases <https://www.sqlite.org/index.html> as flobs (a flob is a blob that preserves the file extension).
Maintained by Evan Amies-Galonski. Last updated 2 months ago.
6 stars 5.86 score 5 scripts
brownag
gpkg:Utilities for the Open Geospatial Consortium 'GeoPackage' Format
Build Open Geospatial Consortium 'GeoPackage' files (<https://www.geopackage.org/>). 'GDAL' utilities for reading and writing spatial data are provided by the 'terra' package. Additional 'GeoPackage' and 'SQLite' features for attributes and tabular data are implemented with the 'RSQLite' package.
Maintained by Andrew Brown. Last updated 13 days ago.
dbigeopackagegeospatialgisrasterspatialsqlitevector
21 stars 5.72 score
nikolaus77
rocker:Database Interface Class
'R6' class interface for handling relational database connections using 'DBI' package as backend. The class allows handling of connections to e.g. PostgreSQL, MariaDB and SQLite. The purpose is having an intuitive object allowing straightforward handling of SQL databases.
Maintained by Nikolaus Pawlowski. Last updated 3 years ago.
databasedbimariadbmysqlpostgrespostgresqlr6sqlsqlite
5 stars 5.24 score 7 scripts
mlr-org
mlr3db:Data Base Backend for 'mlr3'
Extends the 'mlr3' package with a backend to transparently work with databases such as 'SQLite', 'DuckDB', 'MySQL', 'MariaDB', or 'PostgreSQL'. The package provides two additional backends: 'DataBackendDplyr' relies on the abstraction of package 'dbplyr' to interact with most DBMS. 'DataBackendDuckDB' operates on 'DuckDB' data bases and also on Apache Parquet files.
Maintained by Michel Lang. Last updated 1 years ago.
bigquerydata-backenddatabaseduckdbmachine-learningmariadbmlr3mysqlodbcpostgresqlsparksqlite
21 stars 4.77 score 17 scripts
skranz
dbmisc:Tools for working with SQLite in R
Tools for working with SQLite in R, in particular support for simple YAML schemas.
Maintained by Sebastian Kranz. Last updated 2 years ago.
27 stars 4.41 score 16 scripts 4 dependents
mikeasilva
simplegraphdb:A Simple Graph Database
This is a graph database in 'SQLite'. It is inspired by Denis Papathanasiou's Python simple-graph project on 'GitHub'.
Maintained by Michael Silva. Last updated 4 years ago.
7 stars 3.75 score 16 scripts
crotman
sqliteutils:Utility Functions for 'SQLite'
A tool for working with 'SQLite' databases. 'SQLite' has some idiosyncrasies and limitations that impose some hurdles to the R developer who is using this database as a repository. For instance, 'SQLite' doesn't have a date type and 'sqliteutils' has some functions to deal with that.
Maintained by Bruno Crotman. Last updated 4 years ago.
5 stars 3.40 score 2 scripts
inbo
grtsdb:Create a Sampling Frame Using GRTS
Create an SQLite database containing the sampling framework for different levels of resolution. Take a sample from this framework.
Maintained by Thierry Onkelinx. Last updated 3 years ago.
grtssamplingsampling-methodssqlite
1 stars 2.70 score 9 scripts