nodbi - Document 'NoSQL' Database DBI Connector
R database connector for creating, reading (querying and listing fields), updating and deleting of individual or many JSON documents, providing a common API across supported databases ('SQLite', 'PostgreSQL', 'DuckDB', 'MariaDB' or 'MySQL' as well as 'NoSQL' databases 'MongoDB', 'CouchDB' and 'Elasticsearch').
Last updated
databasemongodbelasticsearchcouchdbsqlitepostgresqlmariadbmysqlduckdbnosqljsondocuments
8.34 score 75 stars 1 dependents 37 scripts 755 downloadsctrdata - 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' (<https://www.isrctn.com/>) and the 'European Union Clinical Trials Information System' ('CTIS', <https://euclinicaltrials.eu/>). Trial information is downloaded, converted and stored as JSON in a database ('PostgreSQL', 'SQLite', 'DuckDB', 'MongoDB' or 'MariaDB'; 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 analysis concepts canonically across registers, identify deduplicated records across registers, easily find and extract variables (fields) of interest even from complex nested data as used by 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. See overview in Herold, R. (2025) <doi:10.1017/rsm.2025.10061>.
Last updated
clinical-dataclinical-researchclinical-studiesclinical-trialsctgovdatabaseduckdbmongodbnodbipostgresqlregistersqlitestudiestrial
8.05 score 61 stars 47 scripts 1.1k downloadselastic - Database Interface to 'Elasticsearch' and 'OpenSearch'
Connect to 'Elasticsearch' and 'OpenSearch', 'NoSQL' databases built on the 'Java' Virtual Machine and using the 'Apache' 'Lucene' library. Interacts with the 'Elasticsearch' 'HTTP' API' (<https://www.elastic.co/elasticsearch/>) and the 'OpenSearch' 'HTTP' 'API' (<https://opensearch.org/>). Includes functions for setting connection details to 'Elasticsearch' and 'OpenSearch' instances, loading bulk data, searching for documents with both 'HTTP' query variables and 'JSON' based body requests. In addition, 'elastic' provides functions for interacting with APIs for 'indices', documents, nodes, clusters, an interface to the cat API, and more.
Last updated
databaseelasticsearchopensearchlucenehttpapisearchnosqljavajsondocuments
6.78 score 1 stars 168 scripts 713 downloads