Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Non JSON-backed tables #265

Open
davidmartos96 opened this issue Apr 5, 2025 · 0 comments
Open

Non JSON-backed tables #265

davidmartos96 opened this issue Apr 5, 2025 · 0 comments

Comments

@davidmartos96
Copy link
Contributor

Hello!
Just opening this because we were wondering how feasible would it be to not use JSON Sqlite views and have some way to use regular tables with typed columns.
On our app we noticed a really big drop in performance in some queries that were joining with a large static attached database. This happens even when using schema indexes with the powersync library.
Even if this non json mode required additional steps in the tooling, we would be open to look into it if feasible.
We've used plain Sqlite for 4+ years with the app and we would like to keep the performance we were having up until now, even if it required extra steps, like codegen or migrations.

Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant