sql file in RStudio, it automatically populates the file with the following code: - !preview conn=DBI::dbConnect(RSQLite::SQLite())
#Rubymine code with me code
(Thank you to RStudio Community posts such as this one for enlightening me.) These two methods also have the added benefit of SQL code with syntax highlighting. It turns out that within RStudio, there are actually (at least) two other methods of previewing SQL queries. # … with 2 more variables: ts_diameter, hu_diameter Up to now, I’d only used dataframe-style previews of query results, such as in the example below: library(dplyr) I’m glad I was forced to venture out of my RStudio comfort zone, but I’ve begun to discover that some of the features I love about RubyMine actually exist in RStudio as well.