The Type Hierarchy — SQLAlchemy 1.4 Documentation

SQLAlchemy provides abstractions for most common database data types, as well as several techniques for customization of datatypes. Database types are represented using Python classes, all of which ultimately extend from the base type class known as TypeEngine. There are two general categories of datatypes, each of which express themselves within the typing hierarchy in different ways. The category used by an individual datatype class can be identified based on the use of two different naming conventions, which are “CamelCase” and “UPPERCASE”. See also Setting up MetaData with Table objects - in the SQLAlchemy 1.4 / 2.0 Tutorial. Illustrates the most rudimental use of TypeEngine type objects to define Table metadata and introduces the concept of type objects in tutorial form. The rudimental types have “CamelCase” names such as String, Numeric, Integer, and DateTime. All of the immediate subclasses of TypeEngine are “CamelCase” types. The “CamelCase” types are to the greatest degree pos

The Type Hierarchy - SQLAlchemy 1.4 Documentation via SQLAlchemy adapter --> Release: 1.4.54 legacy version | Release Date: September 5, 2024 SQLAlchemy 1.4 Documentation SQLAlchemy 1.4 Documentation legacy version Home | Download this Documentation Search terms: SQLAlchemy Core SQL Expression Language Tutorial (1.x API) SQL Statements and Expressions API Schema Definition Language 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 “CamelC

related reading

• Against SQLscattered-thoughts.net
• Working with Database Metadata - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
• SQLAlchemy - Quick Guidetutorialspoint.com
• Glossary - SQLAlchemy 1.4 Documentationdocs.sqlalchemy.org
• Describing Databases with MetaData - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
• SQL style guide by Simon Holywellsqlstyle.guide
• Object Relational Tutorial - SQLAlchemy 1.3 Documentationdocs.sqlalchemy.org
• Pyrefly vs. ty: Comparing Python’s Two New Rust-Based Type Checkers | Edward Li's Blogblog.edward-li.com
• Working with Engines and Connections - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
• The key technologies behind SQL Comprehension | dbt Developer Blogdocs.getdbt.com
• PostgreSQL: Documentation: 18: 8.1. Numeric Typespostgresql.org
• Working with Transactions and the DBAPI - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org