An Open Source SQL toolkit and object relational mapper for the Python programming language. #SQL toolkit #Object relational mapper #Python mapper #SQL #Alchemy #Toolkit
SQLAlchemy is an open source, platform-independent and free library software written in the Python programing language and designed from the ground up to act as a database abstraction library, ORM (Object Relational Mapper) and SQL toolkit for Python.
If you’re a Python developer, SQLAlchemy will give you the full flexibility and power of SQL, providing a complete collection of popular enterprise-level persistence patterns, which have been designed for high-performing and efficient database access.
The software is extremely easy to use, powerful enough for sophisticated tasks, and modular. With SQLAlchemy you will be able to organize pending CRUD operations, allows the use of boolean expressions, functions, operators, table aliases, UNION clauses, correlated EXISTS clauses, create, insert, delete and update queries, selectable subqueries, correlated updates, inner and outer joins, and bind parameters.
It can be used to generate databases, as well as to introspect them, support for loading related objects and collections, support for creating transparent persistence of objects based on patterns, support for manipulating and constructing domain models, as well as support for synchronizing all the changes with the current transaction automatically.
Among other features, we can mention a relationally-oriented query system that’s capable of exposing all of SQL’s functionality, including correlation, joins and subqueries, a DBAPI interaction layer, a core SQL construction system, a complete, standalone database abstraction layer, support for extensible SQL schema metadata, expression language, connection pooling, custom types and type coercion.
The program includes dialects for a wide variety of database servers and engines, including MySQL, PostgreSQL, Firebird, Oracle, Microsoft SQL Server, SQLite, Sybase, and many others.
The project is independent of an operating system, which means that it can be easily deployed and used on any GNU/Linux distribution, as well as on the Microsoft Windows, BSD or Mac OS X operating systems. Both 32-bit and 64-bit hardware architectures are supported at this time.
What's new in SQLAlchemy 0.9.8:
- orm:
- [orm] [bug] [engine] Fixed bug that affected generally the same classes of event as that of #3199, when the named=True parameter would be used. Some events would fail to register, and others would not invoke the event arguments correctly, generally in the case of when an event was “wrapped” for adaption in some other way. The “named” mechanics have been rearranged to not interfere with the argument signature expected by internal wrapper functions.
- [orm] [bug] Fixed bug that affected many classes of event, particularly ORM events but also engine events, where the usual logic of “de duplicating” a redundant call to event.listen() with the same arguments would fail, for those events where the listener function is wrapped. An assertion would be hit within registry.py. This assertion has now been integrated into the deduplication check, with the added bonus of a simpler means of checking deduplication across the board.
SQLAlchemy 0.9.8
add to watchlist add to download basket send us an update REPORT- runs on:
- Linux
- filename:
- SQLAlchemy-0.9.8.tar.gz
- main category:
- Database
- developer:
- visit homepage
Microsoft Teams 24060.3102.2733.5911 Home / 1.7.00.7956 Work
Bitdefender Antivirus Free 27.0.35.146
IrfanView 4.67
Windows Sandbox Launcher 1.0.0
Zoom Client 6.0.3.37634
4k Video Downloader 1.5.3.0080 Plus / 4.30.0.5655
calibre 7.9.0
ShareX 16.0.1
7-Zip 23.01 / 24.04 Beta
Context Menu Manager 3.3.3.1
- ShareX
- 7-Zip
- Context Menu Manager
- Microsoft Teams
- Bitdefender Antivirus Free
- IrfanView
- Windows Sandbox Launcher
- Zoom Client
- 4k Video Downloader
- calibre