You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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!
The text was updated successfully, but these errors were encountered:
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!
The text was updated successfully, but these errors were encountered: