AGE Viewer: How to display the contents of your Apache AGE database

SELECT * FROM cypher('citation_graph', $$
MATCH (v)
RETURN v
$$) as (v agtype);

v                                                                                                                                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 {"id": 844424930131970, "label": "Article", "properties": {"id": "williams2013towards", "year": 2013, "title": "Towards affective algorithmic composition", "author": ["Duncan Williams", "Alexis Kirke", "Eduardo R Miranda", "Etienne Roesch", "Slawomir Nasuto"], "publisher": "University of Jyväskylä, Department of Music"}}::vertex
 {"id": 844424930131971, "label": "Article", "properties": {"id": "schubert1999measurement", "year": 1999, "title": "Measurement and Time Series Analysis of Emotion in Music", "author": ["Emery Schubert"], "publisher": "University of New South Wales. Music & Music Education"}}::vertex
 {"id": 844424930131973, "label": "Article", "properties": {"id": "scherer2004which", "year": 2004, "title": "Which Emotions Can be Induced by Music? What Are the Underlying Mechanisms? And How Can We Measure Them?", "author": ["Klaus R. Scherer"], "publisher": "Journal of New Music Research"}}::vertex
 {"id": 844424930131974, "label": "Article", "properties": {"id": "gabrielsson2001emotion", "year": 2001, "title": "Emotion perceived and emotion felt: Same or different?", "author": ["Alf Gabrielsson"], "publisher": "Musicae Scientiae"}}::vertex
 {"id": 844424930131975, "label": "Article", "properties": {"id": "scherer2001emotional", "year": 2001, "title": "Emotional effects of music: Production rules", "author": ["Klaus Scherer", "Marcel Zentner"], "publisher": "Oxford University Press"}}::vertex
 {"id": 844424930131976, "label": "Article", "properties": {"id": "juslin2001communicating", "year": 2001, "title": "Communicating emotion in music performance: A review and a theoretical framework", "author": ["Patrik Juslin"], "publisher": "Oxford University Press"}}::vertex
 {"id": 844424930131977, "label": "Article", "properties": {"id": "williams2015dynamic", "year": 2015, "title": "Dynamic Game Soundtrack Generation in Response to a Continuously Varying Emotional Trajectory", "author": ["Duncan Williams", "Alexis Kirke", "Joel Eaton", "Eduardo Miranda", "Ian Daly", "James Hallowell", "Etienne Roesch", "Faustina Hwang", "Slawomir Nasuto"], "publisher": "Audio Engineering Society Conference: 56th International Conference: Audio for Games"}}::vertex
 {"id": 844424930131978, "label": "Article", "properties": {"id": "williams2015investigating", "year": 2015, "title": "Investigating Perceived Emotional Correlates of Rhythmic Density in Algorithmic Music Composition", "author": ["Duncan Williams", "Alexis Kirke", "Joel Eaton", "Eduardo Miranda", "Ian Daly", "James Hallowell", "James Weaver", "Asad Malik", "Etienne Roesch", "Faustina Hwang", "Slawomir Nasuto"], "publisher": "Association for Computing Machinery"}}::vertex
 {"id": 844424930131979, "label": "Article", "properties": {"id": "daly2015towards", "year": 2015, "title": "Towards human-computer music interaction: Evaluation of an affectively-driven music generator via galvanic skin response measures", "author": ["Duncan Williams", "Alexis Kirke", "Eduardo Miranda", "Ian Daly", "Faustina Hwang", "Slawomir Nasuto", "Asad Malik", "James Weaver"], "publisher": "2015 7th Computer Science and Electronic Engineering Conference (CEEC)"}}::vertex
 {"id": 844424930131980, "label": "Article", "properties": {"id": "kirke2013artificial", "year": 2013, "title": "Artificial affective listening towards a machine learning tool for sound-based emotion therapy and control", "author": ["Alexis Kirke", "Eduardo Miranda", "Slawomir Nasuto"], "publisher": "Proceedings of the Sound and Music Computing Conference"}}::vertex
 {"id": 844424930131981, "label": "Article", "properties": {"id": "kirke2012learningto", "year": 2012, "title": "Learning to Make Feelings: Expressive Performance as a part of a machine learning tool for sound-based emotion therapy and control", "author": ["Alexis Kirke", "Eduardo Miranda", "Slawomir Nasuto"], "publisher": "the 9th Intl Symp on Computer Music Modeling and Retrieval"}}::vertex
 {"id": 844424930131982, "label": "Article", "properties": {"id": "lopez2010real", "year": 2010, "title": "Real-Time Emotion-Driven Music Engine", "author": ["Alex Lopez", "Antonio Oliveira", "Amilcar Cardoso"], "publisher": "the 9th Intl Symp on Computer Music Modeling and Retrieval"}}::vertex
 {"id": 844424930131983, "label": "Article", "properties": {"id": "oliveira2008affective", "year": 2008, "title": "Affective-driven music production: selection and transformation of music", "author": ["Antonio Oliveira", "Amilcar Cardoso"], "publisher": "ARTECH"}}::vertex
 {"id": 844424930131984, "label": "Article", "properties": {"id": "oliveira2008modeling", "year": 2008, "title": "Modeling affective content of music: A knowledge base approach", "author": ["Antonio Oliveira", "Amilcar Cardoso"], "publisher": "Sound and Music Computing Conference"}}::vertex
 {"id": 844424930131985, "label": "Article", "properties": {"id": "livingstone2007controlling", "year": 2007, "title": "Controlling musical emotionality: an affective computational architecture for influencing musical emotions", "author": ["Steven R. Livingstone", "Ralf Mühlberger", "Andrew Brown", "Andrew Loch"], "publisher": "Digital Creativity"}}::vertex
 {"id": 844424930131986, "label": "Article", "properties": {"id": "livingstone2005dynamic", "year": 2005, "title": "Dynamic Response: Real-Time Adaptation for Music Emotion", "author": ["teven R. Livingstone", "Andrew Brown"], "publisher": "Creativity & Cognition Studios Press"}}::vertex
 {"id": 844424930131987, "label": "Article", "properties": {"id": "oliveira2009automatic", "year": 2009, "title": "Automatic manipulation of music to express desired emotions", "author": ["Antonio Oliveira", "Amilcar Cardoso"], "publisher": "Proceedings of the 6th Sound and Music Computing Conference"}}::vertex
 {"id": 844424930131969, "label": "Article", "properties": {"id": "williams2015affect", "year": 2015, "title": "Investigating affect in algorithmic composition systems", "author": ["Duncan Williams", "Alexis Kirke", "Eduardo R Miranda", "Etienne Roesch", "Ian Daly", "Slawomir Nasuto"], "publisher": "Psychology of Music"}}::vertex
 {"id": 844424930131988, "label": "Article", "properties": {"id": "russell1980circumplex", "year": 1980, "title": "A circumplex model of affect", "author": ["James Russel"], "publisher": "American Psychological Association"}}::vertex

cd age-viewer
npm run setup
npm run start

Connect URL: localhost

Connect Port: 5432

Database Name: papersdb

User Name: postgres

Password: 12345

SELECT * FROM cypher('citation_graph', $$
MATCH (a)
OPTIONAL MATCH (a)-[e]->(b)
RETURN a, e, b
$$) as (a agtype, e agtype, b agtype);