This is a client/server application backing up to a SQL back-end
I am interested in the capabilities of LibreOffice Basic along the
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.
Adam Tauno Williams <mailto:firstname.lastname@example.org> GPG D95ED383
Systems Administrator, Python Developer, LPI / NCLA
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: 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