René's URL Explorer Experiment


Title: chore: Initial database scaffolding by kylecarbs · Pull Request #2 · coder/coder · GitHub

Open Graph Title: chore: Initial database scaffolding by kylecarbs · Pull Request #2 · coder/coder

X Title: chore: Initial database scaffolding by kylecarbs · Pull Request #2 · coder/coder

Description: This implements migrations and code generation for interfacing with a PostgreSQL database. A dependency is added for the "postgres" binary on the host, but that seems like an acceptable requirement considering it's our primary database. We decided Docker was a more reliable and ubiquitous dependency, so we launch a PostgreSQL Docker container instead. An in-memory database object can be created for simple cross-OS and fast testing.

Open Graph Description: This implements migrations and code generation for interfacing with a PostgreSQL database. A dependency is added for the "postgres" binary on the host, but that seems like an acceptable r...

X Description: This implements migrations and code generation for interfacing with a PostgreSQL database. A dependency is added for the "postgres" binary on the host, but that seems like an acce...

Opengraph URL: https://github.com/coder/coder/pull/2

X: @github

direct link

Domain: github.com

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/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:c21fbabc-3d36-1cf9-7926-087c275d2484
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id8290:1F44:145C7D8:1AAAF3F:6B014DA6
html-safe-nonce2b44532dcd294e161789e51af9e2e57e868dbe43453cb03cb0fe65517da07f96
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4MjkwOjFGNDQ6MTQ1QzdEODoxQUFBRjNGOjZCMDE0REE2IiwidmlzaXRvcl9pZCI6Ijg0OTE0ODA5MDM4NTAyMTY4NzAiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacf025fde816498b62c7fb067dc8b27e52fac392deac2d00affffe6b818c2553c6
hovercard-subject-tagpull_request:813951386
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/coder/coder/pull/2/files
twitter:imagehttps://avatars.githubusercontent.com/u/7122116?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/7122116?s=400&v=4
og:image:altThis implements migrations and code generation for interfacing with a PostgreSQL database. A dependency is added for the "postgres" binary on the host, but that seems like an acceptable r...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/coder/coder git https://github.com/coder/coder.git
octolytics-dimension-user_id95932066
octolytics-dimension-user_logincoder
octolytics-dimension-repository_id440752086
octolytics-dimension-repository_nwocoder/coder
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id440752086
octolytics-dimension-repository_network_root_nwocoder/coder
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
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/coder/coder/pull/2/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fpull%2F2%2Ffiles
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%2Fcoder%2Fcoder%2Fpull%2F2%2Ffiles
Sign uphttps://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=coder%2Fcoder
Reloadhttps://github.com/coder/coder/pull/2/files
Reloadhttps://github.com/coder/coder/pull/2/files
Reloadhttps://github.com/coder/coder/pull/2/files
coderhttps://github.com/coder
coderhttps://github.com/coder/coder
Codehttps://github.com/coder/coder
Issues320 (320)https://github.com/coder/coder/issues
Pull requests469 (469)https://github.com/coder/coder/pulls
Discussionshttps://github.com/coder/coder/discussions
Actionshttps://github.com/coder/coder/actions
Projectshttps://github.com/coder/coder/projects
Security and quality49 (49)https://github.com/coder/coder/security
Insightshttps://github.com/coder/coder/insights
Sign up for GitHub https://github.com/signup?return_to=%2Fcoder%2Fcoder%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fcoder%2Fcoder%2Fissues%2Fnew%2Fchoose
kylecarbshttps://github.com/kylecarbs
mainhttps://github.com/coder/coder/tree/main
databasehttps://github.com/coder/coder/tree/database
Conversation 2 https://github.com/coder/coder/pull/2
Commits 8 https://github.com/coder/coder/pull/2/commits
Checks 0 https://github.com/coder/coder/pull/2/checks
Files changed https://github.com/coder/coder/pull/2/files
Please reload this pagehttps://github.com/coder/coder/pull/2/files
chore: Initial database scaffolding https://github.com/coder/coder/pull/2/files#top
Show all changes 8 commits https://github.com/coder/coder/pull/2/files
a5af7f4 chore: Initial database scaffolding kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/a5af7f4834b7c34e6a121d25f68ee21a1b183a1a
aab10d1 Run tests in CI kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/aab10d146f45a2ad162e89eaa05cf764c1758c83
52a4cf4 Use Docker instead of binaries on the host kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/52a4cf4a38d2212bbde7d8d15bffe6ae3e91a322
2796d96 Skip database tests on non-Linux operating systems kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/2796d9645b76da2cb319180111ab80df268991fe
c8788af chore: Add golangci-lint and codecov kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/c8788afcc0ff7d382f0c3a3faef135844cae695a
3a7e909 Use consistent file names kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/3a7e909b4021175988e9a7f06e84c3b9570f88df
49781ff Merge branch 'codequality' into database kylecarbs Jan 4, 2022 https://github.com/coder/coder/pull/2/commits/49781ff45fcd997265f61df98acec4e548841821
3539581 Merge branch 'main' into database kylecarbs Jan 5, 2022 https://github.com/coder/coder/pull/2/commits/35395815977390532b51639e7bb5bfe5ac484ed3
Clear filters https://github.com/coder/coder/pull/2/files
Please reload this pagehttps://github.com/coder/coder/pull/2/files
Please reload this pagehttps://github.com/coder/coder/pull/2/files
.eslintignore https://github.com/coder/coder/pull/2/files#diff-a0fdacd2ade87c5238dde44378f574f7e123e669acdf8b740878b14b33b20275
.gitignore https://github.com/coder/coder/pull/2/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947
.prettierignore https://github.com/coder/coder/pull/2/files#diff-b640b344ee7f3f03d2a443795a5d0708ef50e2e6e34214109ab2aad13ad6ba98
Makefile https://github.com/coder/coder/pull/2/files#diff-76ed074a9305c04054cdebb9e9aad2d818052b07091de1f20cad0bbac34ffb52
db.go https://github.com/coder/coder/pull/2/files#diff-58f220e74a22ed363c5d159b92a4a5a58e425befe9c6728267c07b0c85dbc4e1
db_memory.go https://github.com/coder/coder/pull/2/files#diff-c751d40c385e83fcb8ababd9c127d29ed6fcfd3bb5d3854108d45632d8a4d07b
dump.sql https://github.com/coder/coder/pull/2/files#diff-937029b2b315061e5b2830d943c652ae2b151fa55ae2a7d23f88675774b06703
main.go https://github.com/coder/coder/pull/2/files#diff-869d7b16ed9788266e04d23c8d4f17f766a02e2bd66fccea5d93ec11fe0773b3
migrate.go https://github.com/coder/coder/pull/2/files#diff-ca9298609886d26ee0da2272c13d38f520bbdfdfb0d57bd17659af5a82df279b
migrate_test.go https://github.com/coder/coder/pull/2/files#diff-3d6070e75e455548d92512432118d837c55af68e469f1c2b4f865b410ff45abe
000001_base.down.sql https://github.com/coder/coder/pull/2/files#diff-39c957f2cb64f3513cdc2cea0ac905db14f6d3461ad116df86e3621130552f6f
000001_base.up.sql https://github.com/coder/coder/pull/2/files#diff-bc54d44ff96190427b19a7235ab4f4caf8a3be39ea904f66880a355d59983d3f
create_migration.sh https://github.com/coder/coder/pull/2/files#diff-4070076a619d013cf9eb016c4b469e7d70f3fa205c91355a37f37a7b1044a1f3
models.go https://github.com/coder/coder/pull/2/files#diff-f1792192d231f86a4b28f63400ca47a5c3e96cdbc3f6651114eac5ecd0bb57f1
postgres.go https://github.com/coder/coder/pull/2/files#diff-403bc61fce131b2a103c624ba30bb39cca08f16ba2de2c0f3e1d942f49ff964d
postgres_test.go https://github.com/coder/coder/pull/2/files#diff-67bd2d15f1c2eef6248e9a284e8fcdef1114d6b20762185345e549815c7ef921
querier.go https://github.com/coder/coder/pull/2/files#diff-c4aa3193342fe9d1fc81806dba97dbeca46a866df2e12c5dcfd8a5e420223669
query.sql https://github.com/coder/coder/pull/2/files#diff-05266e6008b993a65797bc3b91ae0575b1132ce18076886c16705da72f964fea
query.sql.go https://github.com/coder/coder/pull/2/files#diff-f8efe1b39829de7ebba897db1a1617ac887c39a0f4bfae73fe65e8b4517a5b58
sqlc.yaml https://github.com/coder/coder/pull/2/files#diff-2d99ba113c023cdfcd0dd532c4579356cec5ec29af07356ef389e4455d8added
go.mod https://github.com/coder/coder/pull/2/files#diff-33ef32bf6c23acb95f5902d7097b7a1d5128ca061167ec0716715b0b9eeaa5f6
go.sum https://github.com/coder/coder/pull/2/files#diff-3295df7234525439d778f1b282d146a4f1ff6b415248aaac074e8042d9f42d63
yarn.lock https://github.com/coder/coder/pull/2/files#diff-51e4f558fae534656963876761c95b83b6ef5da5103c4adef6768219ed76c2de
.eslintignorehttps://github.com/coder/coder/pull/2/files#diff-a0fdacd2ade87c5238dde44378f574f7e123e669acdf8b740878b14b33b20275
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/.eslintignore
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
.gitignorehttps://github.com/coder/coder/pull/2/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/.gitignore
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
https://github.com/coder/coder/pull/2/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947
.prettierignorehttps://github.com/coder/coder/pull/2/files#diff-b640b344ee7f3f03d2a443795a5d0708ef50e2e6e34214109ab2aad13ad6ba98
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/.prettierignore
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
https://github.com/coder/coder/pull/2/files#diff-b640b344ee7f3f03d2a443795a5d0708ef50e2e6e34214109ab2aad13ad6ba98
Makefilehttps://github.com/coder/coder/pull/2/files#diff-76ed074a9305c04054cdebb9e9aad2d818052b07091de1f20cad0bbac34ffb52
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/Makefile
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
https://github.com/coder/coder/pull/2/files#diff-76ed074a9305c04054cdebb9e9aad2d818052b07091de1f20cad0bbac34ffb52
database/db.gohttps://github.com/coder/coder/pull/2/files#diff-58f220e74a22ed363c5d159b92a4a5a58e425befe9c6728267c07b0c85dbc4e1
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/db.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/db_memory.gohttps://github.com/coder/coder/pull/2/files#diff-c751d40c385e83fcb8ababd9c127d29ed6fcfd3bb5d3854108d45632d8a4d07b
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/db_memory.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/dump.sqlhttps://github.com/coder/coder/pull/2/files#diff-937029b2b315061e5b2830d943c652ae2b151fa55ae2a7d23f88675774b06703
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/dump.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/dump/main.gohttps://github.com/coder/coder/pull/2/files#diff-869d7b16ed9788266e04d23c8d4f17f766a02e2bd66fccea5d93ec11fe0773b3
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/dump/main.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/migrate.gohttps://github.com/coder/coder/pull/2/files#diff-ca9298609886d26ee0da2272c13d38f520bbdfdfb0d57bd17659af5a82df279b
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/migrate.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/migrate_test.gohttps://github.com/coder/coder/pull/2/files#diff-3d6070e75e455548d92512432118d837c55af68e469f1c2b4f865b410ff45abe
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/migrate_test.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/migrations/000001_base.down.sqlhttps://github.com/coder/coder/pull/2/files#diff-39c957f2cb64f3513cdc2cea0ac905db14f6d3461ad116df86e3621130552f6f
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/migrations/000001_base.down.sql
Open in desktop https://desktop.github.com
database/migrations/000001_base.up.sqlhttps://github.com/coder/coder/pull/2/files#diff-bc54d44ff96190427b19a7235ab4f4caf8a3be39ea904f66880a355d59983d3f
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/migrations/000001_base.up.sql
Open in desktop https://desktop.github.com
database/migrations/create_migration.shhttps://github.com/coder/coder/pull/2/files#diff-4070076a619d013cf9eb016c4b469e7d70f3fa205c91355a37f37a7b1044a1f3
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/migrations/create_migration.sh
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
database/models.gohttps://github.com/coder/coder/pull/2/files#diff-f1792192d231f86a4b28f63400ca47a5c3e96cdbc3f6651114eac5ecd0bb57f1
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/models.go
Open in desktop https://desktop.github.com
how customized files appear on GitHubhttps://docs.github.com/github/administering-a-repository/customizing-how-changed-files-appear-on-github
Please reload this pagehttps://github.com/coder/coder/pull/2/files
database/postgres/postgres.gohttps://github.com/coder/coder/pull/2/files#diff-403bc61fce131b2a103c624ba30bb39cca08f16ba2de2c0f3e1d942f49ff964d
View file https://github.com/coder/coder/blob/35395815977390532b51639e7bb5bfe5ac484ed3/database/postgres/postgres.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/coder/coder/pull/2/{{ revealButtonHref }}
bryphe-coderhttps://github.com/bryphe-coder
Jan 4, 2022https://github.com/coder/coder/pull/2/files#r778234642
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/coder/coder/pull/2/files
Please reload this pagehttps://github.com/coder/coder/pull/2/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.