Connecting Multiple LibreOffice Base Users to a Remote Postgres Database

Started by Don Parrisover 12 years ago1 messagesgeneral
Jump to latest
#1Don Parris
parrisdc@gmail.com

Hi all,

I have been posting on my blog about getting LibreOffice Base and
PostgreSQL working together. My latest actually focuses on getting
multiple users connecting to a single, remote, stand-alone PostgreSQL
server. You can set this up fairly quickly and - in my case, anyway - with
no programming involved.

http://dcparris.net/2013/08/04/distributing-your-libreoffice-postgresql-database-across-systems-and-users-the-basics/

Of course, if you want to enforce business rules and security, you'll need
to employ server-side tools and programming, as well as possibly using Base
macros or Python on the client side. I am not yet certain about how to
implement transactions, so that (following the project below), one can
complete a form and press a "Submit" button to make the whole transaction
fire at once.

My previous post is not so much of a tutorial, but more of an opportunity
to showcase a small project using LibreOffice Base as a front-end to
PostgreSQL.

http://dcparris.net/2013/07/22/ill-call-it-ldinero/

In any case, I hope these will be of some use to others here. Please enjoy
and let me know if you need any clarification of any of my points.

Regards,
Don

--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/
<https://www.xing.com/profile/Don_Parris&gt;&lt;http://www.linkedin.com/in/dcparris&gt;
GPG Key ID: F5E179BE