Flask + Turso

Set up Turso in your Flask project in minutes

Prerequisites

Before you start, make sure you:

• Install the Turso CLI
• Sign up or login to Turso
• Have a Flask app — learn more

1. Install the libSQL dialect

   npm

   pip install sqlalchemy-libsql python-dotenv
   
2. Comfigure database credentials.

   Get the database URL.

   turso db show --url <database-name>
   

   Get the database authentication token.

   turso db tokens create <database-name>
   

   Assign credentials to the environment variables inside .env.

   TURSO_DATABASE_URL="..."
   TURSO_AUTH_TOKEN="..."
   
3. Create database models

   models.py

   from sqlalchemy import String
   from sqlalchemy.orm import DeclarativeBase
   from sqlalchemy.orm import Mapped
   from sqlalchemy.orm import mapped_column
   
   class Base(DeclarativeBase):
       pass
   
   class Item(Base):
       __tablename__ = "items"
       id: Mapped[str] = mapped_column(primary_key=True)
       foo: Mapped[str] = mapped_column(String(255))
       bar: Mapped[str] = mapped_column(String(100))
       def __repr__(self) -> str:
           return f"Item(id={self.id!r}, foo={self.foo!r}, bar={self.bar!r})"
   
4. Query database

   app.py

   from dotenv import load_dotenv
   from sqlalchemy import create_engine
   from sqlalchemy.orm import Session
   from sqlalchemy import select
   from models import Item
   
   load_dotenv()
   
   # Get environment variables
   TURSO_DATABASE_URL = os.environ.get("TURSO_DATABASE_URL")
   TURSO_AUTH_TOKEN = os.environ.get("TURSO_AUTH_TOKEN")
   
   # construct special SQLAlchemy URL
   dbUrl = f"sqlite+{TURSO_DATABASE_URL}/?authToken={TURSO_AUTH_TOKEN}&secure=true"
   
   engine = create_engine(dbUrl, connect_args={'check_same_thread': False}, echo=True)
   
   @app.route("/", methods=(["GET"]))
   def home():
       session = Session(engine)
   
       # get & print items
       stmt = select(Item)
   
       for item in session.scalars(stmt):
           print(item)
   

Examples

Social App

See the full source code