![Ditching a Microsoft Job to Enter Startup Hell with Lonewolf Engineer Sam Crombie [Podcast #171]](https://cdn.hashnode.com/res/hashnode/image/upload/v1746753508177/0cd57f66-fdb0-4972-b285-1443a7db39fc.png?#)
Is the database setup for small project development too complicated?
I am currently working on a small project in Python. During this process I have learned a lot and also discovered many problems, such as: (All the following questions are just my personal opinions, and everyone is welcome to give me suggestions.) First, for beginners, is the local configuration of various databases (MySQL is used as an example here) too complicated? And various unpredictable errors may occur in this process. Secondly, after the developer configures the database on the local computer, he still needs to learn the relevant syntax (for example, after the developer configures MySQL, he still needs to learn the relevant syntax). Of course, learning SQL syntax is very necessary for programming developers. However, for a developer who wants to quickly experience or quickly develop a web application, spending time learning SQL (if he has not learned SQL) will reduce his development efficiency and desire to learn. Also, when the developer has configured SQL on his computer and learned SQL syntax, but when he wants to use it, it is better to call MySQL through python. At this time, he needs to use a third-party library like pymysql to call MySQL through the third-party library, but this may result in a series of errors. Finally, if you overcome the difficulties mentioned above and some difficulties that have not been mentioned, you will find that for developing a small project, developers will only use a small part of MySQL's functions, or even only some extremely simple functions such as query, delete, modify and insert.
I am currently working on a small project in Python. During this process I have learned a lot and also discovered many problems, such as:
(All the following questions are just my personal opinions, and everyone is welcome to give me suggestions.)
First, for beginners, is the local configuration of various databases (MySQL is used as an example here) too complicated? And various unpredictable errors may occur in this process.
Secondly, after the developer configures the database on the local computer, he still needs to learn the relevant syntax (for example, after the developer configures MySQL, he still needs to learn the relevant syntax). Of course, learning SQL syntax is very necessary for programming developers. However, for a developer who wants to quickly experience or quickly develop a web application, spending time learning SQL (if he has not learned SQL) will reduce his development efficiency and desire to learn.
Also, when the developer has configured SQL on his computer and learned SQL syntax, but when he wants to use it, it is better to call MySQL through python. At this time, he needs to use a third-party library like pymysql to call MySQL through the third-party library, but this may result in a series of errors.
Finally, if you overcome the difficulties mentioned above and some difficulties that have not been mentioned, you will find that for developing a small project, developers will only use a small part of MySQL's functions, or even only some extremely simple functions such as query, delete, modify and insert.
