SQLObject is a popular Object Relational Manager for providing an object interface to your database, with tables as classes, rows as instances, and columns as attributes.
SQLObject includes a Python-object-based query language that makes SQL more abstract, and provides substantial database independence for applications. Python 2.7 or 3.4+ is required.
This is free and open source software.
Key Features
- Supports MySQL, PostgreSQL and SQLite; connections to other backends – Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB) – are lesser debugged).
- Uses class definitions to form table schemas, and utilizes the language’s reflection and dynamism to be useful.
- Mature software. The first release was back in 2002.
Website: github.com/sqlobject/sqlobject
Support:
Developer: Ian Bicking and contributors
License: GNU Lesser General Public License v2.1
SQLObject 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. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |