R Environment and PostgreSQL

# Install PostgreSQL 8.4 - 32 bit and install pgJDBC Driver, OLEDB Driver from Stack Builder..........
# Install R 2.11.1 -32 bit
# Open R interface..

library(rJava)
library(DBI)
library(RJDBC)
library(RpgSQL)

.jinit(classpath=NULL,parameters=getOption("-Xmx4000m"),silent=FALSE,force.init=TRUE)
con <- dbConnect(pgSQL(), user = "username", password = "password", dbname = "db_name",host="hostname")
result<-dbGetQuery(con, 'select blah1, blah2 from "tbl_blh"')

str(result)

result

Cheers !!!

Comments

Post a Comment

Popular posts from this blog

Update WPF Interaction Triggers in from .Net Framework 4.8 to .Net 5

  When migrating the Visual Studio projects from .Net Framework 4.8 to .Net 5, you may encounter   in the following error regarding Interaction.Triggers .   Error      XDG0008             The name "Interaction" does not exist in the namespace "http://schemas.microsoft.com/xaml/behaviors".   The one solution to fix it is to install “ Microsoft.Xaml.Behaviors.Wpf ” from Nuget And update the namespace ( if needed) xmlns : i ="http://schemas.microsoft.com/expression/2010/interactivity" to              xmlns:i ="http://schemas.microsoft.com/xaml/behaviors"
Read more

Extract Raster Values from Points

The R blog article encourages me to write this solution to extract Raster values from points in R. In geospatial analysis, extracting the raster value of a point is a common task. If you have few raster files or few points; you can extract the raster value by overlaying a point on the top of the raster using ArcGIS. What will you do, if you have hundreds of raster files and thousands of points? The easy solution is use loop in Python and ArcGIS. Is loop efficient to use? No. Can loop be avoided? Yes. Then how?  Follow the steps: Step 1: Create a Raster stack or Raster brick of your raster files using “raster” package in R . For example: rasStack = stack(raster1, raster2,raster3 …rasterN) Step 2:   Read point data, and convert them into spatial points data frame. Sample: pointfile.csv Point_ID LONGITUDE LATITUDE 1 48.765863             -...
Read more

Instruct GIT not to track a specific file

In scenarios like you have a configuration file in  a remote repo for the production environment, and you don’t want to commit the changes to this configuration file made from local.  How do you instruct git to do not track the local changes? --skip-worktree is what you need. git update-index --skip-worktree <filepath/file_name> After index update git won't show you the file in working tree. If you want to track the changes update-index as  git update-index --no-skip-worktree <filepath/file_name>
Read more