SQL Databases For dplyr Users: Introduction

[@ShannonMerkle]

My databases are in a .sqlite3 'SQLiteStudio Document' format, would this be a problem/different process? These are great videos, thanks!

[@weecology]

You're welcome! I think it should still work, but I don't have any direct experience with that particular case.

[@dolusolana2127]

I have been trying to set up a remote postgresql server. But it's not working 🥺. The error message says database name doesn't exist but it does.

[@weecology]

Running remote postgresql servers is definitely tricky. Unfortunately it's been too long since I ran one for me to be of much help.

[@dolusolana2127]

@@weecology thanks

[@outofahat9363]

havent tried with postgresql but i can help you with the next closest thing, MariaDb . the following code its working library(DBI) library (RMariaDB) library(dplyr) con