Storm is an object-relational mapper (ORM) for Python.
It’s easy to write and support backends for Storm (current backends have around 100 lines of code).
Storm is free and open source software.
Key Features
- Fast.
- Efficiently access and update large datasets by allowing you to formulate complex queries spanning multiple tables using Python.
- Allows you to fallback to SQL if needed (or if you just prefer), allowing you to mix “old school” code and ORM code
- Handles composed primary keys with ease (no need for surrogate keys).
- Doesn’t do schema management, and as a result you’re free to manage the schema as wanted, and creating classes that work with Storm is clean and simple.
- Works very well connecting to several databases and using the same Python types (or different ones) with all of them.
- Handles obj.attr assignments, when that’s really needed (the expression is executed at INSERT/UPDATE time).
- Handles relationships between objects even before they were added to a database.
- Works well with existing database schemas.
- Flush changes to the database automatically when needed, so that queries made affect recently modified objects.
Website: github.com/petrhosek/storm
Support:
Developer: Canonical
License: Lesser General Public License, version 2.1
Storm is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| Python Object-Relational Mapping Software | |
|---|---|
| Django | High-level web application framework that has a powerful ORM |
| SQLAlchemy | Python SQL Toolkit and Object Relational Mapper |
| Peewee | Simple, small and expressive Object Relational Mapper. It has few concepts |
| Tortoise | Easy-to-use asyncio ORM inspired by Django |
| Pony | Billed as the smartest Python ORM |
| SQLObject | Forms a part of many applications including TurboGears |
| Storm | Designed to work with thin relational databases and big systems |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Know a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |