In my last company we had a project template which have a linear like sync engine implemented. One of the core requirement for that sync engine to work was Postgraphile, it ensure that we are not making backend api manually. This was the first time I can across Postgraphile and it was really fascinating. I don't have to create any GET endpoints to query data or POST endpoints to add new data, everything is done by Postgraphile.
But the problem I faced was Postgraphile only supports postgres for database and it can only be used in a node.js backend or as a standalone process.
So I am working on a port in Python which will support other databases and can be used with FastAPI, Flask or any other python backend framework.
So Far what I have done
- Automatically create schema for queries in sqlite
- Automatically create schema for queries in mariadb/mysql
- Provide ASGI app which can be mounted on a FastAPI application.
- Provide WSGI app which can be mounted on a Flask application. [Under testing now]
- Support query to any table
- Apollo Playground
I am inviting all to try it out and share their feedback.
Github: dshaw0004/pygraphile
Website: link
PyPi: pygraphile
Disclosure: AI is actively used during development of the package.
