-3
I am a beginner and in the future I intend to make a management system for small businesses. A local system, which would be the best database learn to do this kind of software in Python 3?
2 answers
1
The question will probably be closed because it is not directly linked to programming, and every question related to "what is the best..." involves subjective criteria.
However, there is an answer worth leaving here: In Python and other very high-level languages, it is unusual to have, in code that goes really to production, although in simple applications, a direct database dependency - the most common is to have an intermediate layer that exposes the database data as objects in the program (an ORM - "Objetc Relational Manager"). The ORM, in turn, abstracts all operations with the bank, and supports several databases - all the best known, of course - and your program will work the same, regardless of the bank behind - just change the connection configuration and the same code, written using ORM, works with any bank.
Ai, it is common to use sqlite, which comes along with Python, for development, and, in the production environment, if you set up some other database. But nothing prevents you from using a bank with an independent server already to develop.
The most used ORM in Python, possibly the most complete is the Sqlalchemy. I suggest you study it, unless your project will be using Django, which has its own ORM which is much more convenient within Django projects.
-1
I would recommend Prostgresql, but Mysql is the most used in developing applications where speed is important (but this has changed with newer versions of Postgresql)while Postgresql stands out for being more robust and has much more features than Mysql.
-
1
I’m sorry to say, but from so many links on the Internet you picked up some "suffered" material, to put it politely. It is the suggestion of [Dit] the response bringing data on a technical basis, supported by quality and current material.
Browser other questions tagged python database python-3.x
You are not signed in. Login or sign up in order to post.
No better, it depends on what you need and which one meets your needs, but start with Sqlite3, which already has a native Python library.
– Woss
It depends on the architecture of your application. Do you want to have a database server machine or do you want to embed the database in your application? The overwhelming majority, if not all, of the DBMS may be.
– anonimo