Python - from None to AI
  • License
  • Install
  • Python Versions
  • Python History
  • Links
  • References

Basics

  • 1. About
  • 2. Syntax
  • 3. Numeric
  • 4. Logic
  • 5. Strings
  • 6. Iterables
  • 7. Mappings
  • 8. Nested
  • 9. Unpack
  • 10. Conditional
  • 11. While
  • 12. For
  • 13. Comprehensions
  • 14. Files
  • 15. Functions
  • 16. Exceptions
  • 17. OOP
  • 18. Modules
  • 19. Recap

Intermediate

  • 1. About
  • 2. Syntax
  • 3. Star
  • 4. Enum
  • 5. Match
  • 6. Encoding
  • 7. Regex
  • 8. Datetime
  • 9. Idiom
  • 10. Iterator
  • 11. OOP
  • 12. Serialization
  • 13. Pickle
  • 14. TOML
  • 15. CSV
  • 16. JSON
  • 17. Pathlib
  • 18. Logging
  • 19. Modules
  • 20. Recap

Advanced

  • 1. About
  • 2. Syntax
  • 3. Typing
  • 4. OOP Dataclass
  • 5. OOP Paradigm
  • 6. OOP Inheritance
  • 7. OOP Abstract
  • 8. OOP Metaprogramming
  • 9. OOP Accessors
  • 10. OOP Operator
  • 11. FP Paradigm
  • 12. FP Apply
  • 13. FP Patterns
  • 14. Generators
  • 15. Async Paradigm
  • 16. Async AsyncIO

Performance

  • 1. About
  • 2. Multiprocessing
  • 3. Threading
  • 4. Optimization
  • 5. Case Study
  • 6. Extensions

Testing

  • 1. About
  • 2. Random
  • 3. Syntax
  • 4. Doctest
  • 5. Unittest
  • 6. Recap

CI/CD

  • 1. DevTools
  • 2. Distribute
  • 3. Lint
  • 4. Quality
  • 5. Security
  • 6. Webdev

DevOps

  • 1. About
  • 2. Quality
  • 3. Tests
  • 4. Debugging

Database

  • 1. About
  • 2. Theory
  • 3. ORM
  • 4. Normalization
  • 5. NoSQL
  • 6. SQL
  • 7. SQLite3
  • 8. SQLAlchemy
    • 8.1. SQLAlchemy About
    • 8.2. SQLAlchemy Connection DSN
    • 8.3. SQLAlchemy Connection Engine
    • 8.4. SQLAlchemy Connection Pool
    • 8.5. SQLAlchemy Core Model
    • 8.6. SQLAlchemy Core Operators
    • 8.7. SQLAlchemy Core Insert
    • 8.8. SQLAlchemy Core Select
    • 8.9. SQLAlchemy Core Result
    • 8.10. SQLAlchemy Core Update
    • 8.11. SQLAlchemy Core Delete
    • 8.12. SQLAlchemy Core Join
    • 8.13. SQLAlchemy Core Text
    • 8.14. SQLAlchemy Core Introspect
    • 8.15. SQLAlchemy ORM About
    • 8.16. SQLAlchemy Connection Session
    • 8.17. SQLAlchemy Model Base
    • 8.18. SQLAlchemy Model Define
    • 8.19. SQLAlchemy Model Column
    • 8.20. SQLAlchemy Model Types
    • 8.21. SQLAlchemy Model Indexes
    • 8.22. SQLAlchemy Model Relations
    • 8.23. SQLAlchemy Model Dataclass
    • 8.24. SQLAlchemy Schema Metadata
    • 8.25. SQLAlchemy Schema Reflection
    • 8.26. SQLAlchemy Migration About
    • 8.27. SQLAlchemy Migration Create
    • 8.28. SQLAlchemy Migration Apply
    • 8.29. SQLAlchemy Migration Rollback
    • 8.30. SQLAlchemy Query About
    • 8.31. SQLAlchemy Query Fetch
    • 8.32. SQLAlchemy Query Filter
    • 8.33. SQLAlchemy Query Limit
    • 8.34. SQLAlchemy Query Order By
    • 8.35. SQLAlchemy Query Group By
    • 8.36. SQLAlchemy Query Subquery
    • 8.37. SQLAlchemy Query Union
    • 8.38. SQLAlchemy Query Join
    • 8.39. SQLAlchemy Query Count
    • 8.40. SQLAlchemy Query Distinct
    • 8.41. SQLAlchemy Query Exists
    • 8.42. SQLAlchemy Query Update
    • 8.43. SQLAlchemy Query Delete
    • 8.44. SQLAlchemy Query Execute
    • 8.45. SQLAlchemy Query Debug
    • 8.46. SQLAlchemy Query Profile
      • 8.46.1. Profiling
      • 8.46.2. Populate Existing
    • 8.47. SQLAlchemy Func About
    • 8.48. SQLAlchemy Func Date
    • 8.49. SQLAlchemy Func Group
    • 8.50. SQLAlchemy Func Numeric
    • 8.51. SQLAlchemy Func Count
    • 8.52. SQLAlchemy Func Count
    • 8.53. SQLAlchemy Extensions
    • 8.54. SQLAlchemy Case Study
    • 8.55. SQLAlchemy Use Cases
  • 9. Case Study

Design Patterns

  • 1. About
  • 2. UML
  • 3. Decorators
  • 4. Creational
  • 5. Behavioral
  • 6. Structural

Numpy

  • 1. About
  • 2. Array
  • 3. Attributes
  • 4. Random
  • 5. Indexing
  • 6. Operations
  • 7. Methods
  • 8. Statistics
  • 9. Math
  • 10. Polynomial

Pandas

  • 1. About
  • 2. Read
  • 3. To
  • 4. Series
  • 5. DataFrame
  • 6. Date
  • 7. Case Study

Matplotlib

  • 1. About
  • 2. Figure
  • 3. Style
  • 4. Chart
  • 5. Case Study

Stdlib

  • 1. Modules
  • 2. Collections
  • 3. Math
  • 4. Locale
  • 5. XML
  • 6. Operating System
  • 7. String
  • 8. Builtin
  • 9. Type
  • 10. Loop
  • 11. TkInter

Network

  • 1. About
  • 2. Protocol
  • 3. Web
  • 4. Transport
  • 5. Case Study

Microservices

  • 1. About
  • 2. HTTP
  • 3. Microservices
  • 4. Auth

Django

  • 1. About
  • 2. Setup
  • 3. Settings
  • 4. Models
  • 5. Admin
  • 6. ORM
  • 7. Views
  • 8. Templates
  • 9. Templatetags
  • 10. Forms
  • 11. Manage
  • 12. Locale
  • 13. Middleware
  • 14. Utils
  • 15. Auth
  • 16. API
  • 17. Ninja
  • 18. Tests
  • 19. Apps
  • 20. Deploy

FastAPI

  • 1. About
  • 2. FastAPI
  • 3. Pydantic
  • 4. Database
  • 5. Auth
  • 6. DevOps
  • 7. Case Study

Data Science

  • 1. About
  • 2. Jupyter
  • 3. Python
  • 4. Visualization
  • 5. Scipy
  • 6. Geopandas

Machine Learning

  • 1. About
  • 2. Introduction
  • 3. Sklearn
  • 4. Model Quality
  • 5. Decision Trees
  • 6. Regressions
  • 7. K-Nearest Neighbors
  • 8. Bayes
  • 9. Support Vector Machines
  • 10. Clustering
  • 11. Neural Networks
  • 12. References
  • 13. Articles

Artificial Intelligence

  • 1. About

OOP

  • 1. Paradigm
  • 2. Python

Dragon

  • 1. English
  • 2. Polish
  • 3. ADR
Python - from None to AI
  • 1. About
  • 8.46. SQLAlchemy Query Profile

8.46. SQLAlchemy Query Profile

8.46.1. Profiling

  • https://docs.sqlalchemy.org/en/stable/orm/examples.html#module-examples.performance

  • https://docs.sqlalchemy.org/en/stable/faq/performance.html#faq-how-to-profile

8.46.2. Populate Existing

  • https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.populate_existing

Previous Next

© Copyright 2025, Matt Harasymczuk <matt@python3.info>, last update: 2025-04-23.