'Database Access in R: MariaDB vs RODBC, dplyr etc
I'm a noob so forgive my ignorance :-)
I'm creating a Shiny app to perform read/write operations on an existing MS Access database (.mdb) with about 20 small tables and a variety of joins on them. I may have a small number of people connecting simultaneously.
I have planned to use MariaDB (RMariaDB). I notice e.g. RODBC or dplyr can connect to .mdb directly? The app will be hosted on a remote server.
It's unlikely the largest table will exceed 5000 rows in the next 2 years. Should I be using MariaDB now or would the other 'direct' options be enough?
Many thanks in advance for your replies...
Gary
Solution 1:[1]
This is not an answer to 'which db shall I use?', but it is a recommendation for a starting point:
The short answer is 'ensure DBI compatibility' and the slightly longer answer is 'for Shiny apps consider using the pool package'.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | majr |