{"repo":"sayanarijit/sqla-fancy-core","free":true,"listed":false,"github":"https://github.com/sayanarijit/sqla-fancy-core","clone":"git clone https://github.com/sayanarijit/sqla-fancy-core.git","description":"A collection of type-safe, async friendly, and un-opinionated enhancements to SQLAlchemy Core that works well with mordern web servers","language":"Python","stars":35,"topics":["database","orm","query-builder","sql","sqlalchemy","transactions"],"license":"MIT","category":"databases-storage","readme_excerpt":"sqla-fancy-core A collection of type-safe, async friendly, and un-opinionated enhancements to SQLAlchemy Core that works well with mordern web servers. Why? - ORMs are magical, but it's not always a feature. Sometimes, we crave for familiar. - SQLAlchemy Core is powerful but table.c.column breaks static type checking and has runtime overhead. This library provides a better way to define tables while keeping all of SQLAlchemy's flexibility. See Table Builder. - The idea of sessions can feel too magical and opinionated. This library removes the magic and opinions and takes you to back to familiar transactions's territory, providing multiple un-opinionated APIs to deal with it. See Wrappers and Decorators. Demos: - FastAPI - sqla-fancy-core example app. Table builder Define tables with static column references Example: Define tables: For complex scenarios, define columns and constraints explicitly: Create tables: Perform CRUD operations: Fancy Engine Wrappers Simplify running queries with or without explicit connection or transaction. The fancy() function wraps a SQLAlchemy engine and provides: Execute query in transaction - tx(conn, query) : Execute query in optional transaction (reuses atomic() context if available, else creates new) - atomic() : Context manager for transaction scope - ax(query) : Execute inside atomic() context (raises AtomicContextError outside) - atx(query) : Auto-transactional (reuses atomic() if present, or creates new transaction) Execute query without t","default_branch":null,"files":null,"tree":[],"storefront":"/r/sayanarijit","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sayanarijit/sqla-fancy-core/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}