drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: Support for planetscale boost

Open
#2,880 0 comments 1 reaction 0 assignees View on GitHub
driver/planetscale enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Describe what you want

Hi drizzle team!

We use a planetscale DB, and we use drizzle's planetscale driver to connect to the DB. We recently had a need to use planetscale boost, but currently drizzle's planetscale integration doesn't seem to have an option to support planetscale boost.
We can use it by running the `SET @@boost_cached_queries = true` query directly, but I don't know if there is a way to run that query in the same connection, when using drizzle's query or select api (maybe using a transaction could work, but I haven't tested that yet)
It seems quite hard to control session explicitly because planetscale Client object basically establishes new connection for each execution and the drizzle wrapper doesn't expose the session object directly.

If possible, could you please support an official option for planetscale boost? Thanks.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.