Prepared statements in wa-sqlite are not cached

[gorbak25]

electric/clients/typescript/src/drivers/wa-sqlite/database.ts

Line 45 in d385d3c

prepared = await this.sqlite3.prepare_v2(

prepare_v2 generates a new query plan every time it's called. Consider keeping a cache of prepared statements.

[samwillis]

Amusingly I've been looking a little into this this afternoon. 🤣

Compiled prepared statements include a query plan, and so we probably want to clear any cache whenever migrations are applied.

[gorbak25]

@samwillis sqlite invalidates the query plan in prepared statements when the schema changes. The query plan will be regenerated when you will try to execute a query(calling sqlite_step). No special handling is required.