René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:75b600a0-3a2c-3dbd-9550-41095901a719
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC8F6:3546A:BB558:FC2D3:6AFD2BEF
html-safe-nonce80c3fc3e4c36bbcdbbe182587b475269060ae13009ed7a14b0babb19060ed69d
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDOEY2OjM1NDZBOkJCNTU4OkZDMkQzOjZBRkQyQkVGIiwidmlzaXRvcl9pZCI6IjQxODI0MDcyMDg2NzMwMjkxMDMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacfece54147879765ae7f197cdc67bb0d153e6f81a197bd84cfed556ce39fddf17
hovercard-subject-tagissue:325423539
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1395/issue_layout
twitter:imagehttps://opengraph.githubassets.com/51518c061ee29fdf9697200478be9d11fb022a6cc40f537b49623aeadc4dee46/sqlitebrowser/sqlitebrowser/issues/1395
twitter:cardsummary_large_image
og:imagehttps://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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameMKleusberg
hostnamegithub.com
expected-hostnamegithub.com
None065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release941021edf0c2ec58298f4a2c8f27ae507d129c92
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1395#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1395
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1395
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1395
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1395
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1395
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1395
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1395
Better default options and configuration for the CSV importhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1395#top
https://github.com/MKleusberg
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 22, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issue-325423539
@karimhttps://github.com/karim
#1349https://github.com/sqlitebrowser/sqlitebrowser/pull/1349
MKleusberghttps://github.com/MKleusberg
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on May 22, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#event-1640124850
MKleusberghttps://github.com/MKleusberg
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
on May 22, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#event-1640124856
MKleusberghttps://github.com/MKleusberg
on May 22, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#event-1640124863
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 22, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-391112270
#1382https://github.com/sqlitebrowser/sqlitebrowser/issues/1382
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 22, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-391112822
#1347https://github.com/sqlitebrowser/sqlitebrowser/issues/1347
MKleusberghttps://github.com/MKleusberg
on May 25, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#event-1647304620
Implement better default behaviour for CSV importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/e851c161d6c970a46e07cb0b222cf45d4ede3114
e851c16https://github.com/sqlitebrowser/sqlitebrowser/commit/e851c161d6c970a46e07cb0b222cf45d4ede3114
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 25, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-392154933
@karimhttps://github.com/karim
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-395472291
@justinclifthttps://github.com/justinclift
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-395476665
MKleusberghttps://github.com/MKleusberg
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#event-1669037197
Implement better default behaviour for CSV importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/a8ea0ad239d873ae6f9708089999758717b8e2ce
a8ea0adhttps://github.com/sqlitebrowser/sqlitebrowser/commit/a8ea0ad239d873ae6f9708089999758717b8e2ce
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#issuecomment-395486970
MKleusberghttps://github.com/MKleusberg
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1395#event-1669048001
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1395
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1395
MKleusberghttps://github.com/MKleusberg
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.