pyodbc
starlette
pyodbc | starlette | |
---|---|---|
23 | 55 | |
2,847 | 9,541 | |
- | 2.1% | |
7.8 | 9.2 | |
17 days ago | 2 days ago | |
C++ | Python | |
MIT No Attribution | BSD 3-clause "New" or "Revised" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pyodbc
-
Is there a way to monitor in real time all SQL commands Sent to SQL Server 2017 through Python
Python can script and view this via pyodbc... https://github.com/mkleehammer/pyodbc/wiki
-
Problems Changing a Password with Pyodbc
I am not 100% sure you call stored procedure correctly. in the examples they declare @out parameter for the procedures with output.
- Trying to deploy a windows based Python & Flask web app
-
Self-hosted Car Infotainment
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.
-
How to use a value more than once in a Prepared Statement (pyodbc)
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.
-
Installing pyodbc in termux help
~ $ 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:
- Weird error with driver - Data source name not found and no default driver specified
- pyodbc, unixODBC Driver Manager Error
-
ODBC and OLE DB connections "going stale" after several hours
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.
-
Python using MS Access?
See the docs.
starlette
- Ask HN: What is your go-to stack for the web?
-
Building Fast APIs with FastAPI: A Comprehensive Guide
Fast Execution: FastAPI is built on top of Starlette and Pydantic, making it one of the fastest Python frameworks for building APIs.
-
Embracing Modern Python for Web Development
The framework's efficiency comes from its use of Starlette for building asynchronous web services and Pydantic for robust data validation and serialization, powered by Python's type hints. Pydantic has recently announced the official release of Pydantic V2 (June 2023), which is a ground-up rewrite that offers many new features and performance improvements, so make sure to be using that instead of V1.
-
FastHttp for Python (64k requests/s)
Uvicorn + Starlette 8k requests/s
- Microdot "The impossibly small web framework for Python and MicroPython"
-
An Introduction to ⚡FastAPI
Starlette documentation
-
Writing a chat application in Django 4.2 using async StreamingHttpResponse
Same here, but without these weird utils it doesn't get any better.
I have 7 YoE with Django. Its great at so many things. You see some code, like middlewares, and immediately understand what's going on.
Now, we also have Starlette. The base of all new, fancy asgi libraries. Here's the base middleware class.
https://github.com/encode/starlette/blob/8d7a1cacfb3e1a30cbb...
In the last couple of years I heard 'we're running fastapi on production. Wanna join us?' so many times... but the reality is that it's still not suitable for prod. Who wants to work with a code like that if you have a readable, stable Django? I'm clueless.
-
Deploying an ML model to Paperspace and creating an API
Set up Starlette, a tool we'll use to make async requests
-
FastAPI middleware doesn't run while making request to websocket endpoint
I never used websockets in FastAPI so I wouldn't know how to guide you more, but Middleware in Websockets are 100% supported by Starlette : https://github.com/encode/starlette/issues/641
-
Chat implementation
Websockets are the way but I would not recommend django as it's still not fully async. I would go for other tools.
What are some alternatives?
PyHive - Python interface to Hive and Presto. 🐝
Flask - The Python micro framework for building web applications.
PyAthena - PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production
TinyDB - TinyDB is a lightweight document oriented database optimized for your happiness :)
uvicorn - An ASGI web server, for Python. 🦄
SQLMap - Automatic SQL injection and database takeover tool
AIOHTTP - Asynchronous HTTP client/server framework for asyncio and Python
django-pyodbc-azure - Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc
starlite - Light, Flexible and Extensible ASGI API framework | Effortlessly Build Performant APIs [Moved to: https://github.com/litestar-org/litestar]
shillelagh - Making it easy to query APIs via SQL
quart - An async Python micro framework for building web applications.