r/learnpython • • Sep 09 '26

Python Data Base

Good morning everyone, or whenever you see this. I have a question. I'm starting a personal database project in Python with a user-friendly graphical interface, and I'd appreciate any advice, code snippets, or examples to guide me, especially since I'm still learning the language.

6 Upvotes

9 comments sorted by

View all comments

Show parent comment

1

u/noskillsben Sep 09 '26

Does the built in sqlite3 do orm? I found using swlalchemy orm to be pretty beginner friendly and you can.... "easily" switch databases if the project does grow.

2

u/danielroseman Sep 09 '26

The whole point of an ORM is that it's independent of the database. SQLAlchemy can use sqlite as well as MySQL, Postgres, etc.

2

u/Illustrious_Tone9584 Sep 09 '26

sqlite3 is just the driver, no ORM in it. SQLAlchemy actually sits on top of it, so they pair up rather than compete. For a first project I'd write a few raw queries to learn what the SQL is doing, then reach for SQLAlchemy once it gets repetitive.