search

outerbase / studio

A lightweight SQLite graphical client on your browser. It also support connecting to LibSQL/Turso/rqlite
https://libsqlstudio.com
GNU Affero General Public License v3.0
336 stars 20 forks source link

fix: allow value type to mismatch with column type #145

Open rentalhost opened 1 month ago

rentalhost commented 1 month ago

Due to SQLite flexibility, we can store text in INTEGER fields, but this is currently impossible: when attempting to do so, the value is automatically converted to NULL.

Although this can be quite critical in some contexts, it is supported by SQLite as a 'non-bug'. If you already have fields with mismatched types, it becomes impossible to make any corrections because the value will always be converted to NULL. So, even though I'm personally not a big fan of this idea, it cannot be ignored.

vercel[bot] commented 1 month ago

@rentalhost is attempting to deploy a commit to the Mediaload Team on Vercel.

A member of the Team first needs to authorize it.