Multiuser database editor?

Question

Database

Hello!

We need to make a database for the repository of biological samples. Roughly speaking, it is simply a table in which the barcode of the tube, date, author, sample name and other characteristics are entered. And that it was possible to search for all these fields. And so that several people can simultaneously work with this matter from different computers (on the same network). It would be very good if the date and the author were put down automatically when editing, so that you could track who did what and when. And if the editing history was preserved, as in a wiki, that would be completely excellent. Well, it is desirable that it itself be backed up with each input or every few minutes (although this can be arranged separately). Windows client machines, Ubuntu server.

I tried to look for ready-made programs for this business - there are millions of them, and almost all of them are cloud-based (which means that you have to share information with a kind uncle, plus it’s not clear how to backup), and besides, they cost so obscene money that they are even embarrassed to draw the price on the site. And the functionality of each program is its own and immense, so trying to choose between them is fraught with likening Buridan's donkey.

So I thought - is it possible to do this somehow simpler? I tried to start multi-user editing in libreoffice calc - it did not work, I did not understand why. Excel seems to require an Office 365 license, which we don't have. I suspect that this can be done in libreoffice base / microsoft access, but I only saw them in pictures.

Therefore, the question. How can you do the above with little blood? Base / access (if so, please throw me a sensible guide for dummies)? Or is there some kind of server software for co-editing tables? Perhaps warehouse software? Or, perhaps, someone knows specialized software for this task? Free software is desirable, or at least not very expensive.

Thanks in advance.

Answer 1

Google sheets?

Answer 2

Either Google tables, or some solution for 1C, or write something of your own, but it will definitely be more expensive at the start (about 100 times more expensive than a couple of licenses for one laboratory)
For example: 1C: Medicine. Clinical Lab
A MS Access and Libreoffice base are not multi-user bases.

Answer 3

libreoffice base of course (in Windows it is done on access). A book for dummies is swaying, reading, and playing around. Somehow I needed it, I (generally zero in access) after a couple of hours I already messed something up.
There are thousands of database engines, but it's the same to write yourself.

Answer 4

DokuWiki wiki engine with plugins Struct (or analogues: Data, Strata) and Bureaucracy (for creating a form for quickly entering information and creating a page).
One test tube - one wiki page. (kill the apsthenu)

Answer 5

If the task is exactly as stated in the question - ready-made combines are not needed for it, and Offices and their malignant tumors such as Access will create more problems than they solve. Not to mention monsters from 1C.
LEMP on Ubuntu.
Back on Laravel, for example, so as not to reinvent the wheel about authorization.
Front - at least on bare JS, at least on fashionable Vue.
A bootstrap will do for the design, it’s good to work here, not sell it.
One page where the user enters data, the second page that shows the finished data.
The history is ensured by the fact that the records in the table are not overwritten, but added if the data has changed.
And all...

Answer 6

Not really an answer.
Slava Rozhnev = Google Sheets
The simplest, but to have " the date and the author put down automatically when editing " is more difficult
. CityCat4 = libreoffice base and Vasily Bannikov = But MS Access and Libreoffice base are not multi-user databases.
Further perversion:
It is necessary to raise the database server. On MS Access, we create a database with a connection to the database engine (mssql, mysql, postgresql) via ODBC or DDE drivers - There is such an option in Access. There will be no tables in the Access file, there will be links to tables. If to all Access to put = it is expensive. Opening an Access file with libreoffice = buggy. And so that the " date and author are affixed when editing automatically"again, you need to come up with something.
BUT 15 years ago it worked like that)))