René's URL Explorer Experiment


Title: Allow Insert/Update/Delete for Views on Browse Data tab · Issue #141 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Allow Insert/Update/Delete for Views on Browse Data tab · Issue #141 · sqlitebrowser/sqlitebrowser

X Title: Allow Insert/Update/Delete for Views on Browse Data tab · Issue #141 · sqlitebrowser/sqlitebrowser

Description: This is a feature request to allow Insert/Update/Delete user interface capability for Views on Browse Data tab. Views are normally read-only in SQLite, however, SQLite supports using triggers on Views, which handle the write operations a...

Open Graph Description: This is a feature request to allow Insert/Update/Delete user interface capability for Views on Browse Data tab. Views are normally read-only in SQLite, however, SQLite supports using triggers on Vi...

X Description: This is a feature request to allow Insert/Update/Delete user interface capability for Views on Browse Data tab. Views are normally read-only in SQLite, however, SQLite supports using triggers on Vi...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Allow Insert/Update/Delete for Views on Browse Data tab","articleBody":"This is a feature request to allow Insert/Update/Delete user interface capability for Views on Browse Data tab.\n\nViews are normally read-only in SQLite, however, SQLite supports using triggers on Views, which handle the write operations attempted against the View. When this is the case, the absence of a user interface for editing the view means you have to write SQL code to do so.\n\nTo avoid confusion, you might consider interrogating existing triggers for an \"...INSTEAD OF [INSERT/UPDATE/DELETE] on \u003cViewname>...\" trigger to determine what user interface options to expose. But if this is too complex, it might just be better to expose the options and return the result from the database engine, whether that's an error (because the view is read-only and doesn't have a trigger for the action) or otherwise. Of course this may conflict with your easy-to-use design philosophy (some users might dislike having the user interface indicate that edits are possible when they are not), in which case I guess the enhancement should be rejected.\n","author":{"url":"https://github.com/asperax","@type":"Person","name":"asperax"},"datePublished":"2014-10-31T00:43:46Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/141"}

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:dbe39ea0-6158-7eef-9983-207139e1c812
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id8D22:2E2E6E:1A1D3:23686:6AFD3926
html-safe-nonced8eb52d1e4b3291ea10b4550f98ed6fda4559722055e5738e0bfb0a888f65f71
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4RDIyOjJFMkU2RToxQTFEMzoyMzY4Njo2QUZEMzkyNiIsInZpc2l0b3JfaWQiOiI3MTM0ODg3ODc1MzU4NTcwNzkwIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac21692df47f34c7dff1c603266d57dc0aeeed668c81a0d6c0da97e8ee74b00e77
hovercard-subject-tagissue:47349359
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/141/issue_layout
twitter:imagehttps://opengraph.githubassets.com/6cc8f576c67f1e2bb5f9ef7c79596bef1abe84d6a9ca9cb41c8bb2f6a6d8ac51/sqlitebrowser/sqlitebrowser/issues/141
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/6cc8f576c67f1e2bb5f9ef7c79596bef1abe84d6a9ca9cb41c8bb2f6a6d8ac51/sqlitebrowser/sqlitebrowser/issues/141
og:image:altThis is a feature request to allow Insert/Update/Delete user interface capability for Views on Browse Data tab. Views are normally read-only in SQLite, however, SQLite supports using triggers on Vi...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameasperax
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/141#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F141
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%2F141
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/141
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/141
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/141
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/141
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/141
Allow Insert/Update/Delete for Views on Browse Data tabhttps://github.com/sqlitebrowser/sqlitebrowser/issues/141#top
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
3.12.0 - Next releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
https://github.com/asperax
asperaxhttps://github.com/asperax
on Oct 31, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issue-47349359
Nexthttps://github.com/sqlitebrowser/sqlitebrowser/issues/141?timeline_page=1
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Oct 31, 2014https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-61257186
https://github.com/nowox
nowoxhttps://github.com/nowox
on Apr 28, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-297971195
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Apr 28, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-298013447
https://github.com/nowox
nowoxhttps://github.com/nowox
on Apr 30, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-298225153
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Apr 30, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-298231226
https://github.com/sqlitebrowser/sqlitebrowser/wiki/Setting-up-a-Win64-development-environment-for-DB4Shttps://github.com/sqlitebrowser/sqlitebrowser/wiki/Setting-up-a-Win64-development-environment-for-DB4S
https://github.com/nowox
nowoxhttps://github.com/nowox
on Apr 30, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-298231326
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Apr 30, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-298231783
https://github.com/sqlitebrowser/sqlitebrowser/blob/master/CMakeLists.txt#L18-L30https://github.com/sqlitebrowser/sqlitebrowser/blob/master/CMakeLists.txt#L18-L30
https://github.com/nowox
nowoxhttps://github.com/nowox
on Apr 30, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-298235878
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 12, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-301107823
@nowoxhttps://github.com/nowox
MKleusberghttps://github.com/MKleusberg
on May 12, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-1080265790
Allow updating viewshttps://github.com/sqlitebrowser/sqlitebrowser/commit/21ee1f2703967b6caa6c07d6e0cfdca0b5c5d25f
21ee1f2https://github.com/sqlitebrowser/sqlitebrowser/commit/21ee1f2703967b6caa6c07d6e0cfdca0b5c5d25f
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on May 12, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-301131415
https://github.com/nowox
nowoxhttps://github.com/nowox
on May 14, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-301324515
mgrojohttps://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on Jan 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-1406481019
MKleusberghttps://github.com/MKleusberg
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-1668679887
Add support for deleting rows in views which are unlocked for editinghttps://github.com/sqlitebrowser/sqlitebrowser/commit/f51b44d8d7d4b8ee932bba67230b33f0650e3a0c
f51b44dhttps://github.com/sqlitebrowser/sqlitebrowser/commit/f51b44d8d7d4b8ee932bba67230b33f0650e3a0c
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Jun 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-395435618
https://github.com/cristilupascu
cristilupascuhttps://github.com/cristilupascu
on Feb 22, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-466573310
@mgrojohttps://github.com/mgrojo
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 23, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-466625684
@cristilupascuhttps://github.com/cristilupascu
cristilupascuhttps://github.com/cristilupascu
on Mar 3, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-2176348111
Add Insert for Views using AddRecordDialog (sqlitebrowser#141)https://github.com/cristilupascu/sqlitebrowser/commit/4de2b7cd4b19a03087984097c3e2baeea0300a37
sqlitebrowser#141https://github.com/sqlitebrowser/sqlitebrowser/issues/141
4de2b7chttps://github.com/cristilupascu/sqlitebrowser/commit/4de2b7cd4b19a03087984097c3e2baeea0300a37
Merge pull request #1 from cristilupascu/view_inserthttps://github.com/cristilupascu/sqlitebrowser/commit/8dcbf2d2b9453652f32304fe197a90d8106ce871
#1https://github.com/cristilupascu/sqlitebrowser/pull/1
8dcbf2dhttps://github.com/cristilupascu/sqlitebrowser/commit/8dcbf2d2b9453652f32304fe197a90d8106ce871
Add Insert for Views using AddRecordDialog (sqlitebrowser#141)https://github.com/cristilupascu/sqlitebrowser/commit/afaea0f53fa0b66b6bce1d2ef6011592d27ef52d
sqlitebrowser#141https://github.com/sqlitebrowser/sqlitebrowser/issues/141
afaea0fhttps://github.com/cristilupascu/sqlitebrowser/commit/afaea0f53fa0b66b6bce1d2ef6011592d27ef52d
Add Insert for Views using AddRecordDialog (sqlitebrowser#141)https://github.com/cristilupascu/sqlitebrowser/commit/731902272df47a071c090c0bceeb3d36cf77c203
sqlitebrowser#141https://github.com/sqlitebrowser/sqlitebrowser/issues/141
7319022https://github.com/cristilupascu/sqlitebrowser/commit/731902272df47a071c090c0bceeb3d36cf77c203
https://github.com/cristilupascu
cristilupascuhttps://github.com/cristilupascu
on Mar 3, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-469037949
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Mar 4, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-469093239
@cristilupascuhttps://github.com/cristilupascu
MKleusberghttps://github.com/MKleusberg
on Mar 6, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-2183651474
Add Insert for Views using AddRecordDialog (#141)https://github.com/sqlitebrowser/sqlitebrowser/commit/db17cd9e4f1e46d5361f68ab8a411fab7981dfda
#141https://github.com/sqlitebrowser/sqlitebrowser/issues/141
db17cd9https://github.com/sqlitebrowser/sqlitebrowser/commit/db17cd9e4f1e46d5361f68ab8a411fab7981dfda
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Mar 6, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-470052394
@cristilupascuhttps://github.com/cristilupascu
@cristilupascuhttps://github.com/cristilupascu
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Aug 10, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-520138657
MKleusberghttps://github.com/MKleusberg
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Aug 10, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-2548102490
mgrojohttps://github.com/mgrojo
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
3.12.0 - Future releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
on Aug 10, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/141#event-2548127664
https://github.com/bam80
bam80https://github.com/bam80
on Jan 23, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/141#issuecomment-577455010
#1653 (comment)https://github.com/sqlitebrowser/sqlitebrowser/issues/1653#issuecomment-577445545
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/141
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/141
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%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.