fb_connect | R Documentation |
Returns the connection to the database
fb_connect( dbname = "flybase", host = "chado.flybase.org", port = 5432, user = "flybase", password = "flybase", dplyr = FALSE, ... )
dbname |
(character) database name. default: flybase |
host |
(character) database name. default: chado.flybase.org |
port |
(integer) database name. default: 5432 |
user |
(character) database name. default: flybase |
password |
(character) database name. default: flybase |
dplyr |
(logical) if |
... |
further args passed on to |
Make a connection with the read only postgreSQL version of the flybase database. For intense use, one should downlaod the database and change this function.
## Not run: (conn <- fb_connect()) # using with dplyr library("dplyr") (src <- fb_connect(dplyr = TRUE)) orgs <- src %>% tbl("organism") orgs %>% filter(genus == "Antheraea") tbl(src, sql('SELECT * FROM phenotype WHERE "phenotype_id" = 8511')) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.