A
A
Atomohodus2017-09-27 22:18:29
Database
Atomohodus, 2017-09-27 22:18:29

What technologies to choose to create a database?

Hi all!
At work, it became necessary to create a database with the ability to perform calculations based on the contents of the database.
The essence of the question is this: you need to create a database of ships, broken down by their types. The total number of ships is about 3500, each ship has about 50 characteristics (length, width, power, installed equipment, etc.). As a result, this database should have some kind of button interface for filling in, selecting data according to predetermined conditions (such as "all vessels from 50 to 100 m in length") and the ability to print the results of the selection and calculations in a readable version. Also, within the database, the results of calculations using predetermined formulas should be automatically calculated (after filling in the fields of ship properties required for calculations) in specially selected columns.
The situation is complicated by the fact that end users are 50+ engineers and they need a clear button-window interface to work with (quite elementary, not Microsoft SQL Server Management Studio), and I am a very beginner developer and do not know all the technologies. Please help.
-What technologies (of the quick learners) can be used to write a push-button interface?
-I am planning a database on MS SQL Server 2016, what technology is better to use to connect the interface and the database?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vyacheslav Uspensky, 2017-09-28
@Kwisatz

I would take PostgreSQL as a DB.
Java/node.js/php on the server
One page on the client.
However, we need a person with experience in designing good interfaces, as well as specialists in the above three points.
If you are a very beginner developer, then it might be worth ordering a study of such a solution (and judging by the choice of mssql, there is still a budget). Perhaps even according to the saas model. If you write, let's talk.

A
Artyom Karetnikov, 2017-09-28
@art_karetnikov

Access + MS SQL. At first, you could even just use Access, but there will be problems with heavy loads. For access, just simplicity, for a complete beginner, I don’t know anything simpler. c# is not for beginners. MS SQL is available in a free, express version.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question