Search code, repositories, users, issues, pull requests...
Naked SQLAlchemy is a simple and efficient layer on top of SQLAlchemy Core, designed to make database access faster and easier by focusing on query execution and result mapping to data classes.
After facing pitfalls with ORM in-memory data not matching the actual database state due to complexities like identity mapping and dirty tracking—I realized these features, meant to ease development, often make things more complicated and harder to learn. Naked SQLAlchemy bridges over these unnecessary layers by promoting explicit SQL usage and direct mapping of query results to Python dataclasses.
Besides significant speed improvements (nearly twice as fast as ORMs), Naked SQLAlchemy is easy to learn because it builds on knowledge you probably already have. By focusing on essential features and bypassing overcomplicated abstractions, it empowers you to write clear, maintainable code without the usual ORM headaches.
My philosophy is that less is more. By shedding unnecessary layers of ORMs, Naked SQLAlchemy provides a reliable, efficient, and straightforward approach to database access in Python. If you're looking for a tool that sidesteps common ORM pitfalls and leverages your existing SQL expertise, I invite you to explore Naked SQLAlchemy.
