graphql-batch VS Spree Commerce

After recognizing the problem, we brainstormed options to offload some of the work onto the database server to ultimately reduce the Rails application’s memory consumption. One particularly promising avenue involved SQL window functions. After deciding to pursue SQL window functions, we started our work by considering the WindowKeyLoader example described in the graphql-batch repository.

Interesting, I've just been researching Dataloader implementations for Ruby and have between trying to decide between GraphQL::Dataloader, graphql-batch and BatchLoader. I'll give this a look as well. Can you also make API calls inside the loaders?

This is mainly addressed in the last thing but we cache pretty heavily on our REST APIs and for GraphQL we use the graphql-batch gem pretty heavily. Those two things can go a long way. Make sure you're using an APM like Scout to keep an eye on things and then debug the outliers.

A good system to study is Spree https://github.com/spree/spree. It has an inventory and billing system and supports different adjustments and sale configurations. If you don't want to use it wholesale it's a solid Rails application that does most of what you want so you can use it as solid inspiration.

Spree Commerce: https://spreecommerce.org/

Maybe Spree?

I'd say Solidus and Spree are you best options rather than trying to roll out you own ecommerce solution.

When I was working on that company, that mobile ordering app, Counterless, I looked a lot at codebases like Spree, the Spree Commerce codebase. And that's how I learned a lot about how do you model an order with line items and things like that? I saw some amazing things that helped me develop an understanding and save a ton of time by looking at oh, they have a state machine. What are the ways that an order transitions through all these different states as it gets processed and charged? And how do you track all of those things?