What would you recommend to use for using databases through Python?

Question

Python

Greetings
I have not encountered databases before, only at the level of "manually find something through PHPMyAdmin and edit, add or delete". I want to better understand how databases work in conjunction with Python. What literature and libraries would you recommend reading and using for databases along with Python - where to start and where to finish?

Answer 1

Start by reading something like Martin Graber's "SQL for mere mortals" tutorial to learn about SQL and how relational databases work. Finish by learning the Python DB-API.

Answer 2

It depends on which subd you want to use and why. For example, for sqlite3 there is a Db browser for sqlite program, in which you can view the database, write queries, create tables, in short, ala phpmyadmin. At the first stage, it will help to simply see what is the syntax for creating tables and debugging database queries.