O
O
Oleksandr2016-08-26 00:45:23
Database
Oleksandr, 2016-08-26 00:45:23

Expanding a database for dummies?

There is a certain program demanding availability of a DB for work.
When used on one computer, everything is solved using SQLite, so the user does not even need to know what a database is and that he uses it.
But if you need to work with a database on a local network for a dozen users at the same time, SQLite is no longer suitable, and for most users deploying MySQL becomes simply an unsolvable task.
As it turned out, even for companies with a dozen or two employees, the absence of an administrator is not uncommon.
At first, there was an idea to remotely configure everything myself, but on reflection, I came to the conclusion that there may be moments that require experience in administration and abandoned this idea.
Theoretically, as an option, you can use, for example, Microsoft Azure to deploy databases in the cloud - I set it up - users pay and use it. But here it is already necessary to understand whether it will beat off. Not all corporate clients are concerned about data synchronization (in this application, this may be convenient, but not at all necessary).
The question actually is - are there any installers for MySQL or a similar database that allow you to deploy the database in a few clicks?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Grigory Vasilkov, 2016-08-26
@gzhegow

in general, mysql can be managed through batch files.
on Linux, you can probably enter a list of commands and please - the muscle daemon is up and running.
but on Windows - well, if you get confused, it’s probably really possible to write a batch file that will first download your archive from FTP using the built-in tools of Windows, then it will start a silent installation, then it will register the user and do everything, and you just have to get from them the ability to connect to their computer.
but still you have to have a base with which they will all be synchronized and write a bunch of backend that will do this and hang it on the scheduler so that, well, directly without their participation.
probably some kind of cloudy thing would be much easier. if it is expensive for them there is always the phrase "we are very sorry"

R
Rou1997, 2016-08-26
@Rou1997

Just make detailed instructions with screenshots, and everyone will install and run MySQL without problems, but in principle it does not require installation, it is enough to make an SFX archive with a batch file, that is, unpack it into the desired folder, run it, create the necessary databases and tables, add it to startup - and all.
Usually, external access to the database is not used, clients interact with the server via HTTP or TCP / IP, of course this is more difficult, but then the problem with the database will disappear altogether.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question