Title: Better default options and configuration for the CSV import · Issue #1395 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Better default options and configuration for the CSV import · Issue #1395 · sqlitebrowser/sqlitebrowser
X Title: Better default options and configuration for the CSV import · Issue #1395 · sqlitebrowser/sqlitebrowser
Description: @karim came up with a good default behaviour for the CSV import in #1349: I just want to say something. 😃 Regarding the expected behavior of DB4S when importing empty values from a CSV. If the column has a default value then it gets prio...
Open Graph Description: @karim came up with a good default behaviour for the CSV import in #1349: I just want to say something. 😃 Regarding the expected behavior of DB4S when importing empty values from a CSV. If the colu...
X Description: @karim came up with a good default behaviour for the CSV import in #1349: I just want to say something. 😃 Regarding the expected behavior of DB4S when importing empty values from a CSV. If the colu...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1395
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Better default options and configuration for the CSV import","articleBody":"@karim came up with a good default behaviour for the CSV import in #1349:\r\n\r\n> I just want to say something. :smiley: \r\n> \r\n> Regarding the expected behavior of DB4S when importing empty values from a CSV.\r\n> \r\n> 1. If the column has a **default value** then it gets priority over everything else.\r\n> - This is the default action for SQLite, it fills columns with default values when a value is not given.\r\n> - The column being `NOT NULL` or not doesn't matter, since a *value* will be set for it anyway.\r\n> - :heavy_check_mark: No need for a checkbox, it should be the right thing to do. :+1:\r\n> 2. If the column does not have a default value.\r\n> 1. Check if the column does **not** have `NOT NULL`, if true:\r\n> - Then just add `NULL` to it, it should be the default.\r\n> - Be consistent. CSV value is `NULL`, SQLite table doesn't forbid `NULL`, so just add `NULL`.\r\n> - :heavy_check_mark: Also, no need for a checkbox, and this is what everyone here wants. :tada:\r\n> 2. Else if it does have `NOT NULL`, then we have two options, either:\r\n> 1. Fail the import (make sense since you are importing `NULL` to a `NOT NULL` column), or\r\n> 2. Set a default value for it (e.g. `0` for `INTEGER`, `\"\"` for `TEXT`)\r\n> - Probably by adding a checkbox to \"set default values for empty fields in NOT NULL columns\" (need a better wording :smile:)\r\n\r\n\r\nWe should implement some rules in the import code to reflect this and maybe add some configuration options to make any deviation from this default an explicit decision by the user.","author":{"url":"https://github.com/MKleusberg","@type":"Person","name":"MKleusberg"},"datePublished":"2018-05-22T19:01:59Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1395"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:75b600a0-3a2c-3dbd-9550-41095901a719 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C8F6:3546A:BB558:FC2D3:6AFD2BEF |
| html-safe-nonce | 80c3fc3e4c36bbcdbbe182587b475269060ae13009ed7a14b0babb19060ed69d |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDOEY2OjM1NDZBOkJCNTU4OkZDMkQzOjZBRkQyQkVGIiwidmlzaXRvcl9pZCI6IjQxODI0MDcyMDg2NzMwMjkxMDMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | fece54147879765ae7f197cdc67bb0d153e6f81a197bd84cfed556ce39fddf17 |
| hovercard-subject-tag | issue:325423539 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1395/issue_layout |
| twitter:image | https://opengraph.githubassets.com/51518c061ee29fdf9697200478be9d11fb022a6cc40f537b49623aeadc4dee46/sqlitebrowser/sqlitebrowser/issues/1395 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/51518c061ee29fdf9697200478be9d11fb022a6cc40f537b49623aeadc4dee46/sqlitebrowser/sqlitebrowser/issues/1395 |
| og:image:alt | @karim came up with a good default behaviour for the CSV import in #1349: I just want to say something. 😃 Regarding the expected behavior of DB4S when importing empty values from a CSV. If the colu... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | MKleusberg |
| hostname | github.com |
| expected-hostname | github.com |
| None | 065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 941021edf0c2ec58298f4a2c8f27ae507d129c92 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width