Apache Age support, A Graph extension for postgresql.

[sumitsharansatsangi]

Apache Age is a graph extension for postgresql.
For more info, visit https://age.apache.org/docs/

Using psycopg2, there is an driver for python .
For more info visit https://pypi.org/project/apache-age-python/

Future is with the Graph and async.
So, it will be great if piccolo can support this .

This feature can make piccolo of the next level.

[sinisaos]

@sumitsharansatsangi I don't know anything about Apache AGE but Piccolo uses asyncpg database driver and Apache AGE requirements are Psycopg2 driver so I think for now it is not possible.

[sumitsharansatsangi]

Sorry, Not known that it supports only Psycopg2.

Thanks for quick response and contributing to the nice project.

[sinisaos]

No worries and thanks for the kind words. There is issue about asyncpg but as I understand there is limited support. I have no experience with GraphQL and maybe @dantownsend would know more about it, but if you need GraphQL, maybe you can try this. It uses Orator ORM, but you can modify it to use Piccolo ORM and it works. Piccolo ORM has a really neat feature create_pydantic_model that can help you easily create Pydantic models from Piccolo Table and then use it in previous example.