Re: Postgresql-MongoDb foreigndata wrapper - Mailing list pgsql-general

From Sameer Kumar
Subject Re: Postgresql-MongoDb foreigndata wrapper
Date
Msg-id CADp-Sm6-4J+doWjRezMWR9_u_t74RiFmugbpk0SK9zjw+2=d=A@mail.gmail.com
Whole thread Raw
In response to Postgresql-MongoDb foreigndata wrapper  (aluka raju <alukaraju2894@gmail.com>)
List pgsql-general

Cc pg-list

Pls avoiding reaching out to members via list. I may not know something which someone else in the list may know.

On Mon, 23 May 2016, 1:22 p.m. aluka raju, <alukaraju2894@gmail.com> wrote:
Hello,

I have data storage in flat files (structured and unstructured) . I want to run sql queries on that , so i am looking in to postgresql to this on the data that i have. I want to prepare a software for running sql queries for the data in files,so i am trying to have separate postgresql engine and write an wrappper for connecting the data that are in files. 

Do these files change? 

Do you have any idea how can we do ?

Have you considering uploading this data to PostgreSQL? It can store relational and JSOn data both.




Thanks,
aluka 



Sent with MailTrack

On Mon, May 23, 2016 at 10:37 AM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:


On Mon, 23 May 2016, 1:03 p.m. aluka raju, <alukaraju2894@gmail.com> wrote:
Hello,

I want use my data source as  mongodb and connect through postgresql fdw. Is their any restrictions that the data present in mongodb to be structured or unstructured data?

For connecting to mongoDB you would need mongodb_fdw and not PostgreSQL fdw. I don't think they have any restrictions with respect to the data model.

BTW, why do you want to do that? 


Thanks
aluka 

Sent with MailTrack
--
--
Best Regards
Sameer Kumar | DB Solution Architect 
ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com


--
--
Best Regards
Sameer Kumar | DB Solution Architect 
ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: Postgresql-MongoDb foreigndata wrapper
Next
From: aluka raju
Date:
Subject: Postgresql-fdw