For this SBC round I’m digging in deep. My original plan was to rebuild Colorglyph directly into the Stellar mainnet and offer/asset system. However it quickly became clear that for that to actually work well or at all I’d need much better and more powerful access of the Stellar databases.
So I fired up a Horizon/Core Docker droplet and started building an API one request at a time.
This went on successfully right up until a wild idea hit me. With all the classes and structure from the PostgreSQL database would it be possible to essentially port right to GraphQL and not have to fool with all of these specific endpoints.
A little googling and I soon had https://github.com/postgraphql/postgraphql installed and delivering a fully featured GraphQL interface queuing anything and everything in the core and horizon databases.
This will change the game for Stellar frontend application development.
The rest of my time will be spent building up a wiki of useful boilerplate GraphQL queries as well as writing up a detailed tutorial for getting this set up on your own Stellar nodes.