Create AWS RDS db and import all data to db

[olgnaydn]

@uisikdag hocam selamlar AWS uzerinde PostgreSQL veri tabani olusturdum. Hesap turu t2.micro 12 ay free, sonrasinda da cok cok dusuk maliyeti var (saatlik 0.3 cent).

Asagida db bilgilerini bulabilirsiniz; Datalari da buraya atinca tekrar buraya yazacagim.

dbname: development username: airqualitr_team password: msgsu2017 endpoint/host: airqualitr.clgjf7569y1t.us-west-2.rds.amazonaws.com port: 5432

[uisikdag]

süper...

---

Umit Isikdag Department of Informatics,Mimar Sinan Fine Arts University Editor of International Journal of 3D Information Modeling(IJ3DIM) www.isikdag.com labs.isikdag.com http://labs.isikdag.com www.igi-global.com/ij3dim https://goo.gl/AveWq2

2017-10-06 11:48 GMT+03:00 Olgun AYDIN notifications@github.com:

@uisikdag https://github.com/uisikdag hocam selamlar aws uzerinde t2 micro actim 12 ay free sonrasinda da cok cok dusuk maliyeti var. Asagida db bilgilerini bulabilirsiniz;

dbname: development username: airqualitr_team password: msgsu2017 endpoint/host:airqualitr.clgjf7569y1t.us-west-2.rds.amazonaws.com port: 5432

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/olgnaydn/airqualitr/issues/9#issuecomment-334696514, or mute the thread https://github.com/notifications/unsubscribe-auth/AGT_C1uvN5NtqeeC5Te-QkyldmwT3DILks5spelTgaJpZM4Ppgy5 .

[olgnaydn]

Sagolun hocam :)

Bu arada tum verileri olusturdugum db'ye attim. airquality_data diye bir tablo olusturdum.

Asagidaki scriptler ile RPostgreSQL kutuphanesini kullanarak ornek sorgu olusturabilirsiniz;

library(RPostgreSQL) drv <- dbDriver("PostgreSQL")

con <- dbConnect(drv, dbname = "development", host = "airqualitr.clgjf7569y1t.us-west-2.rds.amazonaws.com",port=5432, user = "airqualitr_team", password = "msgsu2017")

a <- dbGetQuery(con, "select * from airquality_data limit 5")

[olgnaydn]

Bu issue'yu da cozduk :) kapatiyorum bunu da

[uisikdag]

tesekkürler hocam..server down mu dur? con baglatisini yapamadim...

---

Umit Isikdag Department of Informatics,Mimar Sinan Fine Arts University Editor of International Journal of 3D Information Modeling(IJ3DIM) www.isikdag.com labs.isikdag.com http://labs.isikdag.com www.igi-global.com/ij3dim https://goo.gl/AveWq2

6 Ekim 2017 12:50 tarihinde Olgun AYDIN notifications@github.com yazdı:

Sagolun hocam :)

Bu arada tum verileri olusturdugum db'ye attim. airquality_data diye bir tablo olustudum.

Asagidaki scriptler ile ornek sorgu olusturabilirsiniz;

`library(RPostgreSQL) drv <- dbDriver("PostgreSQL")

con <- dbConnect(drv, dbname = "development", host = " airqualitr.clgjf7569y1t.us-west-2.rds.amazonaws.com",port=5432, user = "airqualitr_team", password = "msgsu2017")

a <- dbGetQuery(con, "select * from airquality_data limit 5") `

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/olgnaydn/airqualitr/issues/9#issuecomment-334710511, or mute the thread https://github.com/notifications/unsubscribe-auth/AGT_C5MLMiTnjewlcQYRqTnTwY62HKKPks5spffhgaJpZM4Ppgy5 .

[olgnaydn]

Rica ederim hocam, server live durumda su anda. Sanirim security ayarlarindan oturu baglanamadiniz. Simdi bir daha kontrol edebilir misiniz ?

[uisikdag]

süper çalıştı hocam,

PM10 gibi alan adları büyük harf ise select yapmiyor..bakayim cozum bulursam yazarım

---

Umit Isikdag Department of Informatics,Mimar Sinan Fine Arts University Editor of International Journal of 3D Information Modeling(IJ3DIM) www.isikdag.com labs.isikdag.com http://labs.isikdag.com www.igi-global.com/ij3dim https://goo.gl/AveWq2

6 Ekim 2017 16:51 tarihinde Olgun AYDIN notifications@github.com yazdı:

Rica ederim hocam, server live durumda su anda. Sanirim security ayarlarindan oturu baglanamadiniz. Simdi bir daha kontrol edebilir misiniz ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/olgnaydn/airqualitr/issues/9#issuecomment-334760846, or mute the thread https://github.com/notifications/unsubscribe-auth/AGT_CwukO5TxHQAdaPBm2p5Tar_E0-81ks5spjBzgaJpZM4Ppgy5 .

[olgnaydn]

Harika!

Hocam soyle uppercase ya da camel case oldugu zaman Postgre tirnak icinde kullanmanizi istiyor.

Ornegin;

a <- dbGetQuery(con, "select * from airquality_data where 'PM10' is not null limit 5")

Bu sekilde PM10 sorgulayabilirsiniz. Olmazsa bir update yapariz ve hepsini lower case e cekeriz.

[uisikdag]

qs<-"select 'PM10' from airquality_data limit 1"

a <- dbGetQuery(con, qs)

böyle yazdım çalışmadı bende :( olmadı hepsini lowercase yapalim rahat edelim...

---

Umit Isikdag Department of Informatics,Mimar Sinan Fine Arts University Editor of International Journal of 3D Information Modeling(IJ3DIM) www.isikdag.com labs.isikdag.com http://labs.isikdag.com www.igi-global.com/ij3dim https://goo.gl/AveWq2

6 Ekim 2017 17:18 tarihinde Olgun AYDIN notifications@github.com yazdı:

Harika!

Hocam soyle uppercase ya da camel case oldugu zaman Postgre tirnak icinde kullanmanizi istiyor.

Ornegin;

a <- dbGetQuery(con, "select * from airquality_data where 'PM10' is not null limit 5")

Bu sekilde PM10 sorgulayabilirsiniz. Olmazsa bir update yapariz ve hepsini lower case e cekeriz.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/olgnaydn/airqualitr/issues/9#issuecomment-334768100, or mute the thread https://github.com/notifications/unsubscribe-auth/AGT_C-TpLldzWz0_T2amI4bxfKbRcXflks5spjaYgaJpZM4Ppgy5 .

[olgnaydn]

Su sekilde yapinca calisti hocam :) Tirnak isaretlerinin tiplerini degistirdim. Aynen, hepsini lowercase yapalim. Basimizi agritmasin :)

a <- dbGetQuery(con, 'select "PM10" from airquality_data where benzen is not null limit 5')

[uisikdag]

tırnak işaretleri nin bütün suç :)) aynen lowercase is the best...

---

Umit Isikdag Department of Informatics,Mimar Sinan Fine Arts University Editor of International Journal of 3D Information Modeling(IJ3DIM) www.isikdag.com labs.isikdag.com http://labs.isikdag.com www.igi-global.com/ij3dim https://goo.gl/AveWq2

6 Ekim 2017 17:41 tarihinde Olgun AYDIN notifications@github.com yazdı:

Su sekilde yapinca calisti hocam :) dediginiz gibi hepsini lowercase yapalim. Basimizi agritmasin :)

a <- dbGetQuery(con, 'select "PM10" from airquality_data where benzen is not null limit 5')

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/olgnaydn/airqualitr/issues/9#issuecomment-334774897, or mute the thread https://github.com/notifications/unsubscribe-auth/AGT_C17vjTd8pB19jcRFUb5mPOxSugstks5spjwygaJpZM4Ppgy5 .

[uisikdag]

bir de Kemal hoca ile konusuyorduk ..date i ayirsak mi diye date-time olarak-POSIX midir neydi bunun veri tipi zaman query is yapabilir miyiz bu hali ile

[olgnaydn]

Tabii hocam yapmamız mümkün. O şekilde yaparsak R fonksiyonlarında daha çok pratiklik kazanmış oluruz.

[uisikdag]

+1