René's URL Explorer Experiment


Title: [Discussion] Multi-column sorting · Issue #1409 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: [Discussion] Multi-column sorting · Issue #1409 · sqlitebrowser/sqlitebrowser

X Title: [Discussion] Multi-column sorting · Issue #1409 · sqlitebrowser/sqlitebrowser

Description: at the suggestion of @justinclift , I'm including some thoughts on implementation. Bearing in mind I have zero familiarity with the code: It occurs to me this is a more complex issue than I would have thought. The log view suggests that ...

Open Graph Description: at the suggestion of @justinclift , I'm including some thoughts on implementation. Bearing in mind I have zero familiarity with the code: It occurs to me this is a more complex issue than I would h...

X Description: at the suggestion of @justinclift , I'm including some thoughts on implementation. Bearing in mind I have zero familiarity with the code: It occurs to me this is a more complex issue than I wou...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Discussion] Multi-column sorting","articleBody":"at the suggestion of @justinclift , I'm including some thoughts on implementation.\r\nBearing in mind I have zero familiarity with the code:\r\n\r\nIt occurs to me this is a more complex issue than I would have\r\nthought.\r\n\r\nThe log view suggests that column sorting is implemented by executing\r\nan SQL query with \"ORDER BY\". The sort appears to be stable with\r\nrespect to table ordering, but the SQL standard explicitly states that\r\nit is not a stable sort because a table is not defined as having an\r\nordering. So how do you achieve a multi-column sort? You could keep\r\ntrack of column sorts and write a multi-column SQL statement, but this\r\nis pretty clunky. How far back in the list do you go? How does a user\r\nclear the list to get a sort on a single col? And of course, sorting\r\nthe same column twice in a row reverses the order, but what would that\r\nmean if we are keeping track?\r\n\r\nAnother approach would be to create a temporary table with the sort\r\ncommand and count on the fact the sqlite appears to use a stable sort.\r\nThis would die if sqlite ever dropped a stable sort because the\r\nstandard doesn't require it. Also, using a temporary table creates a\r\nproblem with the delete record button, since we're now viewing a temp\r\ntable, not the actual table in the database. \r\n\r\nI suspect the best solution would be a sort dialog, kind of like\r\nexcel. You select the columns you want to sort and the direction\r\n(up/down). This dialog then generates the appropriate SQL command.\r\nOf course, you probably know all this already and that's why it hasn't\r\nbeen implemented.","author":{"url":"https://github.com/Llaves","@type":"Person","name":"Llaves"},"datePublished":"2018-06-03T17:58:28Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1409"}

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:a104155b-1743-ec4d-e366-9f32bdb77cb1
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idAA2C:2BF4F6:3D300:50637:6AFD39D1
html-safe-noncebcb107979dd002287cac65450e4b14fd2be9342f796c1f58aa80a9461a233e45
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBQTJDOjJCRjRGNjozRDMwMDo1MDYzNzo2QUZEMzlEMSIsInZpc2l0b3JfaWQiOiI1NjAyMDgxMjQyMTc5NTE2ODgxIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac93063457cf444ee213fff0283dc5c28b6a50fe0d090bc4f50a8338c4d20e07e0
hovercard-subject-tagissue:328848477
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/1409/issue_layout
twitter:imagehttps://opengraph.githubassets.com/23dbc36a14e6b24292873e900893ad7f2ae07af3ebc33b99ad89d5171690b92e/sqlitebrowser/sqlitebrowser/issues/1409
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/23dbc36a14e6b24292873e900893ad7f2ae07af3ebc33b99ad89d5171690b92e/sqlitebrowser/sqlitebrowser/issues/1409
og:image:altat the suggestion of @justinclift , I'm including some thoughts on implementation. Bearing in mind I have zero familiarity with the code: It occurs to me this is a more complex issue than I would h...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameLlaves
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/1409#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1409
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%2F1409
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/1409
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1409
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1409
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/1409
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1409
[Discussion] Multi-column sortinghttps://github.com/sqlitebrowser/sqlitebrowser/issues/1409#top
https://github.com/MKleusberg
https://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
3.12.0 - Next releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Jun 3, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issue-328848477
@justinclifthttps://github.com/justinclift
justinclifthttps://github.com/justinclift
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on Jun 3, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#event-1660093872
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jun 3, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394179884
@Llaveshttps://github.com/Llaves
https://github.com/sky5walk
sky5walkhttps://github.com/sky5walk
on Jun 3, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394201000
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jun 4, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394508174
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Jun 4, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394515268
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jun 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394597503
#141https://github.com/sqlitebrowser/sqlitebrowser/issues/141
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Jun 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394702069
@chrisjlockehttps://github.com/chrisjlocke
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jun 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394718915
https://nightlies.sqlitebrowser.org/latest/https://nightlies.sqlitebrowser.org/latest/
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Jun 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-394742765
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Apr 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-478665787
justinclifthttps://github.com/justinclift
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Apr 1, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#event-2244251466
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Apr 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-478842927
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Apr 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-478862464
https://nightlies.sqlitebrowser.org/latest/https://nightlies.sqlitebrowser.org/latest/
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Apr 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-478998498
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Apr 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-479012620
herehttps://sqlitebrowser.org/dl/#windows
https://github.com/Llaves
Llaveshttps://github.com/Llaves
on Apr 2, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-479050911
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Apr 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#issuecomment-480933828
justinclifthttps://github.com/justinclift
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Apr 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#event-2260494347
justinclifthttps://github.com/justinclift
3.12.0 - Future releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
on Apr 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#event-2260495686
justinclifthttps://github.com/justinclift
MKleusberghttps://github.com/MKleusberg
mgrojohttps://github.com/mgrojo
on Apr 8, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#event-2260496041
mgrojohttps://github.com/mgrojo
on Aug 4, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1409#event-2531838050
Avoid displaying sort indicators in plot dock and "Copy with headers"https://github.com/sqlitebrowser/sqlitebrowser/commit/9327d512a9548eaf9a40899cdfdf2d4d18dac83c
9327d51https://github.com/sqlitebrowser/sqlitebrowser/commit/9327d512a9548eaf9a40899cdfdf2d4d18dac83c
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1409
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1409
MKleusberghttps://github.com/MKleusberg
mgrojohttps://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
3.12.0 - Next releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
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.