René's URL Explorer Experiment


Title: Sql insert command script execution issues · Issue #1378 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Sql insert command script execution issues · Issue #1378 · sqlitebrowser/sqlitebrowser

X Title: Sql insert command script execution issues · Issue #1378 · sqlitebrowser/sqlitebrowser

Description: Hello, Using the portable version of DB Browser for SQLite Version 3.10.1 (latest) to import a few thousands records (not exceeding of course the SQLITE_MAX_SQL_LENGTH or SQLITE_MAX_LENGTH limitations) in a version 3.x Sqlite database i ...

Open Graph Description: Hello, Using the portable version of DB Browser for SQLite Version 3.10.1 (latest) to import a few thousands records (not exceeding of course the SQLITE_MAX_SQL_LENGTH or SQLITE_MAX_LENGTH limitati...

X Description: Hello, Using the portable version of DB Browser for SQLite Version 3.10.1 (latest) to import a few thousands records (not exceeding of course the SQLITE_MAX_SQL_LENGTH or SQLITE_MAX_LENGTH limitati...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Sql insert command script execution issues","articleBody":"Hello,\r\n\r\nUsing the portable version of DB Browser for SQLite Version 3.10.1 (latest) to import a few thousands\r\nrecords (not exceeding of course the SQLITE_MAX_SQL_LENGTH or SQLITE_MAX_LENGTH limitations) in a\r\nversion 3.x Sqlite database i noticed the following issues :\r\n\r\nWhen loading an .sql file containing \"INSERT INTO tab1 (?,?,?) VALUES(?,?,?);\" commands from the \"Execute SQL\" tab of application's interface and clicking the \"Execute SQL\" to run the script there is no visual indication somewhere in the application's window e.g. a progress indicator in the status bar or at least an hour glass icon change for the mouse cursor to show that a script is currently running. Furthermore, the \"Write Changes\" button is enabled right after clicking the \"Execute SQL\" button whether or not the script ends successfully and no matter the commands contained in the script are included within a \"BEGIN TRANSACTION; COMMIT;\" block or not. Also, if the script runs successfully the execution status message reports affected records count wrongly and always says \"1 rows affected\" even if script contains more than one records and finally the execution status message takes some time(a few seconds) to appear after script completes its execution something very bad because if someone accidentaly clicks the \"Write Changes\" button before execution status message appears then only part of the inserted records is commited to the database opening data integrity issues.\r\n\r\nThank you very much.\r\n\r\n\r\nSystem used for running DB Browser for SQLite :\r\n\r\nWindows 7 Professional 64bit  ( fully updated )\r\nCPU: Intel Core i3 Quad Core 3.1GHz\r\nRam : 4GB\r\nDB Browser for SQLite version : SQLiteDatabaseBrowserPortable_3.10.1_English.paf.exe\r\n","author":{"url":"https://github.com/jimmyp2","@type":"Person","name":"jimmyp2"},"datePublished":"2018-05-08T08:49:27Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1378"}

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:dcdd423b-9c40-eaec-2e89-48f0307a01fe
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC1DA:3B38CF:2636D5F:354B475:6AFD44D8
html-safe-nonce8f68854e069c5f9710548101c49d04d753853a04c825d28c02b8cb25d507d642
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMURBOjNCMzhDRjoyNjM2RDVGOjM1NEI0NzU6NkFGRDQ0RDgiLCJ2aXNpdG9yX2lkIjoiOTAyMjQxMDg5NjgyNzA0MDk4NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmace7b8baef8576622e192addf32f7b96bd12621057ebe41a8184b1c24a2a278cf7
hovercard-subject-tagissue:321096759
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/1378/issue_layout
twitter:imagehttps://opengraph.githubassets.com/87996f7ae8abba9cdc524fa25c79499b2f657ba0685d83046660c9b0e1c10af9/sqlitebrowser/sqlitebrowser/issues/1378
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/87996f7ae8abba9cdc524fa25c79499b2f657ba0685d83046660c9b0e1c10af9/sqlitebrowser/sqlitebrowser/issues/1378
og:image:altHello, Using the portable version of DB Browser for SQLite Version 3.10.1 (latest) to import a few thousands records (not exceeding of course the SQLITE_MAX_SQL_LENGTH or SQLITE_MAX_LENGTH limitati...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamejimmyp2
hostnamegithub.com
expected-hostnamegithub.com
Nonebdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474
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
release556dd37bb0aceffb25724e151b5d858b3265b40b
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1378#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1378
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%2F1378
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/1378
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1378
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1378
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/1378
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1378
Sql insert command script execution issueshttps://github.com/sqlitebrowser/sqlitebrowser/issues/1378#top
https://github.com/mgrojo
SQLhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22SQL%22
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
https://github.com/jimmyp2
jimmyp2https://github.com/jimmyp2
on May 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#issue-321096759
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on May 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#issuecomment-387344651
https://nightlies.sqlitebrowser.org/latest/https://nightlies.sqlitebrowser.org/latest/
https://github.com/jimmyp2
jimmyp2https://github.com/jimmyp2
on May 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#issuecomment-387645301
mgrojohttps://github.com/mgrojo
on Jun 30, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#event-1710008880
mgrojohttps://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
SQLhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22SQL%22
on Jun 30, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#event-1710010437
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jul 25, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#issuecomment-407912276
@jimmyp2https://github.com/jimmyp2
https://nightlies.sqlitebrowser.org/latest/https://nightlies.sqlitebrowser.org/latest/
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jun 21, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#issuecomment-647151912
@jimmyp2https://github.com/jimmyp2
version 3.12.0https://sqlitebrowser.org/blog/version-3-12-0-released/
mgrojohttps://github.com/mgrojo
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jun 21, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/1378#event-3465666235
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1378
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1378
mgrojohttps://github.com/mgrojo
SQLhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22SQL%22
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
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.