SQLAlchemy
The Database Toolkit for Python
The Database Toolkit for Python
  • home
  • features
    • Feature Overview
    • Testimonials
  • blog
  • library
    • Library
    • Reference

    • Version 2.0 (development)
    • Version 1.4
    • Version 1.3
    • Version 1.2

    • Architecture
    • Citing SQLAlchemy
    • Blog Posts
    • Talks and Tutorials
    • Recipes
  • community
    • Get Support
    • Participate
    • Develop
    • Code of Conduct
    • Github
  • download
    • Download
    • Current Release Series (1.4)
    • Maintenance Release (1.3)
    • Development Access
    • License
    • Version Numbering
    • Release Status
Release: 1.4.40 current release | Release Date: August 8, 2022

SQLAlchemy 1.4 Documentation

SQLAlchemy 1.4 Documentation

current release

Home | Download this Documentation

SQLAlchemy Core

  • SQL Expression Language Tutorial (1.x API)
  • SQL Statements and Expressions API
  • Schema Definition Language
  • SQL Datatype Objects¶
    • The Type Hierarchy
    • Custom Types
    • Base Type API
  • Engine and Connection Use
  • Core API Basics
  • SQLAlchemy 2.0 Future (Core)

Project Versions

  • 1.4.40

Home | Download this Documentation

  • Previous: Customizing DDL
  • Next: The Type Hierarchy
  • Up: Home
    • SQLAlchemy Core
  • On this page:
    • SQL Datatype Objects

SQL Datatype Objects¶

  • The Type Hierarchy
    • The “CamelCase” datatypes
    • The “UPPERCASE” datatypes
    • Backend-specific “UPPERCASE” datatypes
    • Using “UPPERCASE” and Backend-specific types for multiple backends
    • Generic “CamelCase” Types
    • SQL Standard and Multiple Vendor “UPPERCASE” Types
  • Custom Types
    • Overriding Type Compilation
    • Augmenting Existing Types
    • TypeDecorator Recipes
      • Coercing Encoded Strings to Unicode
      • Rounding Numerics
      • Store Timezone Aware Timestamps as Timezone Naive UTC
      • Backend-agnostic GUID Type
      • Marshal JSON Strings
    • Applying SQL-level Bind/Result Processing
    • Redefining and Creating New Operators
    • Creating New Types
    • Working with Custom Types and Reflection
  • Base Type API
Previous: Customizing DDL Next: The Type Hierarchy
© Copyright 2007-2022, the SQLAlchemy authors and contributors.

flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.

Created using Sphinx 5.0.2.

SQLAlchemy Sponsors

Python

Website content copyright © by SQLAlchemy authors and contributors. SQLAlchemy and its documentation are licensed under the MIT license.

SQLAlchemy is a trademark of Michael Bayer. mike(&)zzzcomputing.com All rights reserved.

Website generation by zeekofile, with huge thanks to the Blogofile project.