pyDAL
Write database-agnostic Python code. This pure Python DAL dynamically generates SQL/NoSQL, mapping records to dictionaries for simpler data access.
pyDAL is a pure Python Database Abstraction Layer that dynamically generates SQL/NoSQL queries in real-time for the specified database backend. This means you don't need to write raw SQL or learn different dialects, making your code portable across various databases.
Unlike many ORMs that map tables to classes and rows to objects, pyDAL maps records to Python dictionaries, offering a simpler syntax closer to SQL. Originally part of web2py, it's now an independent package for Python 3.7+.
Key features include:
- Transactions
- Aggregates
- Inner & Outer Joins
- Nested Selects
It supports a wide range of databases, including:
- SQLite, MySQL, PostgreSQL, MSSQL
- Oracle, DB2, FireBird, Sybase
- MongoDB, Google Firestore
Starlight
pdoc
WretchSimilar to pyDAL:
A small, expressive Python ORM for simpler database interactions.
ORMsPython
Build Python applications with a simple, expressive ORM. Supports PostgreSQL, MySQL, SQLite, and CockroachDB. Features easy model definition and powerful querying.
Databases for lazy people. Simple SQL data handling.
ORMsPython
Handle SQL data stores easily with implicit table creation, bulk loading, and transaction support. Makes database operations feel like working with JSON.
Async database access for Python with validation.
ORMsPython
An async Python ORM supporting Postgres, MySQL, and SQLite. Built with SQLAlchemy core, Databases, and Pydantic for validation and migrations.
Pythonic SQL toolkit and ORM for flexible database access.
ORMsPython
Access databases in Python with a powerful SQL toolkit and Object Relational Mapper. Gain full SQL flexibility and high-performance persistence patterns.
Profile live Python code safely, with minimal overhead.
DebuggingProfiling+1 more
Profile running Python programs with extremely low overhead. Visualize time spent without restarting or modifying code. Safe for production environments.
Visual profiler for Python
DebuggingProfiling+1 more
Python package providing rich and interactive visualizations for various Python program characteristics such as running time and memory usage.
Flexible toolkit for Python code tracing and debugging.
DebuggingPython
Trace Python code execution with powerful filters and custom actions. Debug, log, and inspect code behavior without complex setup or storage.
Visual Python debugging, right in your terminal.
DebuggingPython
Debug Python code visually within your console. Offers a lightweight, keyboard-driven interface with syntax highlighting, stack traces, and variable inspection.
IPython power for your Python debugging sessions.
DebuggingPython
Integrate IPython's enhanced features like tab completion, syntax highlighting, and better tracebacks into the standard Python debugger (pdb).