Using Polyscale for database caching


For anyone using Fly’s postgres, I see Polyscale now support Fly :slightly_smiling_face:

They provide a database query cache. By routing your connection via them, they can cache the response. That avoids needing an additional cache, which adds complexity (purging a cache traditionally being one of the hardest problems). Your app can stay exactly the same but get an instant boost by just changing the connection string:

I’ve no connection to them. Just came across that on their blog and thought it looked neat.


Hey @greg - member of the PolyScale team here. Thanks for the post. Were pretty excited also by the possibilities of using Fly with external database providers which opens up a) the scope of viable databases (e.g. MS SQL Server), b) the range of database providers and c) users to move their app tier to Fly, without worrying about migrating their database if they choose not to.

That latter use case is where we are seeing customer interest.

We can roll out PolyScale to any Fly locations easily so feel free to reach out if there are any questions. Our team is also on Discord:

All the best, Ben.

1 Like

Hey @benh

No problem! I agree.

I found you last year looking for an elusive HTTP API :slightly_smiling_face: Only Planetscale wrote an interesting blog post. To summarise their conclusion: “An HTTP API is actually really good . In most tests, any version of HTTP was superior compared to the binary MySQL protocol.”.

1 Like

Does anyone have an example config to make polyscale work?
We are deployed to Fly, and using Neon with this config: Guide on connecting via Ecto - Framework Integrations - Neon
I am struggling with connecting to PolyScale.
The connection string with the appname does not seem to work at all.
I created a db user with the app name, but that has ssl issues with the config I put above.

@pacsni Well … I haven’t used Neon (still waiting on their pricing) but it should work. Scroll halfway down this page where they describe how to set up: – Supercharging Postgres on Neon with PolyScale

This isn’t really a Fly-issue so probably the best place to continue that discussion would be on Polyscale’s own forum/email.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.