+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Does Python have an ORM module? (/thread-31345.html)
Does Python have an ORM module? - muzikman - Dec-05-2020
Greetings,
Does Python have an ORM package? I thought my days of typing long SQL queries was over.
Thanks,
Matt
RE: Does Python have an ORM module? - buran - Dec-05-2020
SQLAlchemy
RE: Does Python have an ORM module? - Larz60+ - Dec-05-2020
I posted an sqlalchemy starter tutorial here: https://python-forum.io/Thread-SqlAlchemy-Tutorial-Basic-Model-database-Creation-and-Data-Load
RE: Does Python have an ORM module? - snippsat - Dec-05-2020
SQLAlchemy is the biggest,there are serval like others like eg peewee and Pony
My favorite Flask-SQLAlchemy make use SQLAlchemy integration easy.
Django has own ORM build in.
Outside of web usage for small to medium project i like TinyDB, dataset or sqlite3(comes with Python) with it's lightweight one file disk-based database.
RE: Does Python have an ORM module? - muzikman - Dec-07-2020
The SQLAlchemy is a language on it's own. I liked Flask, Peewee, Pony.
sqlite3 comes with Python? If so, how do I test it from the command line?
RE: Does Python have an ORM module? - bowlofred - Dec-07-2020
The sqlite command-line client doesn't come with python. If you're on linux, it's probably already installed. On windows, you need to download it.
RE: Does Python have an ORM module? - Larz60+ - Dec-07-2020
to test from command line, install sqlite3 see: https://www.sqlitetutorial.net/download-install-sqlite/