age-viewer icon indicating copy to clipboard operation
age-viewer copied to clipboard

What are the features of Apache AGE Viewer?

Open shinhanbyeol opened this issue 1 year ago • 42 comments

shinhanbyeol avatar Sep 05 '22 04:09 shinhanbyeol

very excited for apache viewer project

MJinH avatar Sep 06 '22 00:09 MJinH

Bitnine used Apache AGE Viewer to implement its graph database as a service. https://bitnine.net/ag-cloud/

aked21 avatar Sep 06 '22 00:09 aked21

Excited to paticipate! Is there any guidance to start?

zhaojun-szh-9815 avatar Sep 12 '22 16:09 zhaojun-szh-9815

Fast analysis and real-time data processing. Can be provided as an extension to PostgreSQL.

Shonennn avatar Sep 12 '22 16:09 Shonennn

Interested in getting started

segarciat avatar Sep 12 '22 16:09 segarciat

Look forward to getting started

Henry417E1610 avatar Sep 12 '22 17:09 Henry417E1610

Ready to get started !

kunal-geeks avatar Sep 12 '22 17:09 kunal-geeks

Feeling great to be a part of this.

devinpi avatar Sep 12 '22 17:09 devinpi

Ready to get started!

shirinmk avatar Sep 12 '22 18:09 shirinmk

I am ready to get started.

she11fish avatar Sep 12 '22 19:09 she11fish

i'm very excited for apache viewer project

beniaXcode avatar Sep 12 '22 19:09 beniaXcode

Ready to get started.

kwu5 avatar Sep 12 '22 20:09 kwu5

Look forward to getting started

ChloeGwon avatar Sep 12 '22 21:09 ChloeGwon

Hey, I'm interested in contributing.

andyb2 avatar Sep 15 '22 15:09 andyb2

Hi, I'm interested.

teshyoma avatar Sep 15 '22 15:09 teshyoma

Hello everyone, I'm gonna share some useful information regarding the features of AGE Viewer.

The fundamentals of AGE Viewer can be seen on AG Cloud Express available at AG Cloud Express

AG Cloud Express is a cloud-based graph visualization software that introduces graph analytical experience for graph beginners. Within the software includes AG Viewer, the core tech AGE Viewer will take root from and evolve.

The features inside the AG Cloud Express includes:

  1. Built in datasets (Projects) like Movies data and Fraud Detection
  2. Understanding graph db and cypher
  3. advanced cypher tutorial

The link below tells you how to login, add a new project (sample datasets), where to type in cypher queries, and other features available at the AG Viewer. AG Viewer Tutorial Blog

If you need a video tutorial for better understanding, refer to the video below. AGCE Video Tutorial

Last but not least, you may find the projects in AG Cloud Express a bit lacking. If you would like to import your csv files and play around with nodes and edges for a bit, try looking at the csv tutorial guides below. There are certain requirements to making a CSV file compatible for AG Cloud Express, so be sure to refer to the guides below. How to import csv in ag cloud express Import data ag cloud express

jbiz805 avatar Sep 19 '22 07:09 jbiz805

Actually when I am trying to open links above gave me 403 forbidden error! Thanks

shirinmk avatar Sep 20 '22 04:09 shirinmk

It's working fine for me, but if the current links above don't work, try copy-pasting the links below.

AG Cloud Express https://agcloud.bitnine.net/

AG Viewer Tutorial Blog https://bitnine.net/blog-useful-information/tutorial-ag-cloud-express-movies/

AGCE Video Tutorial https://bitnine.net/blog-useful-information/tutorial-analyzing-movie-data-with-ag-cloud-express-opencypher/

How to import csv in ag cloud express https://www.youtube.com/watch?v=8S1IJswl7Lg

Import Data ag cloud express https://bitnine.net/blog-useful-information/import-data-ag-cloud-express/

jbiz805 avatar Sep 20 '22 06:09 jbiz805

Please assign this to me as well.

arun-esh avatar Sep 20 '22 21:09 arun-esh

Hello everyone, I'd like to share how to run pgAdmin using docker for those who might have difficulty in connecting database.

First, you need to install docker. Here's a link for downloading docker: https://www.docker.com/. You can simply click the download button on the home page.

After downloading it, in order to make sure the download was successful, you can run the following command in your terminal: docker version

Now run the following command in your terminal to create a docker container with apache image: docker run -d --name AGEDB -e POSTGRES_USER=age -e POSTGRES_PASSWORD=age -p 5432:5432 apache/age:latest

After creating a new container, now we need to access the pgAdmin4 to set up the postgreSQL connection and use if for the pgAdmin Docker setup. Select Servers -> Register -> Server

The Name under the General tap is not essential which name you enter in the filed name as this is only for the organization within the tool. Click on the "Connection" tab, and in the field "username", "password", you will use the username and password that you specified in your docker compose.

Here's how I did

Name -> AGEDB Host name/address -> localhost Port -> 5432 Maintenance database -> age username -> age password -> age

Now the connection to the database has been established, We can now run AGE Viewer program using "npm run start" command and enter host, username, password that we specified in connection.

This link might be helpful and give you more idea how to set up the connection using Docker: https://towardsdatascience.com/how-to-run-postgresql-and-pgadmin-using-docker-3a6a8ae918b5

MJinH avatar Sep 21 '22 06:09 MJinH

Excited to be part of this project.

samsulai avatar Sep 21 '22 09:09 samsulai

To be assigned

samsulai avatar Sep 21 '22 20:09 samsulai

Hello everyone, I'd like to share how to run pgAdmin using docker for those who might have difficulty in connecting database.

First, you need to install docker. Here's a link for downloading docker: https://www.docker.com/. You can simply click the download button on the home page.

After downloading it, in order to make sure the download was successful, you can run the following command in your terminal: docker version

Now run the following command in your terminal to create a docker container with apache image: docker run -d --name AGEDB -e POSTGRES_USER=age -e POSTGRES_PASSWORD=age -p 5432:5432 apache/age:latest

After creating a new container, now we need to access the pgAdmin4 to set up the postgreSQL connection and use if for the pgAdmin Docker setup. Select Servers -> Register -> Server

The Name under the General tap is not essential which name you enter in the filed name as this is only for the organization within the tool. Click on the "Connection" tab, and in the field "username", "password", you will use the username and password that you specified in your docker compose.

Here's how I did

Name -> AGEDB Host name/address -> localhost Port -> 5432 Maintenance database -> age username -> age password -> age

Now the connection to the database has been established, We can now run AGE Viewer program using "npm run start" command and enter host, username, password that we specified in connection.

This link might be helpful and give you more idea how to set up the connection using Docker: https://towardsdatascience.com/how-to-run-postgresql-and-pgadmin-using-docker-3a6a8ae918b5

Just a quick question, what is the graph path in AGViewer?

Henry417E1610 avatar Sep 22 '22 07:09 Henry417E1610

Hello everyone, I'd like to share how to run pgAdmin using docker for those who might have difficulty in connecting database. First, you need to install docker. Here's a link for downloading docker: https://www.docker.com/. You can simply click the download button on the home page. After downloading it, in order to make sure the download was successful, you can run the following command in your terminal: docker version Now run the following command in your terminal to create a docker container with apache image: docker run -d --name AGEDB -e POSTGRES_USER=age -e POSTGRES_PASSWORD=age -p 5432:5432 apache/age:latest After creating a new container, now we need to access the pgAdmin4 to set up the postgreSQL connection and use if for the pgAdmin Docker setup. Select Servers -> Register -> Server The Name under the General tap is not essential which name you enter in the filed name as this is only for the organization within the tool. Click on the "Connection" tab, and in the field "username", "password", you will use the username and password that you specified in your docker compose. Here's how I did Name -> AGEDB Host name/address -> localhost Port -> 5432 Maintenance database -> age username -> age password -> age Now the connection to the database has been established, We can now run AGE Viewer program using "npm run start" command and enter host, username, password that we specified in connection. This link might be helpful and give you more idea how to set up the connection using Docker: https://towardsdatascience.com/how-to-run-postgresql-and-pgadmin-using-docker-3a6a8ae918b5

Just a quick question, what is the graph path in AGViewer?

After accessing db using Pgadmin, etc., run the query below to create a graph path SELECT * FROM ag_catalog.create_graph('graph_name');

Please refer to the document for more information https://age.apache.org/age-manual/master/intro/graphs.html#create-a-graph

shinhanbyeol avatar Sep 22 '22 07:09 shinhanbyeol

I believe the graph path is just the path name of graph, so it can be the name of any graph. After connecting to the database, the connection status will be displayed.

Here's my connection status:

You are connected as user age to localhost:5432/age Graph path has been set to Jin

(In this case, I specified Jin for graph path and it still worked)

MJinH avatar Sep 22 '22 08:09 MJinH

Hello everyone, I'd like to share how to run pgAdmin using docker for those who might have difficulty in connecting database. First, you need to install docker. Here's a link for downloading docker: https://www.docker.com/. You can simply click the download button on the home page. After downloading it, in order to make sure the download was successful, you can run the following command in your terminal: docker version Now run the following command in your terminal to create a docker container with apache image: docker run -d --name AGEDB -e POSTGRES_USER=age -e POSTGRES_PASSWORD=age -p 5432:5432 apache/age:latest After creating a new container, now we need to access the pgAdmin4 to set up the postgreSQL connection and use if for the pgAdmin Docker setup. Select Servers -> Register -> Server The Name under the General tap is not essential which name you enter in the filed name as this is only for the organization within the tool. Click on the "Connection" tab, and in the field "username", "password", you will use the username and password that you specified in your docker compose. Here's how I did Name -> AGEDB Host name/address -> localhost Port -> 5432 Maintenance database -> age username -> age password -> age Now the connection to the database has been established, We can now run AGE Viewer program using "npm run start" command and enter host, username, password that we specified in connection. This link might be helpful and give you more idea how to set up the connection using Docker: https://towardsdatascience.com/how-to-run-postgresql-and-pgadmin-using-docker-3a6a8ae918b5

Just a quick question, what is the graph path in AGViewer?

After accessing db using Pgadmin, etc., run the query below to create a graph path SELECT * FROM ag_catalog.create_graph('graph_name');

Please refer to the document for more information https://age.apache.org/age-manual/master/intro/graphs.html#create-a-graph

awesome!

samsulai avatar Sep 22 '22 15:09 samsulai

I believe the graph path is just the path name of graph, so it can be the name of any graph. After connecting to the database, the connection status will be displayed.

Here's my connection status:

You are connected as user age to localhost:5432/age Graph path has been set to Jin

(In this case, I specified Jin for graph path and it still worked)

Got it, then next step is to run backend? As localhost:5432 is not available. Also I had trouble with running backend due to the additional logging output, and when I update it, there is the same issue for running frontend as well.

Henry417E1610 avatar Sep 22 '22 16:09 Henry417E1610

Looking forward to working with everyone!

taysir-alam avatar Sep 23 '22 22:09 taysir-alam

Hello! I have ran into another problem. When I shut down my laptop last night and started it today, even though I made connections on both docker and pgadmin, how come the connection failed after entering the connection informations we've made previously? Thanks in advance!

Henry417E1610 avatar Sep 25 '22 17:09 Henry417E1610

Looking forward to working with everyone!

ahmadqasembader avatar Sep 26 '22 16:09 ahmadqasembader