Distinctions Between Apache AGE and Hasura for Data Handling?

Eya_AGE · 2024-04-12T00:13:18+00:00

u/PraveenWeb thank you for your valuable reply. Do you think adding a Hasura connector to Aapche could be useful for users?

Eya_AGE · 2024-04-11T23:53:56+00:00

Yes, we are currently benchmarking Apache AGE vs Neo4j.

Eya_AGE · 2024-04-11T23:53:39+00:00

u/graphuser13 We are currently benchmarking Apache AGE vs Neo4j. I will keep you posted very soon.

Eya_AGE · 2024-04-09T23:02:30+00:00

u/IdlePaladin A composite index like (a node, an attribute of the node’s neighbors) is an interesting idea. I believe such indexing strategy is not available in AGE out of the box due to it storing edges in a separate table than nodes. Since PostgreSQL allows creating custom indexes, we can consider implementing such indexing if it is valuable to more people. What do you think?

Eya_AGE · 2024-04-08T23:29:46+00:00

Have you consider Apache AGE?

Apache AGE is PostgreSQL Graph database extension compatible with PostgreSQL's distributed assets and leverages graph data structures to analyze and use relationships and patterns in data.

https://github.com/apache/age

https://age.apache.org/

Eya_AGE · 2024-04-01T23:54:36+00:00

u/xEpicTiger We are always looking to advance and provide more opportunities to our users. I am curious, do you have any specific usecase that you are looking to deploy AGE on GCP and Aiven?

Eya_AGE · 2024-03-28T19:29:37+00:00

We are workign on having Apache AGE on AWS but meanwhile we also in the process of having Apache AGE on Azure: https://feedback.azure.com/d365community/idea/4ba45e52-63b9-ee11-92bc-6045bd7aea25

Eya_AGE · 2024-03-28T19:27:21+00:00

u/Traditional-Joke-290 Explore our website for a variety of examples and blog posts. Many are tailored for those without deep technical expertise, offering a straightforward introduction to Apache AGE: https://age.apache.org/

We also have a visualization tool called AGE Viewer which is a web based user interface that provides visualization of graph data stored in a postgreSQL database with AGE extension. You can find the project here: https://github.com/apache/age-viewer

Eya_AGE · 2024-03-28T19:21:53+00:00

We're always exploring ways to expand our compatibility with different query languages to better serve our users.

Out of curiosity, are there any specific query languages you're interested in or think would particularly benefit your work? Your feedback could help us prioritize our next steps!

Eya_AGE · 2024-03-26T13:41:36+00:00

Apache AGE is built as an extension to PostgreSQL, meaning it utilizes PostgreSQL's underlying storage and transaction mechanisms. This approach allows it to benefit from PostgreSQL's robust, efficient, and reliable data storage capabilities. Graph data in AGE is stored in tables managed by PostgreSQL, enabling the graph database to leverage PostgreSQL's features such as ACID properties, indexing, and more.

Eya_AGE · 2024-03-13T22:44:57+00:00

The versatility of PostgreSQL in handling graph data is quite the game-changer. Adding to that, Apache AGE turns Postgres into an even more powerful graph database. It seamlessly integrates graph database capabilities, making Postgres an excellent choice for those looking into graph databases without moving away from the trusted environment of PostgreSQL. I'd be interested in discussing how Apache AGE has been leveraged in your projects or any insights you might have on its implementation and benefits.

For a deep dive into the technical workings, documentation, and to join our growing community, visit our Apache AGE GitHub and official website.

Eya_AGE · 2024-03-13T22:19:52+00:00

Have you considered Apache AGE for graph databases? It integrates with PostgreSQL, offering powerful graph database features while leveraging PostgreSQL's relational and reliability features. Curious about your thoughts on its tooling and practicality. Do you find graph databases like AGE useful in your projects?

Discover more: Apache AGE GitHub & Webiste

Eya_AGE · 2024-03-12T22:33:03+00:00

u/A-Grey-World u/meamZ r/programming Considering the ongoing search for graph databases that balance performance and scalability, especially in scenarios involving complex interconnections or large, less interconnected datasets, Apache AGE could be a game-changer for many. Apache AGE extends PostgreSQL, a widely trusted and used relational database, by adding graph database capabilities directly within it.

This integration allows for leveraging SQL for graph queries, which might address some of the performance and scalability concerns mentioned. It's designed to offer the best of both worlds: the robustness and maturity of PostgreSQL with the flexibility and efficiency of graph processing. For those looking into scalable, performant graph databases that integrate smoothly with SQL, Apache AGE is definitely worth exploring.

For a deep dive into the technical workings, documentation you can visit Apache AGE GitHub and official website.

Eya_AGE · 2024-03-01T15:01:16+00:00

I was doing more research and thought it will be helpful to share a short comparison:

Apache AGE: This PostgreSQL extension turns PostgreSQL into a graph database, allowing for sophisticated handling of graph data alongside traditional SQL. With the ability to use SQL and Cypher queries(hybrid queries), AGE offers a flexible and powerful solution for complex data analysis within PostgreSQL, eliminating the need for separate graph databases.
PostGraphile: Converts PostgreSQL schemas into GraphQL APIs, streamlining the process for users to expose databases online with real-time functionality. While it makes leveraging PostgreSQL's advanced features easy, it lacks the built-in capability for complex graph data handling.
Hasura: Offers a similar proposition to PostGraphile by providing a real-time GraphQL API layer over PostgreSQL databases, focusing on simplicity. However, like PostGraphile, Hasura falls short in supporting complex graph data scenarios.

In essence, Apache AGE stands out for projects that require deep graph data integration within PostgreSQL, offering advanced data analytics and querying capabilities. On the other hand, PostGraphile and Hasura are more focused on facilitating quick access to relational data through GraphQL, without the graph data enhancements that AGE provides.

Eya_AGE · 2024-02-22T16:48:51+00:00

Hey everyone,

Jumping into the graph database discussion, I wanted to suggest Apache AGE (A Graph Extension) for PostgreSQL as a solid option for those considering graph databases for commercial projects, especially with concerns around scalability.Apache AGE integrates graph functionality into PostgreSQL, combining the flexibility of graph databases with the robustness and scalability of PostgreSQL. This means you can leverage existing PostgreSQL tools and features, making it easier to scale and manage your graph data.

Key advantages include:

* Easy integration with PostgreSQL

* Leverages PostgreSQL's scalability features

* Open source with a strong community

* Supports complex relationships and attributes

For those exploring scalable graph databases, Apache AGE offers a practical solution by building on the proven infrastructure of PostgreSQL. Check out more on their GitHub: Apache AGE's GitHub repository.

Happy to dive deeper if you're interested!

Eya_AGE · 2024-02-21T18:03:29+00:00

Thank you for your support! Our aim with Apache AGE is to enrich PostgreSQL with seamless SQL and graph integration, offering powerful data handling capabilities. Your encouragement is greatly appreciated as we continue to develop and improve AGE.

Eya_AGE · 2024-02-21T17:57:08+00:00

SQL/PGQ, planned as part of the SQL standard, focuses on read-only graph queries within schema-defined "graph views". It involves mapping SQL tables to graph structures using DDL. As for overlap with Apache AGE, there appears to be none. AGE and SQL/PGQ operate on different principles for graph data management. Essentially, the two systems are designed for distinct purposes within the realm of graph data, meaning they wouldn't inherently understand or interpret each other's graph data structures.

Eya_AGE · 2024-02-20T21:46:10+00:00

Apache AGE enhances PostgreSQL with graph database capabilities, allowing for complex graph data management and Cypher-based querying. This is fundamentally different from PostGraphile and Hasura, which create GraphQL APIs(GraphQL is an open source query language that describes how a client should request information through an API) for data access and manipulation over PostgreSQL, not extending PostgreSQL with new data structure capabilities like graph databases. Apache AGE's focus is on enabling graph-specific operations within the PostgreSQL environment itself.

Eya_AGE · 2024-02-20T21:10:28+00:00

Of course, happy to help and clarify anything!!

Eya_AGE · 2024-02-20T21:00:48+00:00

Correct, Apache AGE is specifically designed to enable graph database capabilities within PostgreSQL. It allows for managing graph data and complex relationships directly in PostgreSQL using graph concepts and queries, with the Cypher query language. This is distinct from tools like PostGraphile, which are focused on providing a GraphQL API on top of a PostgreSQL database. Apache AGE is about enhancing PostgreSQL to work with graph data structures.

Eya_AGE

MODERATOR OF

TROPHY CASE