Should I use odbc lib or azure sql binding to query azure sql in a python azure function?

This page summarizes the projects mentioned and recommended in the original post on /r/AZURE

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • SQLAlchemy

    The Database Toolkit for Python

    There isn't much documentation on the pro's or con's of either method. I am utilizing fast api, which is async, and currently if I am not mistaken there are no current odbc python libs that support async for sql server other than something like aioodbc, but in the case of this lib it utilizes threads. ( Async driver support for mssql dialect · Issue #6521 · sqlalchemy/sqlalchemy (github.com) )

  • azure-functions-host

    The host/runtime that powers Azure Functions

    ODBC drivers in most (if not all) cases are slower than native libraries. I didn't check what does binding for python uses, you can check their repo if you want to https://github.com/Azure/azure-functions-host

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts