You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "iitaejeong (via GitHub)" <gi...@apache.org> on 2023/06/16 06:06:15 UTC
[GitHub] [age] iitaejeong opened a new issue, #996: how we start develop compatibility with distributed database function of Citus
iitaejeong opened a new issue, #996:
URL: https://github.com/apache/age/issues/996
I recently saw the Citus Paper (https://dl.acm.org/doi/10.1145/3448016.3457551). They suggest the multi-tenant system for distributed database system through engineering skills. among them, i think the high-performance CRUD by reference table and index is good synergy with AGE. because of 'indexing' function.
I think the AGE can index function unlike Neo4j graph database (native vs. non-native). AGE is non-native but can use indexing of graph by assignment. so whoever wants to develop this project? not intervene low-level code(C++) only high-level code(SQL).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] iitaejeong commented on issue #996: how we start develop compatibility with distributed database function of Citus
Posted by "iitaejeong (via GitHub)" <gi...@apache.org>.
iitaejeong commented on issue #996:
URL: https://github.com/apache/age/issues/996#issuecomment-1656515195
@M4rcxs thanks your information. wow Memgraph can sharding but they can't multi-modal model(not compatible with SQL).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] Hannan2910 commented on issue #996: how we start develop compatibility with distributed database function of Citus
Posted by "Hannan2910 (via GitHub)" <gi...@apache.org>.
Hannan2910 commented on issue #996:
URL: https://github.com/apache/age/issues/996#issuecomment-1721206243
We have started this project and have tried to use citus exposed symbols and querries to shard tables created for the graphs vetices and edges. The use of reference tables ad colocation is rather favorable for AGE. We are still debating on how to approach automatic sharding of tables on creation and how to dynamically link Citus exposed symbols within AGE's code.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] M4rcxs commented on issue #996: how we start develop compatibility with distributed database function of Citus
Posted by "M4rcxs (via GitHub)" <gi...@apache.org>.
M4rcxs commented on issue #996:
URL: https://github.com/apache/age/issues/996#issuecomment-1655994534
I was researching about Citus and other alternatives for the problem, I have found this article at `db-engines`.
<!--StartFragment-->
Name | Citus X | Memgraph X | Postgres-XL X
-- | -- | -- | --
Description | Scalable hybrid operational and analytics RDBMS for big data use cases based on PostgreSQL | An open source graph database built for real-time streaming and compatible with Neo4j | Based on PostgreSQL enhanced with MPP and write-scale-out cluster features
<!--EndFragment-->
- Link for the complete descriptions and features: [Citus comparative article](https://db-engines.com/en/system/Citus%3BMemgraph%3BPostgres-XL)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] MuhammadZeeshan03 commented on issue #996: how we start develop compatibility with distributed database function of Citus
Posted by "MuhammadZeeshan03 (via GitHub)" <gi...@apache.org>.
MuhammadZeeshan03 commented on issue #996:
URL: https://github.com/apache/age/issues/996#issuecomment-1721433440
Citus introduces two types of tables to PostgreSQL: `Distributed tables` and `Reference tables`, These tables are initially created as regular PostgreSQL tables, and then they are converted by calling Citus-specific functions. So, to make AGE compatible we have to work on calling these functions in our AGE's source code. If these are enough we are good to go.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org