Connecting Multiple LibreOffice Base Users to a Remote Postgres Database
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.
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><http://www.linkedin.com/in/dcparris>
GPG Key ID: F5E179BE