pyodbc VS AIOHTTP

Python can script and view this via pyodbc... https://github.com/mkleehammer/pyodbc/wiki

I am not 100% sure you call stored procedure correctly. in the examples they declare @out parameter for the procedures with output.

pyodbc has the odb2 part figured out. This could be useful instead of reinventing the wheel. The rest I can't think of anything that has been done. Sounds like an interesting project.

From its documentation it looks like pyodbc conforms to the DB API, so you can probably use named parameters by passing a dictionary to execute(), as described here.

~ $ pip show pyodbc Name: pyodbc Version: 4.0.34 Summary: DB API Module for ODBC Home-page: https://github.com/mkleehammer/pyodbc Author: Author-email: License: MIT Location: /data/data/com.termux/files/usr/lib/python3.10/site-packages Requires: Required-by:

I am trying to migrate data from our Enterprise Data Warehouse to one of our own reporting databases via ODBC and Python scripts. The python scripts import pyodbc to handle the database connections and execute SQL queries. A system DSN is defined on our ETL server for each database involved in the process.

See the docs.

> AIOHTTP: The Python int constructor is used to parse Content-Lengths and chunk-sizes, so _, +, and - are misinterpreted.

Fun. I believe the fix is incomplete here[1]. Python's int() constructor accepts integers comprised of any unicode numeral, for example, int("٦٦٦") == 666, and "٦٦٦".isdecimal() == True.

[1] https://github.com/aio-libs/aiohttp/pull/7663/files#diff-197...

aiohttp

If you want speed, I would try to rewrite everything using an asynchronous library like aiohttp.

requests does not support async out-of-the-box, so we will use aiohttp to avoid complications. requests can do the job, and there is no substantial performance difference. But the code is more readable using aiohttp.

I'm using aiohttp to build an API server that sends TCP requests off to a seperate server. The module that sends the TCP requests is synchronous and a black box for my purposes. So my problem is that these requests are blocking the entire API. I need a way to wrap the module requests in an asynchronous coroutine that won't block the rest of the API.

aiohttp - Everything that I need and nothing that I don't.

Use aiohttp to download the content of each page of lists. As of this Code Review post, this is the only step we execute.

Reminds me of this post from 5 months ago, but it was for a Python library. I made a discussion thread on the aiohttp repo and someone ended up contacting the reddit admins about it. The problem seems to be resolved now.