Re: [libreoffice-users] Serious application development with LibreOffice and LibreOffice Basic

> > 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:awilliam@whitemice.org> GPG D95ED383
Systems Administrator, Python Developer, LPI / NCLA


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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