gino-starlette

Introduction

An extension for GINO to support starlette server.

Usage

The common usage looks like this:

from starlette.applications import Starlette
from gino.ext.starlette import Gino

app = Starlette()
db = Gino(app, **kwargs)

Configuration

GINO adds a middleware to the Starlette app to setup and cleanup database according to the configurations that passed in the kwargs parameter.

The config includes:

Name	Description	Default
`driver`	the database driver	`asyncpg`
`host`	database server host	`localhost`
`port`	database server port	`5432`
`user`	database server user	`postgres`
`password`	database server password	empty
`database`	database name	`postgres`
`dsn`	a SQLAlchemy database URL to create the engine, its existence will replace all previous connect arguments.	N/A
`retry_times`	the retry times when database failed to connect	`20`
`retry_interval`	the interval in seconds between each time of retry	`5`
`pool_min_size`	the initial number of connections of the db pool.	N/A
`pool_max_size`	the maximum number of connections in the db pool.	N/A
`echo`	enable SQLAlchemy echo mode.	N/A
`ssl`	SSL context passed to `asyncpg.connect`	`None`
`use_connection_for_request`	flag to set up lazy connection for requests.	N/A
`retry_limit`	the number of retries to connect to the database on start up.	1
`retry_interval`	seconds to wait between retries.	1
`kwargs`	other parameters passed to the specified dialects, like `asyncpg`. Unrecognized parameters will cause exceptions.	N/A

Lazy Connection

If use_connection_for_request is set to be True, then a lazy connection is available at request['connection']. By default, a database connection is borrowed on the first query, shared in the same execution context, and returned to the pool on response. If you need to release the connection early in the middle to do some long-running tasks, you can simply do this:

await request['connection'].release(permanent=False)

An extension for GINO to support Starlette server.

Related tags

Overview

gino-starlette

Introduction

Usage

Configuration

Lazy Connection

Owner

GINO Community

EML analyzer is an application to analyze the EML file

Money Transaction is a system based on the recent famous FastAPI.

Fastapi practice project

Mnist API server w/ FastAPI

FastAPI + Django experiment

Async and Sync wrapper client around httpx, fastapi, date stuff

python fastapi example connection to mysql

Example of using FastAPI and MongoDB database.

A minimalistic example of preparing a model for (synchronous) inference in production.

Backend, modern REST API for obtaining match and odds data crawled from multiple sites. Using FastAPI, MongoDB as database, Motor as async MongoDB client, Scrapy as crawler and Docker.

This is a FastAPI application that provides a RESTful API for the Podcasts from different podcast's RSS feeds

Minimal example utilizing fastapi and celery with RabbitMQ for task queue, Redis for celery backend and flower for monitoring the celery tasks.

📦 Autowiring dependency injection container for python 3

[rewrite 중] 코로나바이러스감염증-19(COVID-19)의 국내/국외 발생 동향 조회 API | Coronavirus Infectious Disease-19 (COVID-19) outbreak trend inquiry API

An extension for GINO to support Starlette server.

Example projects built using Piccolo.

Ready-to-use and customizable users management for FastAPI

Analytics service that is part of iter8. Robust analytics and control to unleash cloud-native continuous experimentation.

Publish Xarray Datasets via a REST API.

Online Repo Browser