Postgresql-MongoDb foreigndata wrapper

Started by aluka rajualmost 10 years ago3 messagesgeneral
Jump to latest
#1aluka raju
alukaraju2894@gmail.com

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?

Thanks
aluka

Sent with MailTrack
<https://mailtrack.io/install?source=signature&amp;lang=en&amp;referral=alukaraju2894@gmail.com&amp;idSignature=22&gt;

#2Sameer Kumar
sameer.kumar@ashnik.com
In reply to: aluka raju (#1)
Re: Postgresql-MongoDb foreigndata wrapper

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
<https://mailtrack.io/install?source=signature&amp;lang=en&amp;referral=alukaraju2894@gmail.com&amp;idSignature=22&gt;

--
--
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

#3Sameer Kumar
sameer.kumar@ashnik.com
In reply to: aluka raju (#1)
Re: Postgresql-MongoDb foreigndata wrapper

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
<https://mailtrack.io/install?source=signature&amp;lang=en&amp;referral=alukaraju2894@gmail.com&amp;idSignature=22&gt;

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
<https://mailtrack.io/install?source=signature&amp;lang=en&amp;referral=alukaraju2894@gmail.com&amp;idSignature=22&gt;

--
--
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