René's URL Explorer Experiment


Title: sqlite: add serialize() and deserialize() to DatabaseSync by thisalihassan · Pull Request #62579 · nodejs/node · GitHub

Open Graph Title: sqlite: add serialize() and deserialize() to DatabaseSync by thisalihassan · Pull Request #62579 · nodejs/node

X Title: sqlite: add serialize() and deserialize() to DatabaseSync by thisalihassan · Pull Request #62579 · nodejs/node

Description: Add serialize() and .deserialize() methods to DatabaseSync, wrapping the sqlite3_serialize and sqlite3_deserialize. These allow extracting an in-memory database as a Uint8Array and loading one back enabling snapshots, cloning, etc.. Implemenation Notes: serialize() wraps the SQLite allocated buffer directly in a V8 BackingStore to avoid copying the entire database. #ifdef V8_ENABLE_SANDBOX falls back to a copy path since that configuration forbids external backing stores. deserialize() must copy once because SQLite requires sqlite3_malloc64allocated memory. Wrote test cases with Claude & GPT 5.4 Refs: #62575

Open Graph Description: Add serialize() and .deserialize() methods to DatabaseSync, wrapping the sqlite3_serialize and sqlite3_deserialize. These allow extracting an in-memory database as a Uint8Array and loading one back...

X Description: Add serialize() and .deserialize() methods to DatabaseSync, wrapping the sqlite3_serialize and sqlite3_deserialize. These allow extracting an in-memory database as a Uint8Array and loading one back...

Opengraph URL: https://github.com/nodejs/node/pull/62579

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:187b8819-9bd6-9b3a-ef5a-6b3f85841528
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD756:1860BA:806B7:AB8F4:6A4C11F2
html-safe-noncecc339af653659aaacd899110af0fe0c7ae921d3d9dbb3bb1f3180e680e06ef2b
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENzU2OjE4NjBCQTo4MDZCNzpBQjhGNDo2QTRDMTFGMiIsInZpc2l0b3JfaWQiOiIxNDkzNTIyMzA4NTY3NjY3MTg2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac4eab97fa13e03563895d42d7e2aaffd14935b178be2ecd449292c80ae2437d2c
hovercard-subject-tagpull_request:3487693870
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/nodejs/node/pull/62579/files
twitter:imagehttps://avatars.githubusercontent.com/u/24819103?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/24819103?s=400&v=4
og:image:altAdd serialize() and .deserialize() methods to DatabaseSync, wrapping the sqlite3_serialize and sqlite3_deserialize. These allow extracting an in-memory database as a Uint8Array and loading one back...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None0ccfc9e5281bfe12e38a4d632dc422843e4d5b6757917f7efda2f6567d72fea9
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/nodejs/node git https://github.com/nodejs/node.git
octolytics-dimension-user_id9950313
octolytics-dimension-user_loginnodejs
octolytics-dimension-repository_id27193779
octolytics-dimension-repository_nwonodejs/node
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id27193779
octolytics-dimension-repository_network_root_nwonodejs/node
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release18812876666a23a0912556e224383baa4c84cf8e
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/nodejs/node/pull/62579/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fnodejs%2Fnode%2Fpull%2F62579%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
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
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
GitHub Starshttps://stars.github.com
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://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/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fnodejs%2Fnode%2Fpull%2F62579%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=nodejs%2Fnode
Reloadhttps://github.com/nodejs/node/pull/62579/files
Reloadhttps://github.com/nodejs/node/pull/62579/files
Reloadhttps://github.com/nodejs/node/pull/62579/files
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
nodejs https://github.com/nodejs
nodehttps://github.com/nodejs/node
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
Notifications https://github.com/login?return_to=%2Fnodejs%2Fnode
Fork 36k https://github.com/login?return_to=%2Fnodejs%2Fnode
Star 118k https://github.com/login?return_to=%2Fnodejs%2Fnode
Code https://github.com/nodejs/node
Issues 1.4k https://github.com/nodejs/node/issues
Pull requests 967 https://github.com/nodejs/node/pulls
Actions https://github.com/nodejs/node/actions
Projects https://github.com/nodejs/node/projects
Security and quality 0 https://github.com/nodejs/node/security
Insights https://github.com/nodejs/node/pulse
Code https://github.com/nodejs/node
Issues https://github.com/nodejs/node/issues
Pull requests https://github.com/nodejs/node/pulls
Actions https://github.com/nodejs/node/actions
Projects https://github.com/nodejs/node/projects
Security and quality https://github.com/nodejs/node/security
Insights https://github.com/nodejs/node/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fnodejs%2Fnode%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fnodejs%2Fnode%2Fissues%2Fnew%2Fchoose
nodejs-github-bothttps://github.com/nodejs-github-bot
nodejs:mainhttps://github.com/nodejs/node/tree/main
thisalihassan:sqlite-serialize-deserializehttps://github.com/thisalihassan/node/tree/sqlite-serialize-deserialize
Conversation 17 https://github.com/nodejs/node/pull/62579
Commits 3 https://github.com/nodejs/node/pull/62579/commits
Checks 54 https://github.com/nodejs/node/pull/62579/checks
Files changed 4 https://github.com/nodejs/node/pull/62579/files
sqlite: add serialize() and deserialize() to DatabaseSync https://github.com/nodejs/node/pull/62579/files#top
Show all changes 3 commits https://github.com/nodejs/node/pull/62579/files
3c14acf sqlite: add serialize() and deserialize() thisalihassan Apr 3, 2026 https://github.com/nodejs/node/pull/62579/commits/3c14acf74cce8e4b64bbdf4b687e5e30d4259b58
86127c0 add ownership comment to deserialize thisalihassan Apr 4, 2026 https://github.com/nodejs/node/pull/62579/commits/86127c03ba45abd3d840a294ebda718ec5086960
607d8c3 doc: added mjs samples for sqlite thisalihassan Apr 8, 2026 https://github.com/nodejs/node/pull/62579/commits/607d8c37fb677a843783af7a324dc5d1c9106d36
Clear filters https://github.com/nodejs/node/pull/62579/files
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
sqlite.md https://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
node_sqlite.cc https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
node_sqlite.h https://github.com/nodejs/node/pull/62579/files#diff-95cdec6fdad0206569f5fc4d6eca280a76b377e50ab0a594d3938248fba23107
test-sqlite-serialize.js https://github.com/nodejs/node/pull/62579/files#diff-51a95cdb8691c50b9a17d0867fab8632ac497787fcd80b030e5efdf2a33a493d
doc/api/sqlite.mdhttps://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
View file https://github.com/thisalihassan/node/blob/607d8c37fb677a843783af7a324dc5d1c9106d36/doc/api/sqlite.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/nodejs/node/pull/62579/{{ revealButtonHref }}
https://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
https://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
https://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
https://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
https://github.com/nodejs/node/pull/62579/files#diff-01eafcba231d5d76e42587fa7879b433f96347f9d6794353771dcb12e6f9739f
src/node_sqlite.cchttps://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
View file https://github.com/thisalihassan/node/blob/607d8c37fb677a843783af7a324dc5d1c9106d36/src/node_sqlite.cc
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/nodejs/node/pull/62579/{{ revealButtonHref }}
https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
louwershttps://github.com/louwers
Apr 3, 2026https://github.com/nodejs/node/pull/62579/files#r3034653569
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
thisalihassanhttps://github.com/thisalihassan
Apr 3, 2026https://github.com/nodejs/node/pull/62579/files#r3034668669
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
sqlite3_deserialize docshttps://www.sqlite.org/c3ref/deserialize.html
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
jasnellhttps://github.com/jasnell
Apr 4, 2026https://github.com/nodejs/node/pull/62579/files#r3034908813
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
thisalihassanhttps://github.com/thisalihassan
Apr 4, 2026https://github.com/nodejs/node/pull/62579/files#r3035317441
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
https://github.com/nodejs/node/pull/62579/files#diff-dd810db4fe69364c3a67a274e0725f386040c0fd1dcfade7093f23c8514328ae
src/node_sqlite.hhttps://github.com/nodejs/node/pull/62579/files#diff-95cdec6fdad0206569f5fc4d6eca280a76b377e50ab0a594d3938248fba23107
View file https://github.com/thisalihassan/node/blob/607d8c37fb677a843783af7a324dc5d1c9106d36/src/node_sqlite.h
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/nodejs/node/pull/62579/{{ revealButtonHref }}
https://github.com/nodejs/node/pull/62579/files#diff-95cdec6fdad0206569f5fc4d6eca280a76b377e50ab0a594d3938248fba23107
https://github.com/nodejs/node/pull/62579/files#diff-95cdec6fdad0206569f5fc4d6eca280a76b377e50ab0a594d3938248fba23107
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
Please reload this pagehttps://github.com/nodejs/node/pull/62579/files
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.