> > This is a client/server application backing up to a SQL back-end > > database. > > I am interested in the capabilities of LibreOffice Basic along the > > same lines. > > The documentation for LibreOffice Basic seems very space compared to > > MS VBA. > 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 > > LibreOffice. > 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 <mailto:[email protected]> GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
