Here are some suggestions if you ever need to scale.

https://github.com/pocketbase/pocketbase/discussions/395

Never happened to me. SQLite is faster than most people think. When you hit the limits of sqlite, chances are high that you can afford to use one of the scaling solutions mentioned above. Here are some benchmarks:

https://github.com/pocketbase/benchmarks?tab=readme-ov-file