A
A
Alexander Rublev2016-03-04 21:47:31
SQL
Alexander Rublev, 2016-03-04 21:47:31

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

5 answer(s)
A
Alexey Ukolov, 2016-03-04
@Meller008

Do it in mysql, once you've worked with it. Believe me, you will never run into performance.

A
Anton, 2016-03-05
Reytarovsky @Antonchik

MySQL

S
sim3x, 2016-03-04
@sim3x

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

B
beduin01, 2016-03-05
@beduin01

MySQL with PostgreSL is a lot of crap. And I did not find any clear advantages for myself.

A
androffka, 2017-01-04
@androffka

author, so what happened in the end? interesting result

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question