With the right approach, performance can be good. My co-founder wrote this overview of SQLite performance optimizations: https://www.powersync.co/blog/sqlite-op

With the right approach, performance can be good. My co-founder wrote this overview of SQLite performance optimizations: https://www.powersync.co/blog/sqlite-optimizations-for-ultra-high-performance https://www.powersync.co/blog/sqlite-optimizations-for-ultra...