Python Forum

Greetings,

Does Python have an ORM package? I thought my days of typing long SQL queries was over.

Thanks,
Matt

I posted an sqlalchemy starter tutorial here: https://python-forum.io/Thread-SqlAlchem...-Data-Load

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.

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?

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.

to test from command line, install sqlite3 see: https://www.sqlitetutorial.net/download-install-sqlite/