René's URL Explorer Experiment

Title: Migrate to postgres by msukkari · Pull Request #174 · sourcebot-dev/sourcebot · GitHub

Open Graph Title: Migrate to postgres by msukkari · Pull Request #174 · sourcebot-dev/sourcebot

X Title: Migrate to postgres by msukkari · Pull Request #174 · sourcebot-dev/sourcebot

Description: Sourcebot is a self-hosted tool that helps humans and agents understand your codebase. - Migrate to postgres by msukkari · Pull Request #174 · sourcebot-dev/sourcebot

Open Graph Description: Migrates away from sqlite in favor of postgres. This is in preparation for secrets manager support, which typically requires a more robust DB solution. in dev mode, we spin up postgres docker cont...

X Description: Migrates away from sqlite in favor of postgres. This is in preparation for secrets manager support, which typically requires a more robust DB solution. in dev mode, we spin up postgres docker cont...

Opengraph URL: https://github.com/sourcebot-dev/sourcebot/pull/174

X: @github

direct link

Domain: github.com

route-pattern	/_view_fragments/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format)
route-controller	voltron_pull_requests_fragments
route-action	pull_request_layout
fetch-nonce	v2:6718c2b5-d9f0-e786-ca39-5afbe0aa4de1
current-catalog-service-hash	ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id	A3BC:A2811:43DA63:5C5AFB:6A4DC753
html-safe-nonce	df4708ca8d32c494ca6c433dfcb46ba42d2ef80aca74116beacd985003a7f193
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBM0JDOkEyODExOjQzREE2Mzo1QzVBRkI6NkE0REM3NTMiLCJ2aXNpdG9yX2lkIjoiNTEzNDc5MzUyMDUzMjI3NzA3NSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac	6e3500fd4d93b7b4520b3b80a27863a338f168c944c9eb6d7e7e14eca6627f5c
hovercard-subject-tag	pull_request:2292941319
github-keyboard-shortcuts	repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	///voltron/pull_requests_fragments/pull_request_layout
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/sourcebot-dev/sourcebot/174/pull_request_layout
twitter:image	https://opengraph.githubassets.com/08d597785245800f8116e317b2db359fe95ac48cd35782ab07c38e2807df4837/sourcebot-dev/sourcebot/pull/174
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/08d597785245800f8116e317b2db359fe95ac48cd35782ab07c38e2807df4837/sourcebot-dev/sourcebot/pull/174
og:image:alt	Migrates away from sqlite in favor of postgres. This is in preparation for secrets manager support, which typically requires a more robust DB solution. in dev mode, we spin up postgres docker cont...
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
og:author:username	msukkari
hostname	github.com
expected-hostname	github.com
None	06b8a6144231bf3a234f1c2e9993861e07ce98a905912b114aa386c2d7e84b33
turbo-cache-control	no-cache
go-import	github.com/sourcebot-dev/sourcebot git https://github.com/sourcebot-dev/sourcebot.git
octolytics-dimension-user_id	135396723
octolytics-dimension-user_login	sourcebot-dev
octolytics-dimension-repository_id	846729675
octolytics-dimension-repository_nwo	sourcebot-dev/sourcebot
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	846729675
octolytics-dimension-repository_network_root_nwo	sourcebot-dev/sourcebot
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	1d344bdb7547fe6bca17a59bb2b8aac3dc9532a0
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/sourcebot-dev/sourcebot/pull/174#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsourcebot-dev%2Fsourcebot%2Fpull%2F174
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub Copilot appDirect agents from issue to merge	https://github.com/features/ai/github-app
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
View all resources	https://github.com/resources
GitHub SponsorsFund open source developers	https://github.com/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/accelerator
GitHub Stars	https://stars.github.com
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://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%2Fsourcebot-dev%2Fsourcebot%2Fpull%2F174
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%2Fvoltron%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=sourcebot-dev%2Fsourcebot
Reload	https://github.com/sourcebot-dev/sourcebot/pull/174
Reload	https://github.com/sourcebot-dev/sourcebot/pull/174
Reload	https://github.com/sourcebot-dev/sourcebot/pull/174
Please reload this page	https://github.com/sourcebot-dev/sourcebot/pull/174
sourcebot-dev	https://github.com/sourcebot-dev
sourcebot	https://github.com/sourcebot-dev/sourcebot
Notifications	https://github.com/login?return_to=%2Fsourcebot-dev%2Fsourcebot
Fork 316	https://github.com/login?return_to=%2Fsourcebot-dev%2Fsourcebot
Star 3.6k	https://github.com/login?return_to=%2Fsourcebot-dev%2Fsourcebot
Code	https://github.com/sourcebot-dev/sourcebot
Issues 92	https://github.com/sourcebot-dev/sourcebot/issues
Pull requests 37	https://github.com/sourcebot-dev/sourcebot/pulls
Discussions	https://github.com/sourcebot-dev/sourcebot/discussions
Actions	https://github.com/sourcebot-dev/sourcebot/actions
Security and quality 0	https://github.com/sourcebot-dev/sourcebot/security
Insights	https://github.com/sourcebot-dev/sourcebot/pulse
Code	https://github.com/sourcebot-dev/sourcebot
Issues	https://github.com/sourcebot-dev/sourcebot/issues
Pull requests	https://github.com/sourcebot-dev/sourcebot/pulls
Discussions	https://github.com/sourcebot-dev/sourcebot/discussions
Actions	https://github.com/sourcebot-dev/sourcebot/actions
Security and quality	https://github.com/sourcebot-dev/sourcebot/security
Insights	https://github.com/sourcebot-dev/sourcebot/pulse
msukkari	https://github.com/msukkari
v3	https://github.com/sourcebot-dev/sourcebot/tree/v3
msukkarieh/postgres	https://github.com/sourcebot-dev/sourcebot/tree/msukkarieh/postgres
Conversation	https://github.com/sourcebot-dev/sourcebot/pull/174
Commits5 (5)	https://github.com/sourcebot-dev/sourcebot/pull/174/commits
Checks	https://github.com/sourcebot-dev/sourcebot/pull/174/checks
Files changed	https://github.com/sourcebot-dev/sourcebot/pull/174/files
Migrate to postgres	https://github.com/sourcebot-dev/sourcebot/pull/174#top
msukkari	https://github.com/msukkari
v3	https://github.com/sourcebot-dev/sourcebot/tree/v3
msukkarieh/postgres	https://github.com/sourcebot-dev/sourcebot/tree/msukkarieh/postgres
	https://github.com/msukkari
msukkari	https://github.com/msukkari
Jan 22, 2025	https://github.com/sourcebot-dev/sourcebot/pull/174#issue-2805166942
Please reload this page	https://github.com/sourcebot-dev/sourcebot/pull/174
Please reload this page	https://github.com/sourcebot-dev/sourcebot/pull/174
msukkari	https://github.com/msukkari
January 22, 2025 11:19	https://github.com/sourcebot-dev/sourcebot/pull/174#commits-pushed-eb8788e
	https://github.com/msukkari
spin up postgres in docker container	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/eb8788e8c994680e487f8aa620ea4f670e45e289
eb8788e	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/eb8788e8c994680e487f8aa620ea4f670e45e289
	https://github.com/msukkari
get initial pol of postgres db working in docker image	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/845937e83b4eaea0b8659b2b8c4bb5123bea7d3a
845937e	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/845937e83b4eaea0b8659b2b8c4bb5123bea7d3a
	https://github.com/msukkari
spin up postgres server in dev case	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/f00a4c06a47d925ea6d872daf3d5211ea8c75471
f00a4c0	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/f00a4c06a47d925ea6d872daf3d5211ea8c75471
	https://github.com/msukkari
updated syncedAt date after config sync:	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/079a2dd9d4d1351918088ca0344b010bd9cac365
079a2dd	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/079a2dd9d4d1351918088ca0344b010bd9cac365
	https://github.com/brendan-kellam
brendan-kellam	https://github.com/brendan-kellam
Jan 23, 2025	https://github.com/sourcebot-dev/sourcebot/pull/174#pullrequestreview-2570586809
View reviewed changes	https://github.com/sourcebot-dev/sourcebot/pull/174/files/079a2dd9d4d1351918088ca0344b010bd9cac365
Dockerfile	https://github.com/sourcebot-dev/sourcebot/pull/174/files/079a2dd9d4d1351918088ca0344b010bd9cac365#diff-dd2c0eb6ea5cfc6c4bd4eac30934e2d5746747af48fef6da689e85b752f39557
Please reload this page	https://github.com/sourcebot-dev/sourcebot/pull/174
	https://github.com/brendan-kellam
brendan-kellam	https://github.com/brendan-kellam
Jan 23, 2025	https://github.com/sourcebot-dev/sourcebot/pull/174#pullrequestreview-2570603078
View reviewed changes	https://github.com/sourcebot-dev/sourcebot/pull/174/files/079a2dd9d4d1351918088ca0344b010bd9cac365
	https://github.com/msukkari
remove unnecessary port expose in docker file	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/b4a90d7ba28fea9b0802210eab64cf10efcf282e
b4a90d7	https://github.com/sourcebot-dev/sourcebot/pull/174/commits/b4a90d7ba28fea9b0802210eab64cf10efcf282e
	https://github.com/msukkari
msukkari	https://github.com/msukkari
Jan 23, 2025	https://github.com/sourcebot-dev/sourcebot/pull/174#event-16048064519
	https://github.com/msukkari
msukkari	https://github.com/msukkari
a5006c5	https://github.com/sourcebot-dev/sourcebot/commit/a5006c52fed053d5dc97630eea02098056930331
Jan 23, 2025	https://github.com/sourcebot-dev/sourcebot/pull/174#event-16048110876
	https://github.com/msukkari
msukkari	https://github.com/msukkari
January 23, 2025 18:23	https://github.com/sourcebot-dev/sourcebot/pull/174#event-16048112400
brendan-kellam	https://github.com/brendan-kellam
Apr 1, 2025	https://github.com/sourcebot-dev/sourcebot/pull/174#ref-commit-39b92b9
	https://github.com/brendan-kellam
	https://github.com/msukkari
v3 effort (	https://github.com/sourcebot-dev/sourcebot/commit/39b92b9e989a55f8957efa1c7cd67d1c1653c44b
#158	https://github.com/sourcebot-dev/sourcebot/pull/158
)	https://github.com/sourcebot-dev/sourcebot/commit/39b92b9e989a55f8957efa1c7cd67d1c1653c44b
39b92b9	https://github.com/sourcebot-dev/sourcebot/commit/39b92b9e989a55f8957efa1c7cd67d1c1653c44b
#157	https://github.com/sourcebot-dev/sourcebot/pull/157
#160	https://github.com/sourcebot-dev/sourcebot/pull/160
#163	https://github.com/sourcebot-dev/sourcebot/pull/163
#164	https://github.com/sourcebot-dev/sourcebot/pull/164
#167	https://github.com/sourcebot-dev/sourcebot/pull/167
#172	https://github.com/sourcebot-dev/sourcebot/pull/172
#171	https://github.com/sourcebot-dev/sourcebot/pull/171
#172	https://github.com/sourcebot-dev/sourcebot/pull/172
#173	https://github.com/sourcebot-dev/sourcebot/pull/173
#174	https://github.com/sourcebot-dev/sourcebot/pull/174
#175	https://github.com/sourcebot-dev/sourcebot/pull/175
#176	https://github.com/sourcebot-dev/sourcebot/pull/176
#177	https://github.com/sourcebot-dev/sourcebot/pull/177
#178	https://github.com/sourcebot-dev/sourcebot/pull/178
#180	https://github.com/sourcebot-dev/sourcebot/pull/180
#181	https://github.com/sourcebot-dev/sourcebot/pull/181
#182	https://github.com/sourcebot-dev/sourcebot/pull/182
#183	https://github.com/sourcebot-dev/sourcebot/pull/183
#185	https://github.com/sourcebot-dev/sourcebot/pull/185
#188	https://github.com/sourcebot-dev/sourcebot/pull/188
#3	https://github.com/sourcebot-dev/sourcebot/pull/3
#4	https://github.com/sourcebot-dev/sourcebot/pull/4
#189	https://github.com/sourcebot-dev/sourcebot/pull/189
#190	https://github.com/sourcebot-dev/sourcebot/pull/190
#191	https://github.com/sourcebot-dev/sourcebot/pull/191
#184	https://github.com/sourcebot-dev/sourcebot/pull/184
#183	https://github.com/sourcebot-dev/sourcebot/pull/183
#183	https://github.com/sourcebot-dev/sourcebot/pull/183
#183	https://github.com/sourcebot-dev/sourcebot/pull/183
#192	https://github.com/sourcebot-dev/sourcebot/pull/192
#194	https://github.com/sourcebot-dev/sourcebot/pull/194
#195	https://github.com/sourcebot-dev/sourcebot/pull/195
#196	https://github.com/sourcebot-dev/sourcebot/pull/196
#198	https://github.com/sourcebot-dev/sourcebot/pull/198
#199	https://github.com/sourcebot-dev/sourcebot/pull/199
#200	https://github.com/sourcebot-dev/sourcebot/pull/200
#201	https://github.com/sourcebot-dev/sourcebot/pull/201
#205	https://github.com/sourcebot-dev/sourcebot/pull/205
#202	https://github.com/sourcebot-dev/sourcebot/pull/202
#204	https://github.com/sourcebot-dev/sourcebot/pull/204
#207	https://github.com/sourcebot-dev/sourcebot/pull/207
#208	https://github.com/sourcebot-dev/sourcebot/pull/208
#209	https://github.com/sourcebot-dev/sourcebot/pull/209
#210	https://github.com/sourcebot-dev/sourcebot/pull/210
#211	https://github.com/sourcebot-dev/sourcebot/pull/211
#212	https://github.com/sourcebot-dev/sourcebot/pull/212
#213	https://github.com/sourcebot-dev/sourcebot/pull/213
#214	https://github.com/sourcebot-dev/sourcebot/pull/214
#215	https://github.com/sourcebot-dev/sourcebot/pull/215
#169	https://github.com/sourcebot-dev/sourcebot/pull/169
#216	https://github.com/sourcebot-dev/sourcebot/pull/216
#217	https://github.com/sourcebot-dev/sourcebot/pull/217
#218	https://github.com/sourcebot-dev/sourcebot/pull/218
#220	https://github.com/sourcebot-dev/sourcebot/pull/220
#219	https://github.com/sourcebot-dev/sourcebot/pull/219
#221	https://github.com/sourcebot-dev/sourcebot/pull/221
#222	https://github.com/sourcebot-dev/sourcebot/pull/222
#223	https://github.com/sourcebot-dev/sourcebot/pull/223
#224	https://github.com/sourcebot-dev/sourcebot/pull/224
#225	https://github.com/sourcebot-dev/sourcebot/pull/225
#226	https://github.com/sourcebot-dev/sourcebot/pull/226
#230	https://github.com/sourcebot-dev/sourcebot/pull/230
#231	https://github.com/sourcebot-dev/sourcebot/pull/231
#232	https://github.com/sourcebot-dev/sourcebot/pull/232
#234	https://github.com/sourcebot-dev/sourcebot/pull/234
#233	https://github.com/sourcebot-dev/sourcebot/pull/233
#235	https://github.com/sourcebot-dev/sourcebot/pull/235
#242	https://github.com/sourcebot-dev/sourcebot/pull/242
#243	https://github.com/sourcebot-dev/sourcebot/pull/243
#244	https://github.com/sourcebot-dev/sourcebot/pull/244
#245	https://github.com/sourcebot-dev/sourcebot/pull/245
#246	https://github.com/sourcebot-dev/sourcebot/pull/246
1f4a5ae	https://github.com/sourcebot-dev/sourcebot/commit/1f4a5aed22fa94bace899262e8576427fc852f61
#252	https://github.com/sourcebot-dev/sourcebot/pull/252
#253	https://github.com/sourcebot-dev/sourcebot/pull/253
#251	https://github.com/sourcebot-dev/sourcebot/pull/251
	https://github.co/hiddenchars
	https://github.com/sourcebot-dev/sourcebot/pull/{{ revealButtonHref }}
Sign up for free	https://github.com/join?source=comment-repo
Sign in to comment	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsourcebot-dev%2Fsourcebot%2Fpull%2F174
	https://github.com/brendan-kellam
brendan-kellam	https://github.com/brendan-kellam
	https://github.com/sourcebot-dev/sourcebot/pull/174/files/079a2dd9d4d1351918088ca0344b010bd9cac365
Please reload this page	https://github.com/sourcebot-dev/sourcebot/pull/174
	https://github.com/msukkari
	https://github.com/brendan-kellam
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.