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
Domain: github.com
{"@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-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:a104155b-1743-ec4d-e366-9f32bdb77cb1 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | AA2C:2BF4F6:3D300:50637:6AFD39D1 |
| html-safe-nonce | bcb107979dd002287cac65450e4b14fd2be9342f796c1f58aa80a9461a233e45 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBQTJDOjJCRjRGNjozRDMwMDo1MDYzNzo2QUZEMzlEMSIsInZpc2l0b3JfaWQiOiI1NjAyMDgxMjQyMTc5NTE2ODgxIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 93063457cf444ee213fff0283dc5c28b6a50fe0d090bc4f50a8338c4d20e07e0 |
| hovercard-subject-tag | issue:328848477 |
| 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/1409/issue_layout |
| twitter:image | https://opengraph.githubassets.com/23dbc36a14e6b24292873e900893ad7f2ae07af3ebc33b99ad89d5171690b92e/sqlitebrowser/sqlitebrowser/issues/1409 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/23dbc36a14e6b24292873e900893ad7f2ae07af3ebc33b99ad89d5171690b92e/sqlitebrowser/sqlitebrowser/issues/1409 |
| og:image:alt | 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... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | Llaves |
| 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