| react-profiling | 0 |
| react-import-map | react,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/blob/*name(/*path) |
| route-controller | blob |
| route-action | show |
| fetch-nonce | v2:96c5a254-a44a-c3b1-fc1e-373d48976a40 |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | 80A2:C4871:657BE4:8BDE18:6AFDEB9B |
| html-safe-nonce | 40ac26702ca54a21d7892504fa6155aa38cdab363163146ddb10569328415664 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4MEEyOkM0ODcxOjY1N0JFNDo4QkRFMTg6NkFGREVCOUIiLCJ2aXNpdG9yX2lkIjoiNDcxNzI1OTI1NDExNTcyNDE4NyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 569f93537b33310d245eda6e8f8209579e582fbdb14015dd9d6126ab3b785c6c |
| hovercard-subject-tag | repository:226369902 |
| github-keyboard-shortcuts | repository,source-code,file-tree,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | ///blob/show |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md |
| twitter:image | https://opengraph.githubassets.com/88b10da9f01d54c1c2a86ecd996cbe557745b36d62844a220be296c308ad9dea/firejava/fastapi |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/88b10da9f01d54c1c2a86ecd996cbe557745b36d62844a220be296c308ad9dea/firejava/fastapi |
| og:image:alt | FastAPI framework, high performance, easy to learn, fast to code, ready for production - firejava/fastapi |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | dd812ec581ecac95855f5ec917ef9827506c39a9da1443f43ddb4179a46471eb |
| turbo-cache-control | no-cache |
| go-import | github.com/firejava/fastapi git https://github.com/firejava/fastapi.git |
| octolytics-dimension-user_id | 623795 |
| octolytics-dimension-user_login | firejava |
| octolytics-dimension-repository_id | 226369902 |
| octolytics-dimension-repository_nwo | firejava/fastapi |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | true |
| octolytics-dimension-repository_parent_id | 160919119 |
| octolytics-dimension-repository_parent_nwo | fastapi/fastapi |
| octolytics-dimension-repository_network_root_id | 160919119 |
| octolytics-dimension-repository_network_root_nwo | fastapi/fastapi |
| 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 | 32ac708bac264dafdc28e10ff49b4d137f0c34a7 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffirejava%2Ffastapi%2Fblob%2Fmaster%2Fdocs%2Ftutorial%2Fsql-databases.md |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| 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 |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | 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/enterprise/premium-support |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffirejava%2Ffastapi%2Fblob%2Fmaster%2Fdocs%2Ftutorial%2Fsql-databases.md |
| 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%2Fblob%2Fshow&source=header-repo&source_repo=firejava%2Ffastapi |
| Reload | https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md |
| Reload | https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md |
| Reload | https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md |
| firejava | https://github.com/firejava |
| fastapi | https://github.com/firejava/fastapi |
| Code | https://github.com/firejava/fastapi |
| Pull requests | https://github.com/firejava/fastapi/pulls |
| Actions | https://github.com/firejava/fastapi/actions |
| Projects | https://github.com/firejava/fastapi/projects |
| Security and quality | https://github.com/firejava/fastapi/security |
| Insights | https://github.com/firejava/fastapi/pulse |
| https://github.com/firejava/fastapi |
| fastapi | https://github.com/firejava/fastapi/tree/master |
| docs | https://github.com/firejava/fastapi/tree/master/docs |
| tutorial | https://github.com/firejava/fastapi/tree/master/docs/tutorial |
| History | https://github.com/firejava/fastapi/commits/master/docs/tutorial/sql-databases.md |
| https://github.com/firejava/fastapi/commits/master/docs/tutorial/sql-databases.md |
| fastapi | https://github.com/firejava/fastapi/tree/master |
| docs | https://github.com/firejava/fastapi/tree/master/docs |
| tutorial | https://github.com/firejava/fastapi/tree/master/docs/tutorial |
| Raw | https://github.com/firejava/fastapi/raw/refs/heads/master/docs/tutorial/sql-databases.md |
| SQLAlchemy | https://www.sqlalchemy.org/ |
| https://github.com/tiangolo/full-stack-fastapi-postgresql |
| https://github.com/tiangolo/full-stack-fastapi-postgresql | https://github.com/tiangolo/full-stack-fastapi-postgresql |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#orms |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#file-structure |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-the-sqlalchemy-parts |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#import-the-sqlalchemy-parts |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-a-database-url-for-sqlalchemy |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-the-sqlalchemy-engine |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#note |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-a-sessionlocal-class |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-a-base-class |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-the-database-models |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-sqlalchemy-models-from-the-base-class |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-model-attributescolumns |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-the-relationships |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-the-pydantic-models |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-initial-pydantic-models--schemas |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#sqlalchemy-style-and-pydantic-style |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-pydantic-models--schemas-for-reading--returning |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#use-pydantics-orm_mode |
| Config | https://pydantic-docs.helpmanual.io/#config |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#technical-details-about-orm-mode |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#crud-utils |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#read-data |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-data |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#main-fastapi-app |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-the-database-tables |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#alembic-note |
| Alembic | https://alembic.sqlalchemy.org/en/latest/ |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-a-dependency |
| Dependencies with yield | https://fastapi.tiangolo.com/tutorial/dependencies/dependencies-with-yield/ |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-your-fastapi-path-operations |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#about-def-vs-async-def |
| the very technical details of how this async def vs def is handled | https://fastapi.tiangolo.com/async/#very-technical-details |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#migrations |
| Alembic | https://alembic.sqlalchemy.org |
| Celery | http://www.celeryproject.org/ |
| RQ | https://python-rq.org/ |
| ARQ | https://arq-docs.helpmanual.io/ |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#review-all-the-files |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#check-it |
| http://127.0.0.1:8000/docs |
| http://127.0.0.1:8000/docs | http://127.0.0.1:8000/docs |
| https://github.com/firejava/fastapi/blob/master/img/tutorial/sql-databases/image01.png |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#interact-with-the-database-directly |
| DB Browser for SQLite | https://sqlitebrowser.org/ |
| https://github.com/firejava/fastapi/blob/master/img/tutorial/sql-databases/image02.png |
| SQLite Viewer | https://inloop.github.io/sqlite-viewer/ |
| ExtendsClass | https://extendsclass.com/sqlite-browser.html |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#alternative-db-session-with-middleware |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#create-a-middleware |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#about-requeststate |
| request.state is a property of each Starlette Request object | https://www.starlette.io/requests/#other-state |
| https://github.com/firejava/fastapi/blob/master/docs/tutorial/sql-databases.md#dependencies-with-yield-or-middleware |
|
| 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 |