Skip to content

Non JSON-backed tables #265

Open
Open
@davidmartos96

Description

@davidmartos96

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions