[Solved] Database Implementation Question

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

[Solved] Database Implementation Question

Post by gkick »

Not sure which subforum this should go under ?

Win 10, Lo 7.3.2 HSQL 2.61

Hi,

Just as a matter of curiosity take the following situation.

Small time social or sportsclub member database with the treasurer, the president,the membership administrator possibly needing concurrent access.
However being small time there is no budget to maintain a web presence, no budget for internal IT, not even a small file server…

Now if the executives want to work at home Pc or Notebook, what options have they got to maintain system integrity of a split db
I read HSQL supports database replication (guess master-slave setup), anyone ever tried this?
Any other possibilities ?
Last edited by gkick on Wed Sep 07, 2022 4:59 pm, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Database Implementation Question

Post by Villeroy »

You need a computer accessible via VPN and HSQL running in server mode. This is the one and only setup allowing simultanious multi-user access.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Database Implementation Question

Post by gkick »

Thank you !
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Post Reply