What I learned today, I am glad you asked.
While taking the PG4E course, I wound up using R to interface with the postgresql database. I used some packages that interfaced nicely. One question, I had was; can I write straight sql in a markdown chunk. Yes you can but you need specify the connection in the chunk.
The only limitation I ran into was uploading or copying the data to the database. I attempted to use my linux terminal and installed some packages but alas I wound up using a bash console set up for postgresql at https://www.pythonanywhere.com/
This is a cool project and a good opportunity to use bash scripts and interface with a server.
While taking the PG4E course, I wound up using R to interface with the postgresql database. I used some packages that interfaced nicely. One question, I had was; can I write straight sql in a markdown chunk. Yes you can but you need specify the connection in the chunk.
The only limitation I ran into was uploading or copying the data to the database. I attempted to use my linux terminal and installed some packages but alas I wound up using a bash console set up for postgresql at https://www.pythonanywhere.com/
This is a cool project and a good opportunity to use bash scripts and interface with a server.
~Kevin Gilds