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
Tried the plugin and works OK however I've noticed that the columns are being returned in alphabetical order whereas with the WASM version of SQLite and the SQLite Tools versions the columns are returned as they are structured in the database. This appeared to happen when using SELECT * or specifying the column order via SELECT. Neither the WASM or Plugin versions will allow dot commands (not sure about the newly introduced official WASM version from SQLite.org) but they can be emulated from the existing API's. With the plugin this breaks a bit with re-inserts/restores because the column order is messed up.
I have tried using the SQLite Tools binary with the shell command process and it looks the goods with all the normal SQLite features available (including dot commands, .tables, .dump, .schema, etc). Maybe the plugin can be adjusted to return the columns as normal SQLite binaries but for now I think using the shell process approach may be the best since there is less requirement to emulate unsupported features.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Tried the plugin and works OK however I've noticed that the columns are being returned in alphabetical order whereas with the WASM version of SQLite and the SQLite Tools versions the columns are returned as they are structured in the database. This appeared to happen when using SELECT * or specifying the column order via SELECT. Neither the WASM or Plugin versions will allow dot commands (not sure about the newly introduced official WASM version from SQLite.org) but they can be emulated from the existing API's. With the plugin this breaks a bit with re-inserts/restores because the column order is messed up.
I have tried using the SQLite Tools binary with the shell command process and it looks the goods with all the normal SQLite features available (including dot commands, .tables, .dump, .schema, etc). Maybe the plugin can be adjusted to return the columns as normal SQLite binaries but for now I think using the shell process approach may be the best since there is less requirement to emulate unsupported features.
Beta Was this translation helpful? Give feedback.
All reactions