Coding

Storm – Object Relational Mapper

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
DjangoHigh-level web application framework that has a powerful ORM
SQLAlchemyPython SQL Toolkit and Object Relational Mapper
PeeweeSimple, small and expressive Object Relational Mapper. It has few concepts
SQLModelCombines database models with type-safe data validation
TortoiseEasy-to-use asyncio ORM inspired by Django
PonyBilled as the smartest Python ORM
PiccoloAsync-first database toolkit with migrations and a powerful query API
SQLObjectForms a part of many applications including TurboGears
ormarBuild expressive async database models with minimal boilerplate
EdgyModern async database layer focused on simplicity and flexibility
SaffierLightweight async data modelling with support for multiple databases
StormDesigned to work with thin relational databases and big systems

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted