René's URL Explorer Experiment


Title: sqlite3 .import command does not strip spaces from header column names · Issue #2442 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: sqlite3 .import command does not strip spaces from header column names · Issue #2442 · sqlitebrowser/sqlitebrowser

X Title: sqlite3 .import command does not strip spaces from header column names · Issue #2442 · sqlitebrowser/sqlitebrowser

Description: Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Browser GUI import function and strip embed...

Open Graph Description: Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Bro...

X Description: Details for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Bro...

Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/2442

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite3 .import command does not strip spaces from header column names","articleBody":"Details for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\nCreated a sqlite3 script to create NEW database tables using .import command.  \r\n\r\n#### What did you expect to see?\r\nExpected .import command to work exactly like DB Browser GUI import function and strip embedded spaces from input CSV column names. (e.g., \"PropertyGroup\", \"PropertyAddress\"\r\n\r\n#### What did you see instead?\r\nThe column names of the input CSV file were created WITHOUT stripping embedded spaces.  (e.g., \"Property Group\", \"Property Address\").  As the result, all subsequent SQL Select command scripts fail due to undefined column names. \r\n\r\nUseful extra information\r\n-------------------------\r\n> DB4S v3.12.0 [built for x86_64-little_endian-llp64] on Windows 10 (10.0) (winnt/10.0.19041) [x86_64]\r\n> using SQLite Version 3.32.2\r\n> and Qt 5.12.8\r\n> Have tested with SQLite3 versions 3.33 and 3.29","author":{"url":"https://github.com/rgward611","@type":"Person","name":"rgward611"},"datePublished":"2020-10-15T16:14:26Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/2442"}

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:94863828-74ea-f3ff-2b57-8cc7b1f9a31c
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA67A:1ED1B5:6ECA88:981CC4:6AFD339A
html-safe-noncea2156079c404e2931469f73a1d6bd1cc95b026ccb2b57243b5f461d1b4bf9a5a
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNjdBOjFFRDFCNTo2RUNBODg6OTgxQ0M0OjZBRkQzMzlBIiwidmlzaXRvcl9pZCI6Ijc0MzY2MTI2MjU0MTIzOTE5NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac7b30d6fa580de9937ce2b3b2311a6c144f8f27876bf25c85c5df892c75116f39
hovercard-subject-tagissue:722476460
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/2442/issue_layout
twitter:imagehttps://opengraph.githubassets.com/ce8c83d0db77aad48f46e0165856238ca46cbfff7e67ccb0249432c8660dcf98/sqlitebrowser/sqlitebrowser/issues/2442
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/ce8c83d0db77aad48f46e0165856238ca46cbfff7e67ccb0249432c8660dcf98/sqlitebrowser/sqlitebrowser/issues/2442
og:image:altDetails for the issue What did you do? Created a sqlite3 script to create NEW database tables using .import command. What did you expect to see? Expected .import command to work exactly like DB Bro...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamergward611
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/2442#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F2442
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%2F2442
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/2442
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/2442
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/2442
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/2442
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/2442
sqlite3 .import command does not strip spaces from header column nameshttps://github.com/sqlitebrowser/sqlitebrowser/issues/2442#top
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 15, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issue-722476460
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Oct 15, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-709490847
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 15, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-709499285
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-709664975
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-709689410
@chrisjlockehttps://github.com/chrisjlocke
https://sqlite.org/cli.html#csv_importhttps://sqlite.org/cli.html#csv_import
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-710071066
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-710100286
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-710111689
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-710123255
https://sqlite.org/forum/forummainhttps://sqlite.org/forum/forummain
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-710126165
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-710373783
@rgward611https://github.com/rgward611
justinclifthttps://github.com/justinclift
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Oct 16, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#event-3887669001
https://github.com/rgward611
rgward611https://github.com/rgward611
on Oct 17, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/2442#issuecomment-711019984
RFQ-4180https://tools.ietf.org/html/rfc4180
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/2442
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/2442
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.