Re: [libreoffice-users] Re: Writing programs for Base

I do a bit of this, extracting data from accounting/stock reports and 
pumping it to a web page. I use 2 methods (again, not sure it matches 
your need), either perl scripts which are great for text when you want 
it automated or apache+php+mysql which is great when you want general 
user interaction.
steve

On 26/08/11 6:21 AM, mickelsen wrote:
> I'm very surprised to learn that Base is not a database program.  I
> guess it is just some sort of front end to "real" database programs,
> is that right?
>
> I guess this means that I'll have to get a real database program that
> I can write programs for in order to accomplish this project. Any
> suggestions as to what would be inexpensive and easy to work with?
>
> Thanks,
> Mark Mickelsen
>
> On Thu, Aug 25, 2011 at 2:28 AM, Andreas Säger [via Document
> Foundation Mail Archive]
> <ml-node+3283334-980602350-424438@n3.nabble.com>  wrote:
> > Since Base is not a database program, the first thing to know would be the
> > actual database to be used. An embedded HSQLDB is only one option, good
> > enough for simple demos and drafts but you don't really want to develop
> > anything serious for that.
> >
> > Every "common database" (MySQL, Postgre,... and HSQLDB too) provides access
> > to external text tables by means of database structures pulling their
> > content from plain text files.
> > You can create a view which selects the wanted records from the text table
> > in the right order of columns.
> > In Base you can drag or copy the view icon over the target table's icon and
> > hit "Create".
> > A set of example files dealing with csv, Base and Calc:
> > [Example] Loading CSV into preformatted spreadsheets
> > Files #1 and #2 resemble a text file linked to a (embedded) HSQLDB, editable
> > through an input form on a (embedded) Writer document.
> >
> > Using some "common database", any "common scripting language" can update the
> > database with very few lines of code. No 350MB office suite required for
> > that.
> >
> >
> > ________________________________
> > If you reply to this email, your message will be added to the discussion
> > below:
> > http://nabble.documentfoundation.org/Writing-programs-for-Base-tp3283165p3283334.html
> > To unsubscribe from Writing programs for Base, click here.
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Writing-programs-for-Base-tp3283165p3284661.html
> Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: users+help@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