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
Domain: github.com
{"@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-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:dcdd423b-9c40-eaec-2e89-48f0307a01fe |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C1DA:3B38CF:2636D5F:354B475:6AFD44D8 |
| html-safe-nonce | 8f68854e069c5f9710548101c49d04d753853a04c825d28c02b8cb25d507d642 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMURBOjNCMzhDRjoyNjM2RDVGOjM1NEI0NzU6NkFGRDQ0RDgiLCJ2aXNpdG9yX2lkIjoiOTAyMjQxMDg5NjgyNzA0MDk4NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | e7b8baef8576622e192addf32f7b96bd12621057ebe41a8184b1c24a2a278cf7 |
| hovercard-subject-tag | issue:321096759 |
| 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/1378/issue_layout |
| twitter:image | https://opengraph.githubassets.com/87996f7ae8abba9cdc524fa25c79499b2f657ba0685d83046660c9b0e1c10af9/sqlitebrowser/sqlitebrowser/issues/1378 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/87996f7ae8abba9cdc524fa25c79499b2f657ba0685d83046660c9b0e1c10af9/sqlitebrowser/sqlitebrowser/issues/1378 |
| og:image:alt | 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... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | jimmyp2 |
| hostname | github.com |
| expected-hostname | github.com |
| None | bdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474 |
| 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 | 556dd37bb0aceffb25724e151b5d858b3265b40b |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width