search

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.32k stars 146 forks source link

Can I have to migrate my PostgreSQL relational data to agansgraph or there is some other way to relate both? #564

Open AnwarsaeedDMU opened 2 years ago

AnwarsaeedDMU commented 2 years ago

Hey! I have existing table data in my local PostgreSQL, I want to use this data with my Agensgraph graph data. can I have to migrate my relational data to agensgraph or can I access that data from agensgraph too? there is some PostgreSQL extension, but I don't know what it is for and how to use it? Guide me on that ... Thanks in advance!!!

kysmou commented 2 years ago

To use PostgreSql RDBMS data in graph DB, you need to convert it into JSON type data. The conversion process is not difficult. You can check the manual at the following link: https://bitnine.net/learn/

kysmou commented 2 years ago

You may also refer to the link below. https://bitnine.net/tutorial/tutorial_eng.html?ckattempt=2.

AnwarsaeedDMU commented 2 years ago

Thanks for your kind response. so it means I have to convert all data to graph or JSON type? what if I want to convert some of the table data such as the id column and leave other data as relational data(id column in graph and another attribute in relational tables), can I still query all the data simultaneously( or maybe hybrid queries )? what if it's possible? so still I have to import all data to agensgraph? please guide me on that. Thanks!

On Thu, Jun 16, 2022 at 8:56 AM YoungWoo kim @.***> wrote:

To use PostgreSql RDBMS data in graph DB, you need to convert it into JSON type data. The conversion process is not difficult. You can check the manual at the following link: https://bitnine.net/learn/

— Reply to this email directly, view it on GitHub https://github.com/bitnine-oss/agensgraph/issues/564#issuecomment-1157203745, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASHXGNN5E4WA2UOKJVI3P2LVPKQXZANCNFSM5XMBGZEQ . You are receiving this because you authored the thread.Message ID: @.***>

kysmou commented 2 years ago

It is not necessary to convert all data into agensgraph, i.e. graph data. Some are in the graph area, some are in the relational table, and as long as there is a key value that can connect the two data, you can query using a hybrid query.