Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

This is a client/server application backing up to a SQL back-end
I am interested in the capabilities of LibreOffice Basic along the
same lines.
The documentation for LibreOffice Basic seems very space compared to
An actual application with more logic than just CRUD would very
probably gain a lot if it was implemented in a rich, powerful language
such as Python which profits from a vast module library. Since the
Python API of LO (not only Base) is essentially undocumented, this
would require an actual GUI framework, however. 

Yep.  I stare at it occasionally thinking
man-i-bet-that-can-do-some-awesome-stuff... but the lack of
documentation is overwhelming.

I have double class wrapped each logical type of data record. One
level is the DB table class, which manages INSERT / UPDATE / SELECT
type operations with a consistent interface. The next class layer is
a Validation class which handles DB class to Form Control mapping
(to/from) and also performs data type validation on the fields, marks
bad data fields red/error, and so on. Also I make extensive use of
in-memory collection classes: Thing / Things classes, where the
Things class contains one/many Thing class object instances.
With Python and a decent RAD framework (there are quite a few), you
don't need to implement anything like that yourself. 

"and a decent RAD framework (there are quite a few)"

Really??? Name *ONE*.

ORMs are a no brainer;  SQLalchemy is simply fantastic.  But the UI part
of the RAD solution is seriously lacking.

At first I would like to use MySQL as the BE DB for use with
That's a B-A-D idea if you want to get your data back in a consistent
state with a certain reliability. Use PostgreSQL instead.

+1 PostgreSQL.

Adam Tauno Williams <> GPG D95ED383
Systems Administrator, Python Developer, LPI / NCLA

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.