René's URL Explorer Experiment


Title: Prefetch block size creates unsafe grid selection! · Issue #1373 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Prefetch block size creates unsafe grid selection! · Issue #1373 · sqlitebrowser/sqlitebrowser

X Title: Prefetch block size creates unsafe grid selection! · Issue #1373 · sqlitebrowser/sqlitebrowser

Description: Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramifications of this setting? At a minimum, the Result...

Open Graph Description: Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramifications o...

X Description: Details for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramif...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Prefetch block size creates unsafe grid selection!","articleBody":"### Details for the issue\r\n\"View - Preferences - Database - Prefetch block size\" creates unsafe grid selection.\r\nAnd the ? tool does not work within the preferences dialog to describe the ramifications of this setting?\r\n\r\nAt a minimum, the Results window should state:\r\nXXX rows of YYY available returned in Nms from: select * from myDB;\r\n\r\nBetter is to return all rows when user clicks Select All [Ctrl+A] or clicks the upper left of the grid box.\r\nThis is tricky behavior.\r\nI understand the desire to limit rows for performance, but \"Select All\" must = \"All\". \r\nNot \"Select All loaded rows\".\r\n\r\n### Useful extra information\r\nSet the Prefetch to a smallish number like 500.\r\n\r\nExecute a SQL statement that returns more than 500.\r\nThe Results window tells the user XXX rows returned in Xms from: select * from myDB;\r\n\r\n- Select all resulting rows & cols - Copy to clipboard.\r\nResult = Only the prefetch amount of rows were selected and copied.\r\n\r\nScrolling beyond the prefetch amount appends additional prefetch rows.\r\nBut this is an intensive and unexpected operation to get \"all\" the returned rows.\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [x] DB4S has a bug\r\n- [x] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [x] Windows: ( _version:_10 Pro___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [x] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [x] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/sky5walk","@type":"Person","name":"sky5walk"},"datePublished":"2018-05-02T17:09:33Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1373"}

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:6be3d505-eec8-4c5c-7e33-de73d9079b49
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idA34E:126CB9:258205E:3437F90:6AFD4493
html-safe-nonce4e9aa022f163db4391df617cd5480c68f49f620c3afa5a4769bc8c3f7a67b13e
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBMzRFOjEyNkNCOToyNTgyMDVFOjM0MzdGOTA6NkFGRDQ0OTMiLCJ2aXNpdG9yX2lkIjoiNzU0ODcxNzI0Mjg2NzU5ODQ4MyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacb71330943472f1836af2b3bac571cab4a61432707be50230f0d202eaba4ae94f
hovercard-subject-tagissue:319637751
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/1373/issue_layout
twitter:imagehttps://opengraph.githubassets.com/764eefed6b049724e12d3a8a3b4f99e2997e9608f29236bccafdddece9fb1707/sqlitebrowser/sqlitebrowser/issues/1373
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/764eefed6b049724e12d3a8a3b4f99e2997e9608f29236bccafdddece9fb1707/sqlitebrowser/sqlitebrowser/issues/1373
og:image:altDetails for the issue "View - Preferences - Database - Prefetch block size" creates unsafe grid selection. And the ? tool does not work within the preferences dialog to describe the ramifications o...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamesky5walk
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/1373#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1373
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%2F1373
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/1373
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1373
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1373
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/1373
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1373
Prefetch block size creates unsafe grid selection!https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#top
https://github.com/mgrojo
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on May 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#issue-319637751
https://github.com/sqlitebrowser/sqlitebrowser#nightly-buildshttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
justinclifthttps://github.com/justinclift
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on May 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-1606275694
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#issuecomment-386094856
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on May 24, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#issuecomment-391882979
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on May 24, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#issuecomment-391901120
@sky5walkhttps://github.com/sky5walk
justinclifthttps://github.com/justinclift
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on May 24, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-1645558339
mgrojohttps://github.com/mgrojo
on Dec 15, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-2028547184
mgrojohttps://github.com/mgrojo
on Dec 15, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-2028548222
Load all data when select all is requestedhttps://github.com/sqlitebrowser/sqlitebrowser/commit/f2ff1472a8c1c649c4f22dcc22b59c2da9908b66
f2ff147https://github.com/sqlitebrowser/sqlitebrowser/commit/f2ff1472a8c1c649c4f22dcc22b59c2da9908b66
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Dec 15, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#issuecomment-447584596
@sky5walkhttps://github.com/sky5walk
mgrojohttps://github.com/mgrojo
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Dec 15, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-2028551974
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Dec 15, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#issuecomment-447584859
sky5walkhttps://github.com/sky5walk
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Dec 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-2033325587
mgrojohttps://github.com/mgrojo
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Dec 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1373#event-2034304423
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1373
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1373
mgrojohttps://github.com/mgrojo
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%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.