René's URL Explorer Experiment


Title: Single quote not escaped when entering password for SQLCipher encrypted db · Issue #1105 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: Single quote not escaped when entering password for SQLCipher encrypted db · Issue #1105 · sqlitebrowser/sqlitebrowser

X Title: Single quote not escaped when entering password for SQLCipher encrypted db · Issue #1105 · sqlitebrowser/sqlitebrowser

Description: Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a password. Here’s an example of a db gener...

Open Graph Description: Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a p...

X Description: Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a p...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Single quote not escaped when entering password for SQLCipher encrypted db","articleBody":"### Details for the issue\r\n\r\nI was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a password.\r\n\r\nHere’s an example of a db generated using the SQLCipher cli:\r\n```\r\nsqlite> .open test.db\r\nsqlite> PRAGMA KEY = \"test'123\";\r\nsqlite> PRAGMA cipher_page_size=1024;\r\nsqlite> CREATE TABLE t1(a,b);\r\nsqlite> INSERT INTO t1(a,b) VALUES('one for the money', 'two for the show');\r\nsqlite> SELECT * FROM t1;\r\none for the money|two for the show\r\nsqlite> .q\r\n```\r\nWhen you attempt to open it in DB Browser for SQLite (3.10.0) using the passphrase `test'123` it fails.\r\n\r\n### Useful extra information\r\n\r\n* This may be a regression as the previous version was able to open SQLCipher dbs with single quotes.\r\n\r\n\u003c!-- The info below often helps, please fill it out if you're able to. :) -->\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- [ ] 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:_ Windows 10 Enterprise)\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ x] Mac OS: ( _version:_ macOS Sierra 10.12.6)\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [x ] 3.10.0\r\n- [ ] 3.10.0-beta*\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [ ] 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/R4N","@type":"Person","name":"R4N"},"datePublished":"2017-08-25T19:12:43Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1105"}

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:90c5b3f8-e39e-6782-e014-98e27ac9be82
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idED1C:161A75:245B2:2F29E:6AFD1815
html-safe-nonceaead2fecd3dc1e28a0391417f99d50ad585a792b8c4f298135c61efec4fcb87b
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFRDFDOjE2MUE3NToyNDVCMjoyRjI5RTo2QUZEMTgxNSIsInZpc2l0b3JfaWQiOiI3NzQzNTA2NjYyNzE0ODQxMTA5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmace8e11fa3ce433205b0e5f5ea4bc4cf9e344cf8565031fea6e678a4adf3f6057c
hovercard-subject-tagissue:252993682
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/1105/issue_layout
twitter:imagehttps://opengraph.githubassets.com/deef39a9195f612cb36db228067bf2eee07650b705c811a72580a2f26a08d552/sqlitebrowser/sqlitebrowser/issues/1105
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/deef39a9195f612cb36db228067bf2eee07650b705c811a72580a2f26a08d552/sqlitebrowser/sqlitebrowser/issues/1105
og:image:altDetails for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a p...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameR4N
hostnamegithub.com
expected-hostnamegithub.com
None065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19
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
release941021edf0c2ec58298f4a2c8f27ae507d129c92
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1105#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1105
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%2F1105
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/1105
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1105
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1105
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/1105
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1105
Single quote not escaped when entering password for SQLCipher encrypted dbhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1105#top
https://github.com/MKleusberg
SQLCipherhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22SQLCipher%22
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.10.1 - Gaaah!https://github.com/sqlitebrowser/sqlitebrowser/milestone/14
https://github.com/R4N
R4Nhttps://github.com/R4N
on Aug 25, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issue-252993682
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
MKleusberghttps://github.com/MKleusberg
on Aug 25, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#event-1222014967
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
SQLCipherhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22SQLCipher%22
on Aug 25, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#event-1222015092
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Aug 25, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issuecomment-325013467
@R4Nhttps://github.com/R4N
@MKleusberghttps://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Sep 1, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#event-1230937355
cipher: Fix passphrases containing single quoteshttps://github.com/sqlitebrowser/sqlitebrowser/commit/5a922fff83ebd88144c0a6fc9a02c95bc3aa7dfc
5a922ffhttps://github.com/sqlitebrowser/sqlitebrowser/commit/5a922fff83ebd88144c0a6fc9a02c95bc3aa7dfc
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Sep 1, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issuecomment-326520393
@R4Nhttps://github.com/R4N
https://github.com/R4N
R4Nhttps://github.com/R4N
on Sep 1, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issuecomment-326635452
@MKleusberghttps://github.com/MKleusberg
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Sep 1, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issuecomment-326636653
justinclifthttps://github.com/justinclift
3.10.1 - Gaaah!https://github.com/sqlitebrowser/sqlitebrowser/milestone/14
on Sep 2, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#event-1232331202
https://github.com/R4N
R4Nhttps://github.com/R4N
on Sep 5, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issuecomment-327266612
@MKleusberghttps://github.com/MKleusberg
@justinclifthttps://github.com/justinclift
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Sep 6, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#issuecomment-327521780
@R4Nhttps://github.com/R4N
MKleusberghttps://github.com/MKleusberg
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Sep 6, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#event-1237080460
MKleusberghttps://github.com/MKleusberg
on Sep 18, 2017https://github.com/sqlitebrowser/sqlitebrowser/issues/1105#event-1253655520
cipher: Fix passphrases containing single quoteshttps://github.com/sqlitebrowser/sqlitebrowser/commit/8fa01802e0c6d03997a6c393dacae12b658aa1c0
8fa0180https://github.com/sqlitebrowser/sqlitebrowser/commit/8fa01802e0c6d03997a6c393dacae12b658aa1c0
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1105
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1105
MKleusberghttps://github.com/MKleusberg
SQLCipherhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22SQLCipher%22
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.10.1 - Gaaah!https://github.com/sqlitebrowser/sqlitebrowser/milestone/14
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.