Regular expression for price validation?

Question

Database

Good time of the day.
Help me write a regular expression.
The price must contain 7 digits, but it must be possible to enter a maximum of 2 decimal places.
For example:
5555555
555555.5
55555.55
Is it possible to solve this at all with regular expressions or do I need to look for some plugin?
Thanks in advance.

Answer 1

postgresql

Answer 2

In fact, almost any DBMS can be configured for these purposes.
Take MySQL 8.0 for example. Install the MySQL server and set the lowest level of transaction isolation - READ UNCOMMITED - to disable MVCC and, accordingly, increase concurrency. This server will accept data for writing.
Install another MySQL server - a replica (the main server, respectively, is the master). Read requests will be made to it.

Answer 3

Is the bottleneck exactly in the database? If so, then mongo scales horizontally, well, or just throw resources if the server is hard. If the bottleneck is not really there then think further. Well, it’s not clear what “big flow” means according to your version

Answer 4

Is it like this: https://regex101.com/r/ybA2gK/1