Saving data into Database

Mohammed Ali



This tutorial aims to explain how dbparser can work along with R database functionalities to save parsed drug tibbles to the user desired databases. This tutorial addresses the following three options:

Please note that this tutorial does not explain how to install these databases as it is out of scope.


SQLite is an inmemory database you can use locally easily. To save drug information using this database run the following

DBI Supported Databases

DBI separates the connectivity to the DBMS into a front-end and a back-end. Applications use only the exposed front-end API. The back-end facilities that communicate with specific DBMSs (SQLite, MySQL, PostgreSQL, MonetDB, etc.) are provided by drivers (other packages) that get invoked automatically through S4 methods. For more information about DBI package please refer to this link

The following are two examples of how to make the connection with SQL Server and Maria DB