+- Python Forum (https://python-forum.io)
+-- Forum: General (https://python-forum.io/forum-1.html)
+--- Forum: News and Discussions (https://python-forum.io/forum-31.html)
+--- Thread: Potential Pitfalls of Over-Reliance on SQLAlchemy (/thread-41194.html)
Potential Pitfalls of Over-Reliance on SQLAlchemy - codingismycraft - Nov-26-2023
Using SQLAlchemy, a widely-used SQL toolkit and Object-Relational Mapping (ORM) system in Python, may not always be the best choice for all scenarios. Although powerful and effective for creating UI-focused services, SQLAlchemy might lead to undesirable outcomes when used for backend services requiring modularity, high performance, and maintainability. In such cases, over-reliance on SQLAlchemy can contradict fundamental object-oriented principles, resulting in poorly structured code.
Personally, i use SQLAlchemy very sparingly and usually prefer thinner libraries based exclusively on raw SQL and I would like to head what others are thinking about..
Here you can read a mode detailed view of what i am saying:
https://codingismycraft.blog/index.php/2023/11/26/potential-pitfalls-of-over-reliance-on-sqlalchemy/