Answer the question
In order to leave comments, you need to log in
Which DBMS to choose for a small company?
Hello. I know that this question has been asked many times, but I myself could not decide for sure.
Essence of the question.
I need to make a program for a garment factory. She must keep all records of the plant (the arrival of fabrics, workers, accessories, expenses, shipments, and much more).
At the same time, 20 people will work in the program. (And even not at the same time).
But there are 4 computers in which seamstresses will constantly and simultaneously drive in their operations.
I don’t know how big the database should be, I have no experience. We now have an accounting program and it has a database for 2-3 years 150mb. There are 160 seamstresses at the factory so far and there will be more. every day they perform about 10 operations. And every month the salary will be considered.
I had experience with MYSQL (wrote an online store on it) but I'm not sure if it can handle it. I chose between MYSQL and PostgreSQL. I will write in python + PyQt. I am not a programmer, but self-taught. I want to start trying and if it works out, then make this program.
This is my first time asking a question on a toaster. Sorry if something is wrong.
ps
We use MySQL. No problems are observed.
Answer the question
In order to leave comments, you need to log in
Do it in mysql, once you've worked with it. Believe me, you will never run into performance.
In addition to pyqt, there is pyside
askubuntu.com/questions/140740/should-i-use-pyqt-o...
Look for an ORM to not depend on subds
www.python-camelot.com
One project is not an argument in favor of using muscle
MySQL with PostgreSL is a lot of crap. And I did not find any clear advantages for myself.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question