I am sitting here with another colleague in the office of a northern Germany tiny car producer while the rest of the colleagues is at home office not reaching the internal net via tunnel as there are too many of them…
Positive: the internal network is far better than ever before;-)
What I am thinking about for some months is to get rid of the central database and to use a distributed database with sending forth and back SQLite files.
I guess the synchronizing could be a nightmare.
So, I would have many sqlite files per user (GDPR and encrpytion needed!) and would have one client collecting those files and the data in those files.
I could get completely rid of the server database and the hole bureaucracy maintaining server databases.
File exchange would be done via network share (ok, one server needed;-).
Not to mention backup; must also be spread somehow.
Anyone have ideas, clues experience with distributed databases (without any database server)?
Keep well everyone!