Setting up LibreOffice with H2 as the Database Engine
Have you ever wanted to have your own “in-house”/ “home-made” database shared with
your work colleagues allowing them simultaneous (concurrent) read/ write access to
the database? If so read on.
This is a very interesting project that allows for concurrent multi-user database
access, with the data residing locally in the network. It uses LibreOffice base as
the front end and H2 as the backend database engine.
(By the way, the H2 database is an amazing database engine: it’s got a tiny footprint,
amazing firepower, extremely easy to use and a thorough documentation that’s impossible
not to love).
This setup is ideal for small teams working with databases concurrently. Check the
below link for more detailed instructions.
We’ve been using the database at the office now for over a year with up 6 concurrent
users and it’s been working beautifully. I’ve dedicated a small clunky PC tower (however
this step is optional, as you can also use your own computer/ laptop) as the database
server (running H2). Also I connect to it if necessary (for example for a bi-weekly
reboot) via a remote desktop application (e.g. TeamViewer). This database setup works
really well and is ideal for a small office/ team environment with a data-centric
I believe that many more people would create concurrent databases with this set up
if they knew how. If you need a bit of help with your set-up feel free to send me
an email and pending time availability I’ll try provide some assistance.