Simon Binder comments

Results 746 comments of


                                            Simon Binder

`pragma legacy_alter_table = 1` not supported in Turso

sqlite, and libsql by extension, have a `user_version` pragma saved in the header of the database file. Drift is using that as a simple version number to record which schema...

`pragma legacy_alter_table = 1` not supported in Turso

Looks like this is not happening in Turso. I didn't want to touch the `alterTable` implementation too much to prevent accidentally breaking users with weird dependencies between tables and views....

adding simolus3 as a committer to this repo

Thanks! I don't think this would change how I contribute here that much since the review process stays the same, but not having to wait for my workflows to get...

Is `db_worker.js` needed when `SqliteConnection.synchronousWrapper(db)` is used instead of `SqliteDatabase(path: ..., ...)`?

I recommend not using `SqliteDatabase.singleConnection` outside of tests. It's correct that if you're using that API instead of the default open factory, you don't need a database worker. However, the...

Is `db_worker.js` needed when `SqliteConnection.synchronousWrapper(db)` is used instead of `SqliteDatabase(path: ..., ...)`?

Alright, I see 👍 For in-memory databases, `sqlite_async` is not really an appropriate package since it relies on WAL mode which doesn't work for those (we have `synchronousWrapper` and `singleConnection`...

Is `db_worker.js` needed when `SqliteConnection.synchronousWrapper(db)` is used instead of `SqliteDatabase(path: ..., ...)`?

`sqlite3_web` is web-only. On mobile you could use `package:sqlite3` and do the isolate management yourself to run queries asynchronously. But it might be easier to add an API to this...