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' and 'NoSQL' databases 'MongoDB', 'CouchDB' and 'Elasticsearch').

Last updated

databasemongodbelasticsearchcouchdbsqlitepostgresqlduckdbnosqljsondocuments

8.29 score 75 stars 1 dependents 43 scripts 391 downloads

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. See overview in Herold, R. (2025) <doi:10.1017/rsm.2025.10061>.

Last updated

clinical-dataclinical-researchclinical-studiesclinical-trialsctgovdatabaseduckdbmongodbnodbipostgresqlregistersqlitestudiestrial

8.03 score 57 stars 45 scripts 781 downloads

elastic - 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.83 score 1 stars 186 scripts 530 downloads