/Library/Frameworks/R.framework/Versions/3.0/Resources/library
on Win
c:/Users/vlad/R/win-library/3.0
At this point these notes on R and statistics are mostly to myself. Hopefully over time they will evolve into something that can be more generally useful.
/Library/Frameworks/R.framework/Versions/3.0/Resources/library
on Win
c:/Users/vlad/R/win-library/3.0
# Things you might want to change
# options(papersize="a4")
# options(editor="notepad")
# options(pager="internal")
# set the default help type
# options(help_type="text")
options(help_type="html")
# set a site library
# .Library.site <- file.path(chartr("\\", "/", R.home()), "site-library")
# set a CRAN mirror
# local({r <- getOption("repos")
# r["CRAN"] <- "http://my.local.cran"
# options(repos=r)})
# Give a fortune cookie, but only to interactive sessions
# (This would need the fortunes package to be installed.)
if (interactive()) {
fortunes::fortune()
#---- custom color schemes
library(grDevices)
blue.colors = colorRampPalette(RColorBrewer::brewer.pal(9,"Blues"))
jet.colors = colorRampPalette(c("blue","#007FFF","cyan","#7FFF7F","yellow","#FF7F00","red"))
blackBody.colors = colorRampPalette(c("black", "red", "orange","yellow","lightyellow"),space="rgb")
}
environment(fun) = parent.env(environment(fun))
biocLite("Rgraphviz", configure.args=c("--with-graphviz=/usr"))
the reason is that at least on my computer the dot program was in
/usr/bin, but not in /usr/local/bin as Rgraphviz defaults
brew updatebrew install unixodbcbrew install freetds
/etc/odbcinst.ini
but
/usr/local/etc/odbcinst.ini,
On Linux it looks like this[FreeTDS]Description = TDS driver (Sybase/MS SQL)Driver = /usr/lib/odbc/libtdsodbc.soSetup = /usr/lib/odbc/libtdsS.so
On Mac paths are a bit different[FreeTDS]Description = TDS driver (Sybase/MS SQL)Driver = /usr/local/lib/libtdsodbc.soSetup = /usr/local/lib/libtdsS.so
then it worked just fine.library(RODBC)
# replace server.name, database.name, user.id, password and T_my_table correspondingly
con <- odbcDriverConnect("DRIVER={FreeTDS};SERVER=server.name;DATABASE=database.name;UID=user.id;PWD=password;")
strSql <- "select * from T_my_table"
x <- sqlQuery(con, strSql)
close(con)
cat(x)
Checking font availability on Mac fc-list : family | grep "Fira Code" or system_profiler -json SPFontsDataType | grep \...